RE: 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
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.
COLLECTION ITEMS TERMINATED BY ‘\002’
LINES TERMINATED BY ‘\n’
NULL DEFINED AS ”
STORED AS ORC TBLPROPERTIES ( ‘orc.compress’ = ‘ZLIB’
,’orc.create.index’ = ‘true’ )