Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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

New Contributor

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.