Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

ODBC clients can't query tables with Row Format Serde

ODBC clients can't query tables with Row Format Serde

New Contributor

Using the Quest product, Toad Data Point as a SQL client with the Hortonworks ODBC 2.6 driver. I can't select data from any Hive table that uses a Row Format Serde '<serde class>' The same tables behave as expected in beeline and jdbc windows clients. My suspicion is the connection can't find the serde class jar file, but I don't know how to configure it.  Simple test script attached.

 

The only thing I've tried is to copy hive-serde.jar to /usr/hdp/current/hive-webhcat/share/hcatalog. That folder is referenced as $HIVE_AUX_JARS_PATH

 

Any ideas on what I could try? Thanks

1 REPLY 1
Highlighted

Re: ODBC clients can't query tables with Row Format Serde

New Contributor

We resolved this be adding "UseNativeQuery=1" to the ConnectionString in Toad's connection property.

Don't have an account?
Coming from Hortonworks? Activate your account here