[jira] [Created] (HIVE-23360) Unable to create Connection using the Ambari default PORT (working fine if Port is taken as 10000)

["Sukhpreet Kaur (Jira)" <ji...@apache.org>]

Sukhpreet Kaur created HIVE-23360:
-------------------------------------

             Summary: Unable to create Connection using the Ambari default PORT (working fine if Port is taken as 10000)
                 Key: HIVE-23360
                 URL: https://issues.apache.org/jira/browse/HIVE-23360
             Project: Hive
          Issue Type: Bug
          Components: Hive, HiveServer2, JDBC
         Environment: # 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"
 * );
            Reporter: Sukhpreet Kaur
         Attachments: HiveConnection.java, MainClass.java, build.gradle

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.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)