Support Questions

Find answers, ask questions, and share your expertise

HiveServer2: Could not open client transport with JDBC Uri

avatar
Contributor

I have problems with HiveServer2 in Ambari. When I start the service, HiveServer2 runs during several minutes and then the service gets stopped.

Connection failed on host eureambarislave1.local.eurecat.org:10000 (Traceback (most recent call last): File "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/alerts/alert_hive_thrift_port.py", line 212, in execute ldap_password=ldap_password) File "/usr/lib/python2.6/site-packages/resource_management/libraries/functions/hive_check.py", line 81, in check_thrift_port_sa...

I tried to execute the beeline command from terminal:

[root@eureambarislave1 hive]# beeline -u jdbc:hive2://eureambarislave1.local.eurecat.org:10000/;transportMode=binary

Connecting to jdbc:hive2://eureambarislave1.local.eurecat.org:10000/ 18/04/14 16:24:17 [main]: WARN jdbc.HiveConnection: Failed to connect to eureambarislave1.local.eurecat.org:10000 Error: Could not open client transport with JDBC Uri: jdbc:hive2://eureambarislave1.local.eurecat.org:10000/: java.net.ConnectException: Connection refused (Connection refused) (state=08S01,code=0) Beeline version 1.2.1000.2.6.4.0-91 by Apache Hive 0:

jdbc:hive2://eureambarislave1.local.eureca (closed)>

Also I tried to start HiveServer2 manually, but it gets stuck at "nohup: ignoring input and appending output to ‘nohup.out’":

[root@eureambarislave1 hive]# su $HIVE_USER

[root@eureambarislave1 hive]# nohup /usr/hdp/current/hive-server2/bin/hiveserver2 -hiveconf hive.metastore.uris=/tmp/hiveserver2HD.out 2 /tmp/hiveserver2HD.log

nohup: ignoring input and appending output to ‘nohup.out’

Finally I checked the port 10000, but there is no output:

[root@eureambarislave1 hive]# netstat -tnlpa | grep 10000

This is the output of HiveServer2 logs:

2018-04-14 08:53:52,032 INFO [main]: server.HiveServer2 (HiveStringUtils.java:startupShutdownMessage(693)) - STARTUP_MSG: /************************************************************

STARTUP_MSG: Starting HiveServer2 STARTUP_MSG: host = eureambarislave1.local.eurecat.org/192.168.0.10 STARTUP_MSG: args = [--hiveconf, hive.aux.jars.path=file:///usr/hdp/current/hive-webhcat/share/hcatalog/hive-hcatalog-core.jar, -hiveconf, hive.metastore.uris= , -hiveconf, hive.log.file=hiveserver2.log, -hiveconf, hive.log.dir=/var/log/hive] STARTUP_MSG: version = 1.2.1000.2.6.4.0-91

1 REPLY 1

avatar
New Contributor

I am having the exact same issue. Have you had any luck resolving it?