Member since
11-12-2019
2
Posts
0
Kudos Received
0
Solutions
11-19-2019
01:20 PM
We resolved this be adding "UseNativeQuery=1" to the ConnectionString in Toad's connection property.
... View more
11-12-2019
11:58 AM
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
... View more
- Tags:
- hive-serde
- odbc
Labels:
- Labels:
-
Hortonworks Data Platform (HDP)