question

JakubK-7942 avatar image
0 Votes"
JakubK-7942 asked PRADEEPCHEEKATLA-MSFT commented

databricks/simba jdbc driver - warnings/error messages

I've setup a sql ide (workbench/j) for my sparksql databricks querying - writing code in a web page textarea control is just not for me...

https://docs.microsoft.com/en-us/azure/databricks/integrations/bi/workbenchj

i'm getting this warning/error from every query
Warnings:
[Simba][SparkJDBCDriver](500312) Error in fetching data rows: [Simba][SparkJDBCDriver](500312) Error in fetching data rows: Thrift column information request error;;


is there something i've misconfigured?

azure-databricks
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @JakubK-7942 ,

Welcome to the Microsoft Q&A platform.

The error is a generic error so hard to determine exactly what the issue is.

Could you please share the complete details about our scenario like:

  • Query which are trying to execute?

  • Complete stack trace of the error message or screenshot of the error message?


0 Votes 0 ·

Hi, that's it for the error message
sometimes i get the same one twice

Warnings:
[Simba][SparkJDBCDriver](500312) Error in fetching data rows: [Simba][SparkJDBCDriver](500312) Error in fetching data rows: Thrift column information request error;;

SELECT executed successfully

Execution time: 7.79s

it happens for all queries, even simple

select * from <a databricks table>


the query runs and i get the resultset back, but it's always accompanied by this error


do you get this error when using workbench/j?

0 Votes 0 ·
JakubK-7942 avatar image
1 Vote"
JakubK-7942 answered PRADEEPCHEEKATLA-MSFT commented

i ticked the 'suppress warnings' checkbox in the connection driver settings. It's gone now :)

87526-simpsonscel.gif



simpsonscel.gif (861.1 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @JakubK-7942,

Glad to know that your issue has resolved. And thanks for sharing the solution, which might be beneficial to other community members reading this thread.


Do click on Accept Answer and Up-Vote on the post that helps you, this can be beneficial to other community members.

0 Votes 0 ·

Hello @JakubK-7942,

Following up to see did you get a chance to click Accept Answer .

0 Votes 0 ·
PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @JakubK-7942,

I didn't notice the same behaviour from my end.

I'm able to execute multiple queries on SQL WorkbenchJ without any issue.

86102-adb-sqlworkbenchj.gif

Hope this helps. Do let us know if you any further queries.


Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.


adb-sqlworkbenchj.gif (910.7 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

hmm

my workbenchj version is build 127
java version is 1.8.0_241 (64bit)

driver is sparkJDBC42.jar

cluster info : 7.3 LTS


jdbc:spark://adb-xxx.2.azuredatabricks.net:443/default;transportMode=http;ssl=1;httpPath=sql/protocolv1/o/xxx/xxx;AuthMech=3;UID=token;PWD=xxx


is there anything there might might be causing the problem?

0 Votes 0 ·

Hello @JakubK-7942,

I had tested with same version which you are using but, unfortunately I would not find any warning/error message as shown above.

This issue looks strange. For a deeper investigation and immediate assistance on this issue, if you have a support plan you may file a support ticket.

0 Votes 0 ·