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.

Hive Insert Query Not Executing in HDP 2.6.4 cluster

Highlighted

Hive Insert Query Not Executing in HDP 2.6.4 cluster

New Contributor

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

Re: Hive Insert Query Not Executing in HDP 2.6.4 cluster

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!