What if i want to use date_table within a subquery? can you provide the syntax? ... View more

The process owner for Hive LLAP daemon process has to be the same as the query executing user. When Hive Server Interactive (aka HSI) is brought up by Ambari, the LLAP daemons are owned by user hive. The executing user will also need to be hive which is what happens when hive.server2.enable.doAs is false. The intended usage of HSI is to be with impersonation disabled (hive.server2.enable.doAs=false). The end user authorization is assumed to be handled by Ranger Auth or SQL Standard Auth. ... View more

Which version of HDP are you using ? ... View more

One more thing.When I issue show locks <table> command. I can only see exclusive locks being shown for insert queries but it is not showing shared locks on select queries ? ... View more

any one get solution for this ? ... View more

Check this doc url for ambari and hdp upgrade. https://docs.hortonworks.com/HDPDocuments/Ambari-2.5.0.3/bk_ambari-upgrade/content/upgrading_ambari.html ... View more

I am also facing the same issue in HDP3... Is it resolved...???? ... View more