INSERT COMMAND HANGING

[#1]

Iam using HDC2.4 with ambari 2.2.1 , If I insert a record into a table it just hangs , how can I debug ?

"0: jdbc:hive2://MasterNode:10000> INSERT INTO customers (id, firstname, lastname) VALUES (1, 'John', 'Smith'); INFO : Tez session hasn't been created yet. Opening session

"

[#2]

don't I have to kill the hive session first and then run it in background as :

nohup

($HIVE_HOME/bin/hive --hiveconf hive.root.logger=DEBUG,DRFA

&

how can I find out what is $HIVE_HOME ?

[#3 · Accepted solution]

I found the answer on google, changing the below parameter from 0.2 to 0.7 fixed the issue.

yarn.scheduler.capacity.maximum-am-resource-percent=0.7

thanks all for your help n feedback