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.

INSERT OVERWRITE TABLE gl_staging_eve.header_text select header_text, translateText(header_text) from gl_staging_eve.header_text_only; failing

Highlighted

INSERT OVERWRITE TABLE gl_staging_eve.header_text select header_text, translateText(header_text) from gl_staging_eve.header_text_only; failing

New Contributor

I have created a UDF translateText(), which calls API to translate the given text and returns the correct result, but when I apply the INSERT INTO TABLE as given below:

INSERT OVERWRITE TABLE gl_staging_eve.header_text select header_text, translateText(header_text) from gl_staging_eve.header_text_only;

The query fails with below output:

FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Map 1, vertexId=vertex_1543885299280_8715_1_00, diagnostics=[Task failed, taskId=task_1543885299280_8715_1_00_000040, diagnostics=[TaskAttempt 0 failed, info=[Container container_e14_1543885299280_8715_01_000042 finished with diagnostics set to [Container completed. ]], TaskAttempt 1 failed, info=[Container container_e14_1543885299280_8715_01_000043 finished with diagnostics set to [Container completed. ]], TaskAttempt 2 failed, info=[Container container_e14_1543885299280_8715_01_000087 finished with diagnostics set to [Container completed. ]], TaskAttempt 3 failed, info=[Container container_e14_1543885299280_8715_01_000137 finished with diagnostics set to [Container completed. ]]], Vertex did not succeed due to OWN_TASK_FAILURE, failedTasks:1 killedTasks:40, Vertex vertex_1543885299280_8715_1_00 [Map 1] killed/failed due to:OWN_TASK_FAILURE]DAG did not succeed due to VERTEX_FAILURE. failedVertices:1 killedVertices:019/02/12 06:54:58 [ATS Logger 0]: INFO hooks.ATSHook: Received post-hook notification for :bduser_20190212065438_6cf35096-aa74-48d1-a8ae-6d76b0049099 19/02/12 06:54:58 [main]: ERROR ql.Driver: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Map 1, vertexId=vertex_1543885299280_8715_1_00, diagnostics=[Task failed, taskId=task_1543885299280_8715_1_00_000040, diagnostics=[TaskAttempt 0 failed, info=[Container container_e14_1543885299280_8715_01_000042 finished with diagnostics set to [Container completed. ]], TaskAttempt 1 failed, info=[Container container_e14_1543885299280_8715_01_000043 finished with diagnostics set to [Container completed. ]], TaskAttempt 2 failed, info=[Container container_e14_1543885299280_8715_01_000087 finished with diagnostics set to [Container completed. ]], TaskAttempt 3 failed, info=[Container container_e14_1543885299280_8715_01_000137 finished with diagnostics set to [Container completed. ]]], Vertex did not succeed due to OWN_TASK_FAILURE, failedTasks:1 killedTasks:40, Vertex vertex_1543885299280_8715_1_00 [Map 1] killed/failed due to:OWN_TASK_FAILURE]DAG did not succeed due to VERTEX_FAILURE. failedVertices:1 killedVertices:0

Basically INSERT INTO TABLE is not working.

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