I am trying to establish JDBC connection to Hive of CDH4.6 with spagoBI,but
when try to create data source in spagoBI ,i got an error
service error org.apache.hadoop.hive.jdbc.HiveDriver
I have included following jar in my /spagoBI-server-4.2/lib folder
1. hadoop-core-2.0.0-mr1-cdh4.6.0.jar
2. hive-common-0.10.0-cdh4.6.0.jar
3. hive-metastore-0.10.0-cdh4.6.0.jar
4. hive-exec-0.10.0-cdh4.6.0.jar
5. hive-service-0.10.0-cdh4.6.0.jar
6. hive-jdbc-0.10.0-cdh4.6.0.jar
7. antlr-runtime-3.4.jar
8. commons-logging-1.1.1.jar
9. commons-logging-api-1.1.jar
When I try connecting to Hive using beeline,i am able to see my tables.
beeline> !connect jdbc:hive://192.168.10.110:10000/default "" "" ""
scan complete in 30ms
Connecting to jdbc:hive://192.168.10.110:10000/default
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in
[jar:file:/usr/lib/zookeeper/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in
[jar:file:/usr/lib/hive/lib/slf4j-log4j12-1.6.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an
explanation.
Connected to: Hive (version 1)
Driver: Hive (version 0.10.0-cdh4.6.0)
Error: Method not supported (state=,code=0)
Error: Method not supported (state=,code=0)
Error: Method not supported (state=,code=0)
0: jdbc:hive://192.168.10.110:10000/default> show tables;
+------------+
| tab_name |
+------------+
| forex2 |
| hpv_1 |
| sample_07 |
| sample_08 |
+------------+
4 rows selected (1.337 seconds)
some more google shows above error[
http://stackoverflow.com/questions/19525071/classnotfoundexception-when-connecting-hive-from-a-java-client]
<http://stackoverflow.com/questions/19525071/classnotfoundexception-when-connecting-hive-from-a-java-client>
and [JDBC-conection][
http://stackoverflow.com/questions/22431984/unable-to-establish-a-jdbc-connection-to-hive-from-eclipse
],It seems to me a classpath error or hadoop-*-core.jar(because i am using
cloudera),i have included following classpath before calling
./spagoBIStartup.sh
HADOOP_CORE={{ls $HADOOP_HOME/hadoop-*-core.jar}}
CLASSPATH=.:$HADOOP_CORE:$HIVE_HOME/conf
for i in ${HIVE_HOME}/lib/*.jar ; do
CLASSPATH=$CLASSPATH:$i
done
Anything Missing for JDBC-HIVE connectivity in SpagoBI ?,thanks.
-Thanks.
Ashish
