question insert query hangs from hive view ONLY in Archives of Support Questions (Read Only)

insert query hangs from hive view ONLY

aliyesami — Sun, 18 Aug 2019 05:19:05 GMT

if i insert a row from hive command line in unix it starts a TEZ job and runs fine and inserts a row, but the same insert if i try to do from hive view in Ambari, it hangs. The SELECT queries work fine in hive view .

plz see the attached screenshots

Re: insert query hangs from hive view ONLY

aliyesami — Wed, 26 Sep 2018 09:24:49 GMT

I could resolve this issue by modifying the following parameters

 yarn.scheduler.minimum-allocation-mb=2560
 yarn.nodemanager.resource.memory-mb=7680
 yarn.app.mapreduce.am.resource.mb=2560