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.

Getting Vertex failed error while executing merge query

Highlighted

Getting Vertex failed error while executing merge query

I'm trying to run a merge query in Hive. But it gives me this error every time. How do I resolve the same ?

java.sql.SQLException:
Error while processing statement: FAILED: Execution Error, return code 2 from
org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Reducer
4, vertexId=vertex_1524056113553_0052_2_03, diagnostics=[Task failed,
taskId=task_1524056113553_0052_2_03_000000, diagnostics=[TaskAttempt 0 failed,
info=[Error: Failure while running task:java.lang.RuntimeException:
java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException:
Hive Runtime Error while processing row (tag=0)
{"key":{"_col0":{"transactionid":2,"bucketid":1,"rowid":0},"_col1":"2018-05-02"},"value":{"_col0":1}}         
at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:173)
at org.apache.hadoop.hive.ql.exec.tez.TezProcessor.run(TezProcessor.java:139)
at org.apache.tez.runtime.LogicalIOProcessorRuntimeTask.run(LogicalIOProcessorRuntimeTask.java:347)
at org.apache.tez.runtime.task.TezTaskRunner$TaskRunnerCallable$1.run(TezTaskRunner.java:194)
1 REPLY 1

Re: Getting Vertex failed error while executing merge query

Don't have an account?
Coming from Hortonworks? Activate your account here