[
https://issues.apache.org/jira/browse/HIVE-23360?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ayush Saxena resolved HIVE-23360.
---------------------------------
Fix Version/s: NA
Resolution: Not A Problem
Either it is Ambari problem or as your team concluded it is ZK problem, In
neither cases it is a Hive problem
> 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
> Affects Versions: 3.1.3
> 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
> Priority: Critical
> Fix For: NA
>
> 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.20.10#820010)
