Hive Connection issue

Question

I get an connection refused error while connecting to Hive via Talend. I'm able to connect from command prompt to Hive use default database and create a table manually. Hive rejects the connections can you help me?

Answer 1

You are getting the issues probably because the hive server is not running.

Kindly find the alternatives below.

It seems that your hive server is not running properly 

Please try the above commands in your command line and try running your hive server.

nohup hive --service hiveserver2 &

After this try running your job, You will get the warnings which can be neglected.

After this close the hive server by typing the command below.

kill -9 <id number of hive server>

Now login into the hive terminal and check the data.