Hi @gdelon, that worked, thanks ! It’s weird though, CentOS shell seems to do something with the unquoted string, I can’t see what. It also works if you quote only the semi-colon part of the url. Semi-colon is the culprit. Ok 🙂 beeline -u jdbc:hive2://sandbox.hortonworks.com:2181/';serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2' So it works from within the docker inside the VM. So at least the configuration is correct for this case. Now how could the same jdbc url work from outside that box ? Any clue anyone ? Thanks ... View more

I cant connect, I cant connect! Two days spent googling and searching, and I cant connect to Hive using JDBC. I’m pretty sure it’s a configuration error, but I cant find where and what. I putty’ed into the docker HDP Sandbox and tried to connect from there, but it failed too! [root@sandbox /]# cat /etc/hosts 127.0.0.1 localhost ::1 localhost ip6-localhost ip6-loopback fe00::0 ip6-localnet ff00::0 ip6-mcastprefix ff02::1 ip6-allnodes ff02::2 ip6-allrouters 172.17.0.2 sandbox.hortonworks.com [root@sandbox /]# netstat -an | grep 2181 tcp 0 0 172.17.0.2:51006 172.17.0.2:2181 ESTABLISHED tcp 0 0 172.17.0.2:41062 172.17.0.2:2181 ESTABLISHED tcp 0 0 172.17.0.2:44137 172.17.0.2:2181 ESTABLISHED tcp 0 0 :::2181 :::* LISTEN tcp 0 0 ::ffff:172.17.0.2:2181 ::ffff:172.17.0.2:44137 ESTABLISHED tcp 0 0 ::ffff:172.17.0.2:45391 ::ffff:172.17.0.2:2181 ESTABLISHED tcp 0 0 ::ffff:172.17.0.2:2181 ::ffff:172.17.0.2:41062 ESTABLISHED tcp 0 0 ::ffff:172.17.0.2:2181 ::ffff:172.17.0.2:45391 ESTABLISHED tcp 0 0 ::ffff:172.17.0.2:2181 ::ffff:172.17.0.2:51006 ESTABLISHED Port 2181 seems to be listening on ipv6 only, is that right? Beelining, using the very jdbc URL Ambari grives me, fails… [root@sandbox /]# beeline --verbose=true -u jdbc:hive2://sandbox.hortonworks.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 issuing: !connect jdbc:hive2://sandbox.hortonworks.com:2181/ '' [passwd stripped] Connecting to jdbc:hive2://sandbox.hortonworks.com:2181/ 18/01/15 17:26:44 [main]: WARN jdbc.HiveConnection: Failed to connect to sandbox.hortonworks.com:2181 Error: Could not open client transport with JDBC Uri: jdbc:hive2://sandbox.hortonworks.com:2181/: null (state=08S01,code=0) java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://sandbox.hortonworks.com:2181/: null at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:217) at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:155) at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:208) at org.apache.hive.beeline.DatabaseConnection.connect(DatabaseConnection.java:146) at org.apache.hive.beeline.DatabaseConnection.getConnection(DatabaseConnection.java:211) at org.apache.hive.beeline.Commands.connect(Commands.java:1190) at org.apache.hive.beeline.Commands.connect(Commands.java:1086) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hive.beeline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:52) at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:989) at org.apache.hive.beeline.BeeLine.initArgs(BeeLine.java:714) at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:776) at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:490) at org.apache.hive.beeline.BeeLine.main(BeeLine.java:473) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:233) at org.apache.hadoop.util.RunJar.main(RunJar.java:148) Caused by: org.apache.thrift.transport.TTransportException at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132) at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86) at org.apache.thrift.transport.TSaslTransport.receiveSaslMessage(TSaslTransport.java:178) at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:307) at org.apache.thrift.transport.TSaslClientTransport.open(TSaslClientTransport.java:37) at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:193) ... 24 more Beeline version 1.2.1000.2.5.0.0-1245 by Apache Hive Can anyone help me please? Thanks ... View more

More info: On the console, I get the following error while trying to connect: ERROR Utils Unable to read HiveServer2 configs from ZooKeeper ... View more

Thank you I tried jdbc:hive2://zk=myip:2181/hiveserver2 This gave me, as I feared, an “unknown host” error. I use the Apache JDBC driver 2.3.2. I also tried jdbc:hive2://myip:2181/hiveserver2 That gave me (using Squirrel) Unexpected Error occurred attempting to open an SQL connection. class org.apache.thrift.transport.TTransportException: null The url I use is the one given by Ambari in the Hive summary for my config. Why couldn’t I use it directly ? jdbc:hive2://sandbox.hortonworks.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 ... View more