Greeting of the day.
I have installed HDP 3.1 two times on two different servers. That is it was a single node installation on two different physical machines. But both the times I am facing issues in hive. In this , create,update, drop, delete queries works properly but always at the time of insert statement it waits for long time with a message "tez session hasn't been created yet, opening session". And it further doesn't progress . So I have to wait for some time and then cancel the command/queries.
Normal basic insert statements also doesn't works and gets same message.
I have tried all possible tuning parameters in hive, yarn, tez etc but no luck. Tried with set session variables as well i.e hive.execution.engine but no luck again.
Need your help, valuable suggestions/inputs here.Thank you.
Thanks & Regards,
Yarn queue where the Tez application gets submitted don't have enough capacity to start a new application.
You should be able to see tez application in yarn rm -> accepted applications. Tune NM capacity + reduce following configs to let yarn accept & launch new application.
-- Setting AM size to 512mb
-- Setting Task container size to 512mb