Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

insert query hangs from hive view ONLY

Solved Go to solution

insert query hangs from hive view ONLY

Master 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

Accepted Solutions
Highlighted

Re: insert query hangs from hive view ONLY

Master 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
1 REPLY 1
Highlighted

Re: insert query hangs from hive view ONLY

Master 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
Don't have an account?
Coming from Hortonworks? Activate your account here