Support Questions
Find answers, ask questions, and share your expertise

Hive Insert Query Not Executing in HDP 2.6.4 cluster

79537-hive-insert-query-issue.png

Hive insert query not executing, not even start executing either using TEZ or Map Reduce. Please find a screen-shot while running with MR engine.

1 REPLY 1

Hello @Victor Sarkar!

Seems to be something on YARN acceptation.
Could you check if your YARN parameters are set according to the documentation?
https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.5/bk_command-line-installation/content/determ...

Also, just to ensure, let's enable the DEBUG for Hive so we can track it down:

hive --hiveconf hive.root.logger=DEBUG,console

Hope this helps!