Created on 05-19-2024 12:50 PM - edited 05-19-2024 12:56 PM
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.
Created 05-19-2024 07:33 PM
Hello @adsejnf Can you check is hive server2 is up and running
Created on 05-19-2024 09:41 PM - edited 05-19-2024 10:02 PM
Created 05-19-2024 10:33 PM
Hi @adsejnf,
have you tried using the username and password as hive & hive respectively? If not, please try it once.
Thanks!
Created 05-20-2024 05:24 AM
I switched to mysql and the hiveserver2 is running now.
@tj2007 I setup a new username and password in mysql. Thank you 🙂