[Resolved]How to resolve the Exception message ‘ERROR [HY000] [Hortonworks]





In this article, we will explain how to resolve the Hortonworks Hive issue Hadoop cluster.

Error in Hortonworks Hive service:

Below on is the exact error in the Hadoop cluster.

Exception message 'ERROR [HY000] [Hortonworks][Hardy] (35) Error from server: error code: '1' error message: 'Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Dag received [DAG_TERMINATE, DAG_KILL] in RUNNING state.Sending client kill from a9123408 (auth:TOKEN) at local host to dag dag_vVertex killed, vertexName=Reducer 2, vertexId=vertex_20364527462039_4675_0432, diagnostics=[Vertex received Kill while in RUNNING state., Vertex did not succeed due to DAG_TERMINATED, failedTasks:0 killedTasks:3, Vertex vertex_1636527462039_43235_2_01 [Reducer 2] killed/failed due to:DAG_TERMINATED]Vertex killed, vertexName=Map 1, vertexId=vertex_20364527462039_4675_0432, diagnostics=[Vertex received Kill while in RUNNING state., Vertex did not succeed due to DAG_TERMINATED, failedTasks:0 killedTasks:1, Vertex vertex_20364527462039_4675_0432 [Map 1] killed/failed due to:DAG_TERMINATED]DAG did not succeed due to DAG_KILL. failedVertices:0 killedVertices:2'.'.

Solution:

  1. Go to Amabari cluster, login with Admin credentials
  2. After that go to the Hive server
  3. First, stop the Hive server and start the server

I tried the above resolution, it’s working for me.




Summary: The above error is quite common in Hadoop cluster. One of Hadoop developer contact  me . He / she explained this type of error then I checked in the Hadoop cluster at the time Hive server goes to down. After that I have checked in Hive logs it showing above error.

Then I have checked YARN (Yet Another Resource Negotiator) application id, the job in failed status so I went to Ambari cluster and stop the Hive service and start the Hive service. After developers restart the jobs from there end.

The cluster is stable and all services are running good.



Leave a Reply

Your email address will not be published. Required fields are marked *