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