What exception do you see when running the query? You can check the hive view logs in Ambari Server
For Hive View 1.5, you can check /var/log/ambari-server/hive-next-view/hive-view.log
For Hive View 1.0: /var/log/ambari-server/ambari-server.log
You may also check hiveserver2.log file on Hiveserver2 host while creating a table.