Hello All,
I have followed article to create mapping for Oracle -> Hive Data Load using following blog ( click here)
I encountered following error when run simple mapping between Oracle-Hive data load.
INFO: Will try to open client transport with JDBC Uri: jdbc:hive2://xxx,com:10000
Oct 04, 2015 2:10:24 AM null
INFO: New data source: [osx_sys/*******@jdbc:oracle:thin:@x.x.x:1491:xxxxx]
Oct 04, 2015 2:10:25 AM oracle.odi.runtime.agent.execution.sql.SQLCommand
WARNING: SQLCommand execution failure: Error while compiling statement: FAILED: ParseException line 1:32 cannot recognize input near '(' 'DAYOFYEAR_KEY' ',' in statement
Failed query text:
INSERT INTO default.C_0DWB_INVC (
DAYOFYEAR_KEY,
DAY_KEY,
)
VALUES(
:DAYOFYEAR_KEY ,
:DAY_KEY ,
Oct 04, 2015 2:10:25 AM oracle.odi.agent
WARNING: Agent Internal encountered an error: ODI-1226: Step Physical_STEP fails after 1 attempt(s).
Oct 04, 2015 2:10:25 AM oracle.odi.agent
SEVERE: Session Loading Customer Invoices_Physical_SESS (102) fails with return code ODI-1298.
ODI-1217: Session Loading Customer Invoices_Physical_SESS (102) fails with return code ODI-1298.
ODI-1226: Step Physical_STEP fails after 1 attempt(s).
ODI-1240: Flow Physical_STEP fails while performing a Load DWB_INVC_AP-LKM SQL to SQL (Built-In)- operation. This flow loads target table dwb_invc1.
ODI-1298: Serial task "SERIAL-MAP_MAIN- (50)" failed because child task "SERIAL-EU-TMM_OCDM_SYS_UNIT (60)" is in error.
ODI-1298: Serial task "SERIAL-EU-TMM_OCDM_SYS_UNIT (60)" failed because child task "Load DWB_INVC_AP-LKM SQL to SQL (Built-In)- (70)" is in error.
ODI-1228: Task Load DWB_INVC_AP-LKM SQL to SQL (Built-In)- fails on the target connection TMM BDA.
Caused By: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:32 cannot recognize input near '(' 'DAYOFYEAR_KEY' ',' in statement
at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:231)
at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:217)