question Cannot perform SHOW queries through Hortonworks ODBC driver with a kerberos-enabled cluster in Archives of Support Questions (Read Only)

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

dvt_isoft — Fri, 29 Sep 2017 00:06:44 GMT

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.

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

optex — Fri, 29 Sep 2017 00:22:52 GMT

Are you using tableau to run your hive query?

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

dvt_isoft — Fri, 29 Sep 2017 14:05:11 GMT

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

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

dvt_isoft — Fri, 29 Sep 2017 19:28:10 GMT

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.