Support Questions
Find answers, ask questions, and share your expertise

How connect LLAP HA JDBC

How connect LLAP HA JDBC

Explorer

HDP 3.1, jdbc:hive2://master1:2181,master2:2181,master3:2181/;serviceDiscoveryMode=zooKeeperHA;zooKeeperNamespace=hs2ActivePassiveHA

I use hive-jdbc-3.1.0.3.1.0.0-78-standalone.jar in dbVisualizer can't connect db, but non-HA is OK.

An error occurred while establishing the connection:

Details:
Type: java.lang.reflect.UndeclaredThrowableException

Stack Trace:
java.lang.NoClassDefFoundError: Could not initialize class org.apache.hadoop.hive.conf.HiveConf
at org.apache.hive.service.server.HS2ActivePassiveHARegistryClient.getClient(HS2ActivePassiveHARegistryClient.java:40)
at org.apache.hive.jdbc.ZooKeeperHiveClientHelper.configureConnParamsHA(ZooKeeperHiveClientHelper.java:163)
at org.apache.hive.jdbc.ZooKeeperHiveClientHelper.configureConnParams(ZooKeeperHiveClientHelper.java:137)
at org.apache.hive.jdbc.Utils.configureConnParamsFromZooKeeper(Utils.java:511)
at org.apache.hive.jdbc.Utils.parseURL(Utils.java:334)
at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:237)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:107)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.onseven.dbvis.g.B.D.ā(Z:1548)
at com.onseven.dbvis.g.B.F$A.call(Z:1369)
[wrapped] java.lang.Exception: java.lang.NoClassDefFoundError: Could not initialize class org.apache.hadoop.hive.conf.HiveConf
at com.onseven.dbvis.g.B.F$A.call(Z:2374)
at java.util.concurrent.FutureTask.run(Unknown Source)
[wrapped] java.lang.reflect.UndeclaredThrowableException
at com.sun.proxy.$Proxy5.connect(Unknown Source)
at com.onseven.dbvis.db.I.H.Ŋ(Z:154)
at com.onseven.dbvis.db.I.H.Ĵ(Z:1692)
at com.onseven.dbvis.db.I.K.Ĵ(Z:3063)
at com.onseven.dbvis.db.I.D.ĵ(Z:1756)
at com.onseven.dbvis.K.C.Z.ĭ(Z:2713)
at com.onseven.dbvis.K.C.K.Ă(Z:1374)
at com.onseven.dbvis.K.C.K.doInBackground(Z:1521)
at javax.swing.SwingWorker$1.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at javax.swing.SwingWorker.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)