Couple of Hadoop jobs are failing when trying to load the data from ORACLE to HIVE

I have oracle source and Hadoop target, but my jobflows are failing when trying to load the data into the ORACLE target tables with the below error

ERROR:Failed to Execute NativeSQL:: NativeSQL execution failed:Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Map 1, vertexId=vertex_1585896126081_189473_1_00, diagnostics=[Task failed, taskId=task_1585896126081_189473_1_00_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

Beginner Asked on November 13, 2020 in Diyotta Monitor.
Add Comment
1 Answer(s)

Can you check if the tform table which is being created in the hive database on top of the Oracle Source is having the specified table properties and field delimiter as shown below? If the table is getting created as shown below, then we won’t be facing this issue.

FIELDS TERMINATED BY “\u0001″
COLLECTION ITEMS TERMINATED BY ‘\002’
LINES TERMINATED BY ‘\n’
NULL DEFINED AS ”
STORED AS ORC TBLPROPERTIES ( ‘orc.compress’ = ‘ZLIB’
,’orc.create.index’ = ‘true’ )
Expert Answered on November 20, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.