Skip to main content
S
schathoth-21-Visitor
1-Visitor
February 28, 2020
Question

Hive Connection from Thingworx using JDBC Driver

  • February 28, 2020
  • 2 replies
  • 1670 views

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

C
Constantine18-Opal
18-Opal
March 2, 2020

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

S
schathoth-21-VisitorAuthor
1-Visitor
March 2, 2020

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

Terms & ConditionsAccessibility statement