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' views.ambari.request.read.timeout.millis=60000 views.request.read.timeout.millis=60000