Support Questions
Find answers, ask questions, and share your expertise

Count function not working in Hive

Highlighted

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
Highlighted

Re: Count function not working in Hive

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

.