Hive Connection from Thingworx using JDBC Driver

[schathoth-2]

Hi Team,

I am trying to connect to Hive tables from ThingWorx using the JDBC connection.

Connection details,

JDBC Driver Class Name : org.apache.hive.jdbc.HiveDriver

JDBC Connection String : jdbc:hive2://<server name>/default;transportMode=http;ssl=true;httpPath=/hive2

connectionValidationString : SELECT CURRENT_DATE

Database User Name : <username>

Database Password : <password>

Error in Application log,

Unable to Invoke Service Test on AzureDevJDBCConnectionThing : null

Error Getting Tables : Cannot get a connection, pool error Unable to validate object

Appreciate if you an help me to resolve this issue.

Note:  I am able to connect to hive tables using dbvisualizer tool from my system.

[Constantine]

Hello @schathoth-2,

FWIW there was a similar question in 2015: https://community.ptc.com/t5/ThingWorx-Developers/How-to-setup-to-connect-apache-hive-server-with-JDBC/td-p/523102

It turned out that Hive JDBC driver didn't support one of the methods that ThingWorx is using to execute prepared statements. At the same time, it looks like the issue was solved in the driver also in 2015: https://issues.apache.org/jira/browse/HIVE-10726

Are you using a recent version of Hive JDBC driver?

/ Constantine

[schathoth-2]

Hi @Constantine 

Thank you for your reply. I was able to fix the connection with a recent version of the jar. I am able to see the table in the tables tab, but now getting a different error.

Error: Unable to Invoke Service Test on AzureDataLakeDevJDBCThing : Method not supported

Execute

I came across the same issue in this link. Any recommendation?

https://community.ptc.com/t5/ThingWorx-Developers/thingworx-hadoop-connectivity/td-p/553668