Getting aconnection timeout error while running simple hive script

[#1]

Hi - I'm getting the below error when trying to run simple hive query to fetch 100 rows from a table. Error : Hive Internal Error: com.sun.jersey.api.client.ClientHandlerException(java.net.SocketTimeoutException: Read timed out) Please help me out to resolve this.

[#2]

@Pradeep Ravi

It will be helpful if you can provide more details about your environment.

java.net.SocketTimeoutException: Read timed out (Looks like that you are not connected to hive or connection is not successful)

[#3]

I am using HDP 2.3 Sandbox.I am getting this error when I run query from Ambari - Hive web interface.

I am not sure what is causing this issue but whenever I get this I used to import the untouched sandbox image again but it is not the optimized solution.

[#4]

@Pradeep Ravi

Have you tried running the script via beeline or hive command line? Have you checked if hive server, hive server 2, and Atlas are up and running? Maybe it would be easier to ask what services are not running on your sandbox..

If you are able to run the scripts (if long script use the -e option) via command line we can then possibly isolate this issue to ambari view.

[#5]

All the services(hive server and Atlas were up and running).I don't see any single service were down during the error.

I was trying with hive command line as well as with Hive web UI(error occurred at both the case).If you'd describe what is -e option, I can give a try.

Note:Now this issue got fixed after I reloaded/imported the fresh sandbox image.

[#6]

@Pradeep Ravi are you still having issues with this? Can you accept best answer or provide your own solution?

[#7 · Accepted solution]

This issue is now fixed.I imported the sandbox image again which resolved the error.