Cannot perform SHOW queries through Hortonworks ODBC driver with a kerberos-enabled cluster

[#1]

Hi,

I'm facing the following problem :

When I run SHOW queries through HortonWorks ODBC Driver with my kerberos-enable cluster, it returns an empty result (there is no error, just an empty result). However, I can perform SELECT queries, I can also run CREATE DATABASE or CREATE TABLE queries.

Note : I can perform SHOW queries using beeline client.

Note 2 : I tried to activate TRACE logging for the driver, and I get one error :

"Sep 28 18:48:03.508 ERROR 2741458688 Connection::SQLSetConnectAttr: [Hortonworks][ODBC] (11470) Transactions are not supported."

Any idea ?

Thanks in advance,

Sylvain.

[#2]

Are you using tableau to run your hive query?

[#3]

No, I'm using my own software based on Hortonworks ODBC driver (SHOW queries used to work without kerberos).

[#4 · Accepted solution]

Ok I have the solution.

We were using ODBC via OTL and so we needed to set a particular flag "ImplicitSelect" to "true" directly on the connection level. When this flag is not set, "SHOW" queries return empty results.

Thanks,

Sylvain.