HiveDriverError: Unsupported result format: undefined

[nisha-singh-tredence]

Any one idea how can i resolve it.
please help to resolved out

[kravets-levko]

Hi @nisha-singh-tredence! Can you please provide some more information? If possible - code snippet you're trying to run (minimum required to reproduce the issue), whatever output you get from your code, library version, databricks runtime version, output of DESCRIBE TABLE EXTENDED for table you run your query against (please remember to remove sensitive data before sharing it here). Thank you!

[nisha-singh-tredence]

Hello @kravets-levko ,
Thanks for replying.
I have attached code snippet please have a look and suggest me what should i do to resolve this bugs.

[kravets-levko]

Thank you @nisha-singh-tredence! I need to ask you for some more help with debugging this. Could you please find a node_modules/@databricks/sql/dist/DBSQLOperation/SchemaHelper.js file, near its end there is a fragment like this:

default:
  throw new HiveDriverError_1.default(`Unsupported result format: ${TCLIService_types_1.TSparkRowSetType[resultFormat]}`);

Please add

console.dir(resultFormat);
console.dir(TCLIService_types_1.TSparkRowSetType);

right before throw statement, run your code again and share its output. Thank you!

[nisha-singh-tredence]

Okay here is output file

[nisha-singh-tredence]

Hi @kravets-levko ,
Anything else you need ?

Thanks!

[kravets-levko]

Thank you! That's very, very wrong, though 🤔 resultFormat should never be null. However, this proves that the problem is not in the library, it comes from either the endpoint you're using, or whatever is between the library and endpoint (like proxy) if there are any. So what I can suggest you right here:

1. Try to run the same query with the same credentials, but using PySQL (databricks/databricks-sql-python). If by any chance it will work properly - I'll try to find what it handles differently
2. Contact your Databricks manager - if that's an issue with your DB instance, they'll be able to help you more than me.

[nisha-singh-tredence]

okay i will try and update you

[nisha-singh-tredence]

Hi @kravets-levko ,
It's working fine with python
but it through error with Node JS

[kravets-levko]

Internal ticket number: PECO-619

[sangeeta98]

I am facing same issue. Please let me know when we can expect the fix for the same.

[sangeeta98]

Internal ticket number: PECO-619

Please let us know when the fix is expected. I can provide you details. The python code is working with same properties but nodejs code is not. We are stuck with delivery and need a workaround or fix soon. Cannot change technology, has to be nodejs.
Please help.

[ychacha]

Any update on this issue - Internal ticket number: PECO-619?

I have two clusters, one with runtime v7.3 and another with v11.3, it works fine on v11.3 and on v7.3 it gives "HiveDriverError: Unsupported result format: undefined" error. Hope this helps in troubleshooting the issue, Thanks!

[mbluemer]

I have two clusters, one with runtime v7.3 and another with v11.3, it works fine on v11.3 and on v7.3 it gives "HiveDriverError: Unsupported result format: undefined" error. Hope this helps in troubleshooting the issue, Thanks!

Same here. Our queries are working on 11.3 but not on 7.3, failing with the error "Unsupported result format: undefined"

[kravets-levko]

Sorry for not getting back for a while. So, I want to ask you to upgrade to latest version of the library, and check if the issue is still present there. Please let me know in either case. Thank you!

[lokesh20018]

The issue is still present

giving more context: I'm able to connect Databricks with Tableau Desktop using ODBC driver and run SQL commands, but i'm facing problem when trying to connect the same DB with databricks-sql-nodejs driver.

Attaching below the screenshot of the error. Let me know if you need more details.