From Ambari 2.4.1 -> Hive view i am unable to create a table from another table, getting error . how to trouble shoot to find the reason ?

[#1]

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.