how to use KNIME to fetch tables in hive

KNIME Analytics Platform
#1

Hello:
I used org.apache.hadoop.hive.jdbc.HiveDriver" as the datebase driver when I used the node “DateBase Reader” in KNIME.
I set the "DateBase URL " , “user name” and “password” well.
The SQL Statement shows like this:
Select * from tmp

But , it just didn’t work!

The Console shows:
WARN Database Reader java.sql.SQLException: org.knime.core.node.InvalidSettingsException: Driver “org.apache.hadoop.hive.jdbc.HiveDriver” does not accept URL: jdbc:hive://10.20.134.188:10000/default

Can anybody help me ?
Thank you!

#2

Could anybody help me ?

#3

Hi chakey,
For me it looks correct. Are you able to connect to your database using a small simple Java program. How do you usually connect to your Hive database?
Cheers, Thomas

#4

Hi gabriel :
thanks for your answer.

I can connect the mysql database.

And in my java program the DataBase URL just as: jdbc:hive://10.20.134.188:10000/default
it works in the java program.

But in KINIME , i dont know why it shows a waring like :
WARN Database Reader java.sql.SQLException: org.knime.core.node.InvalidSettingsException: Driver “org.apache.hadoop.hive.jdbc.HiveDriver” does not accept URL: jdbc:hive://10.20.134.188:10000/default

Any other hints?

Thanks Sincerely.

#5

I have successed to using KNIME with Hive(Hadoop) on JDBC.
Jars which are needed for using JDBC driver sould be placed on <knime_install_dir>/jre/lib/ext/*.

D:\knime_2.3.0\jre\lib\ext>ls -la
total 8965
drwx------+ 1 00962724 hadoop       0 Feb 10 03:40 .
drwx------+ 1 00962724 hadoop       0 Feb 10 04:39 ..
-rwx------+ 1 00962724 hadoop  261809 Oct 24 16:15 commons-lang-2.4.jar
-rwx------+ 1 00962724 hadoop   60841 Nov 22  2007 commons-logging-1.1.1.jar
-rwx------+ 1 00962724 hadoop   52313 Nov 22  2007 commons-logging-api-1.1.1.jar
-rwx------+ 1 00962724 hadoop    8239 Dec  2 17:44 dnsns.jar
-rwx------+ 1 00962724 hadoop 2858220 Feb 10 02:50 hadoop-core-0.20.2-320.jar
-rwx------+ 1 00962724 hadoop   20597 Oct 28 18:02 hive-common-0.7.0.jar
-rwx------+ 1 00962724 hadoop 2578668 Oct 31 02:46 hive-exec-0.7.0.jar
-rwx------+ 1 00962724 hadoop  799849 Oct 28 18:03 hive-metastore-0.7.0.jar
-rwx------+ 1 00962724 hadoop  415192 Oct 28 18:03 hive-serde-0.7.0.jar
-rwx------+ 1 00962724 hadoop  106705 Oct 28 18:03 hive-service-0.7.0.jar
-rwx------+ 1 00962724 hadoop   34251 Oct 28 18:02 hive-shims-0.7.0.jar
-rwx------+ 1 00962724 hadoop  114342 Feb  9 18:06 libfb303.jar
-rwx------+ 1 00962724 hadoop  169666 Feb  9 18:06 libthrift.jar
-rwx------+ 1 00962724 hadoop  832997 Dec  2 17:44 localedata.jar
-rwx------+ 1 00962724 hadoop  391834 Feb 19  2010 log4j-1.2.15.jar
-rwx------+ 1 00962724 hadoop     521 Dec  2 17:44 meta-index
-rwx------+ 1 00962724 hadoop  170239 Dec  2 17:44 sunjce_provider.jar
-rwx------+ 1 00962724 hadoop   33668 Dec  2 17:44 sunmscapi.jar
-rwx------+ 1 00962724 hadoop  231749 Dec  2 17:44 sunpkcs11.jar

D:\knime_2.3.0\jre\lib\ext>

#6

We had a problem in the database integration supporting HIVE since KNIME 2.3.3 which will be fixed with KNIME 2.7.2 coming out soon.