how to connect to hive

KNIME Analytics Platform
1

Hi guys:

   Now,I have a question about connecting to hive .I can connect  to hive by a sample java application .but using Kinme don't work ,please help me !

  java application:

   Class.forName("org.apache.hadoop.hive.jdbc.HiveDriver");

    Connection con = DriverManager.getConnection("jdbc:hive://192.168.136.134:10000/default", "", "");

java application is ok

However in knime (import all .jar as same as java application )the error is:

 Could not create connection to database: org.apache.hadoop.hive.metastore.api.MetaException

 

 

2

Hi,

you have to add all required libraries into the ext path of the KNIME java directory. For more details see this related post.

Another option is to use the commercial Big Data Connectors that include all necessary librarires and that are certified by Cloudera, Hortonworks and MapR.

Bye,

Tobias