I am working on a Twitter Analysis POC and noticing that Hive Queries run in CLI work fine but when I run them from the Hive View in Ambari some of them do not return results. When this happens the Logs tab shows "INFO : Tez session hasn't been created yet. Opening session". I an see the query info within the Tez view and it is showing successful completion but the results are never returned to the Hive View. I am using HDP Sandbox 2.4.
That INFO only states that there were no TEZ session available and then a new one has to be created. But this is not an issue: the only problem is that you have a bit more time to start because it has to allocate the resources. The problem is more related to the Hive View which is not working properly showing you the results. Running the same query via beeline on command line you will see all the results.