Support Questions

Find answers, ask questions, and share your expertise

Error while connecting to beeline.

I am trying to connect beeline it gives me error like

'Error: Could not open client transport with JDBC Uri: jdbc:hive2://<ip>:10000: java.net.ConnectException: Connection refused (state=08S01,code=0)
0: jdbc:hive2://<ip>:10000 (closed)> '
1 REPLY 1

Super Mentor

@Anjali Shevadkar

Are you able to telnet the HS2 host (IP / Hostname) and port?

# telnet <IP>  10000
(OR)
# nc -v  <IP>   10000

.

Also please check if the firewall is disabled on HS2 host? Also on the HS2 host please check if it has port 10000 opened?

# netstat -tnlpa | grep $HS2_PID

.

You can try connecting using beeline using the Zookeeper quorum like mentioned in the following link:

https://community.hortonworks.com/articles/4103/hiveserver2-jdbc-connection-url-examples.html

.