Count function is not working in Hive and getting timed out with error message:
sandbox.hortonworks.com:50075: Read timed out
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
# cat /etc/ambari-server/conf/ambari.properties | grep 'read.timeout'