databricks/simba jdbc driver - warnings/error messages

Jakub K 101

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://learn.microsoft.com/en-us/azure/databricks/integrations/bi/workbenchj

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

is there something i've misconfigured?

PRADEEPCHEEKATLA-MSFT 78,576 Reputation points Microsoft Employee

2021-04-08T09:19:39.19+00:00
Hello @Jakub K ,

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?
Jakub K 101 Reputation points

2021-04-09T00:43:41.523+00:00

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

Warnings:
[Simba]SparkJDBCDriver Error in fetching data rows: [Simba]SparkJDBCDriver 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?

Accepted answer

Jakub K 101 Reputation points

2021-04-14T03:18:32.8+00:00

i ticked the 'suppress warnings' checkbox in the connection driver settings. It's gone now :)
Please sign in to rate this answer.

1 person found this answer helpful.
PRADEEPCHEEKATLA-MSFT 78,576 Reputation points Microsoft Employee

2021-04-14T05:30:23.467+00:00

Hello @Jakub K ,

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.

PRADEEPCHEEKATLA-MSFT 78,576 Reputation points Microsoft Employee

2021-04-15T10:14:51.677+00:00

Hello @Jakub K ,

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

1 additional answer

PRADEEPCHEEKATLA-MSFT 78,576 Reputation points Microsoft Employee

2021-04-09T05:25:02.613+00:00

Hello @Jakub K ,

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

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

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.
Please sign in to rate this answer.
Jakub K 101 Reputation points

2021-04-09T05:46:47.13+00:00

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?

PRADEEPCHEEKATLA-MSFT 78,576 Reputation points Microsoft Employee

2021-04-12T04:25:54.123+00:00

Hello @Jakub K ,

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.
Sign in to comment