Support Questions
Find answers, ask questions, and share your expertise

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.