cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X

Hive Connection from Thingworx using JDBC Driver

schathoth-2
7-Bedrock

Hive Connection from Thingworx using JDBC Driver

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

 

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.
 

 

2 REPLIES 2

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

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
 

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

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

Announcements


Top Tags