We have a hive application which is failing after 1 hr run with below error: could someone please help me out ?
2020-01-10 01:16:19.288 <TASK_140348225472256-READER_1_1_1> SEVERE: [RR_4035] SQL Error [
Function [INFASQLExecute] failed in adapter [/app/Informatica/v10.2.1/pmserver/plugins/dynamic/hiveruntime/libhive.so] with error code [-1].
FnName: INFASQLExecute -- execute(). SQLException: [java.sql.SQLException: [Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask]]
Function [INFASQLGetDiagRecW] failed in adapter [/app/Informatica/v10.2.1/pmserver/plugins/dynamic/hiveruntime/libhive.so] with error code [100].
FnName: INFASQLExecute -- execute(). SQLException: [java.sql.SQLException: [Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask]]
Function [INFASQLGetDiagRecW] failed in adapter [/app/Informatica/v10.2.1/pmserver/plugins/dynamic/hiveruntime/libhive.so] with error code [100].].
This is over a partition table and the column stats over this column is as below, however we are able to read data from the partitions and also show partitions lists all the partitions:
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Error in getting fields from serde.Invalid Field dcolumn_name