Support Questions

Find answers, ask questions, and share your expertise

Count function not working in Hive

New Contributor

Count function is not working in Hive and getting timed out with error message:

sandbox.hortonworks.com:50075: Read timed out

1 REPLY 1

Super Mentor

@Aman Avinash

As we see that you are getting "Read timeout' While reading results form the Hive. So may be thedefault timeout setting is not good for your "view".

Please try increasing the following timeout properties to 60000 (1 minute) and the restart ambari server . Then try again

Example:

# cat /etc/ambari-server/conf/ambari.properties | grep 'read.timeout'
views.ambari.request.read.timeout.millis=60000
views.request.read.timeout.millis=60000

.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.