- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Getting aconnection timeout error while running simple hive script
- Labels:
-
Apache Hive
Created ‎01-02-2016 01:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created ‎02-03-2016 03:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This issue is now fixed.I imported the sandbox image again which resolved the error.
Created ‎01-02-2016 01:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)
Created ‎01-04-2016 03:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created ‎01-04-2016 05:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created ‎01-05-2016 03:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created ‎02-02-2016 07:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Pradeep Ravi are you still having issues with this? Can you accept best answer or provide your own solution?
Created ‎02-03-2016 03:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This issue is now fixed.I imported the sandbox image again which resolved the error.
