Details
-
Bug
-
Status: Open
-
Critical
-
Resolution: Unresolved
-
3.1.3
-
None
-
None
-
- hive version 3.1.0.3.0.1.0-187
- success – hive jdbc used 3.0.0 –
- success – hive jdbc used 2.0.0 –
- success – hive jdbc used 2.1.0 –
- success – hive jdbc used 2.2.0 –
- success – hive jdbc used 2.1.1 –
- connection.setUrl(
- "jdbc:hive2://xen188-hdp30-centos7:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2"
- hive version 1.2.1000.2.6.0.3-8
- failed – hive jdbc used 3.0.0 –
- success – hive jdbc used 2.0.0 –
- success – hive jdbc used 2.1.0 –
- failed – hive jdbc used 2.2.0 –
- failed – hive jdbc used 2.1.1 –
- connection.setUrl(
- "jdbc:hive2://rack167-hdp26-dev:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2"
- );
hive version 3.1.0.3.0.1.0-187 success – hive jdbc used 3.0.0 – success – hive jdbc used 2.0.0 – success – hive jdbc used 2.1.0 – success – hive jdbc used 2.2.0 – success – hive jdbc used 2.1.1 – connection.setUrl( "jdbc:hive2://xen188-hdp30-centos7:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2" hive version 1.2.1000.2.6.0.3-8 failed – hive jdbc used 3.0.0 – success – hive jdbc used 2.0.0 – success – hive jdbc used 2.1.0 – failed – hive jdbc used 2.2.0 – failed – hive jdbc used 2.1.1 – connection.setUrl( "jdbc:hive2://rack167-hdp26-dev:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2" );
Description
Unable to create a connection using the Ambari JDBC URL (port 2181). Working fine with the default port 10000.
Please look into the environment details (found after doing a lot of hit-and-trial) and attached files to further investigate the issue.
Using a higher hive-jdbc version results in conflicts while deploying the project.
Our R&D concluded that the issue mainly lies with the zookeeper jar.