Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Count function not working in Hive

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

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

.

Don't have an account?
Coming from Hortonworks? Activate your account here