Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

Sandbox refusing connection in http mode.

avatar
Contributor

In my HDP 2.3.2 Sandbox with no authorization for HiveServer2, I'm attempting to enable http mode, but connections are being "refused". See error thrown by beeline.

[root@sandbox ~]# beeline -u jdbc:hive2://sandbox.hortonworks.com:10001/default;transportMode=http;httpPath=cliservice

SLF4J: Class path contains multiple SLF4J bindings.

SLF4J: Found binding in [jar:file:/usr/hdp/2.3.2.0-2950/spark/lib/spark-assembly-1.4.1.2.3.2.0-2950-hadoop2.7.1.2.3.2.0-2950.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: Found binding in [jar:file:/usr/hdp/2.3.2.0-2950/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.

SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]

WARNING: Use "yarn jar" to launch YARN applications.

SLF4J: Class path contains multiple SLF4J bindings.

SLF4J: Found binding in [jar:file:/usr/hdp/2.3.2.0-2950/spark/lib/spark-assembly-1.4.1.2.3.2.0-2950-hadoop2.7.1.2.3.2.0-2950.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: Found binding in [jar:file:/usr/hdp/2.3.2.0-2950/hadoop/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]

Connecting to jdbc:hive2://sandbox.hortonworks.com:10001/default

Error: Could not open client transport with JDBC Uri: jdbc:hive2://sandbox.hortonworks.com:10001/default: java.net.ConnectException: Connection refused (state=08S01,code=0)

Beeline version 1.2.1.2.3.2.0-2950 by Apache Hive

0: jdbc:hive2://sandbox.hortonworks.com:10001 (closed)>

6195-hivehttpsettings.png

1 ACCEPTED SOLUTION

avatar
Contributor

PEBCAK! After restarting Hive services a couple of times, and then surrounding my URI with single quotes, it appears all good.

First, made sure port 10001 is listening ...

[root@sandbox hive]# netstat -tulpna|grep 10001

tcp 0 0 0.0.0.0:10001 0.0.0.0:* LISTEN 25819/java

Then, attempted to connect with URI ...

beeline -u jdbc:hive2://sandbox.hortonworks.com:10001/default;transportMode=http;httpPath=cliservice

Finally, succeeded with URI ...

beeline -u 'jdbc:hive2://sandbox.hortonworks.com:10001/default;transportMode=http;httpPath=cliservice'

View solution in original post

10 REPLIES 10

avatar
Contributor

PEBCAK! After restarting Hive services a couple of times, and then surrounding my URI with single quotes, it appears all good.

First, made sure port 10001 is listening ...

[root@sandbox hive]# netstat -tulpna|grep 10001

tcp 0 0 0.0.0.0:10001 0.0.0.0:* LISTEN 25819/java

Then, attempted to connect with URI ...

beeline -u jdbc:hive2://sandbox.hortonworks.com:10001/default;transportMode=http;httpPath=cliservice

Finally, succeeded with URI ...

beeline -u 'jdbc:hive2://sandbox.hortonworks.com:10001/default;transportMode=http;httpPath=cliservice'