Support Questions

Find answers, ask questions, and share your expertise

insert query hangs from hive view ONLY

avatar
Super Collaborator

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

91553-capture3.jpg

91552-capture2.jpg

91551-capture1.jpg

1 ACCEPTED SOLUTION

avatar
Super Collaborator

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

View solution in original post

1 REPLY 1

avatar
Super Collaborator

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