question hive beeline login says: Could not open connection to the HS2 server. Connection refused. in Support Questions

hive beeline login says: Could not open connection to the HS2 server. Connection refused.

adsejnf — Sun, 19 May 2024 19:56:44 GMT

Hello,

in hive i am unable to establish a connection,

beeline> !connect jdbc:hive2://localhost:10000/
Connecting to jdbc:hive2://localhost:10000/
Enter username for jdbc:hive2://localhost:10000/:

I don't know what to put for username and password, it is not accepting ENTER Key or my device login details.

Output:
24/05/20 01:19:08 [main]: WARN jdbc.HiveConnection: Failed to connect to localhost:10000
Could not open connection to the HS2 server. Please check the server URI and if the URI is correct, then ask the administrator to check the server status. Enable verbose error messages (--verbose=true) for more information.
Error: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10000/: java.net.ConnectException: Connection refused (Connection refused) (state=08S01,code=0)

Please help.

Re: hive beeline login says: Could not open connection to the HS2 server. Connection refused.

Scharan — Mon, 20 May 2024 02:33:20 GMT

Hello @adsejnf Can you check is hive server2 is up and running

Re: hive beeline login says: Could not open connection to the HS2 server. Connection refused.

adsejnf — Mon, 20 May 2024 05:02:06 GMT

@Scharan I checked, I am confused.

My hive-site.xml is also set properly:

Re: hive beeline login says: Could not open connection to the HS2 server. Connection refused.

tj2007 — Mon, 20 May 2024 05:33:02 GMT

Hi @adsejnf,

have you tried using the username and password as hive & hive respectively? If not, please try it once.

Thanks!

Re: hive beeline login says: Could not open connection to the HS2 server. Connection refused.

adsejnf — Mon, 20 May 2024 12:24:06 GMT

I switched to mysql and the hiveserver2 is running now.

@tj2007 I setup a new username and password in mysql. Thank you 🙂

Re: hive beeline login says: Could not open connection to the HS2 server. Connection refused.

Martini — Fri, 26 Jul 2024 16:44:02 GMT

I have MSQL and before the servers were turned off Beeline was working, but now it sends me this error message when I connect Beeline version 3.1.3 by Apache Hive
beeline> !connect jdbc:hive2://10.32.14.86:10000/Default; the message is still Could not open connection to the HS2 server. Please check the server URI and if the URI is correct, then ask the administrator to check the server status.
Error: Could not open client transport with JDBC Uri: jdbc:hive2://10.32.14.86:10000/Default;: java.net.ConnectException: Connection refused (state=08S01,code=0). I have already verified in detail all the hive-site.xlm communication files and all the others according to the manuals and they are correct, I have hiveserver & running and with hive I can connect to my databases.

Re: hive beeline login says: Could not open connection to the HS2 server. Connection refused.

hung — Thu, 20 Feb 2025 18:53:41 GMT

Do you slove this problem?

If you done, please said me solution