'ORA-00904: "<COLUMN_FAMILY_PREFIX>:<COLUMN>": invalid identifier' Is Received when Executing ODI 12C Mappings using "LKM SQL To HBase SQOOP Direct" with SPLIT_BY Option (Doc ID 2559150.1)

Last updated on MAY 25, 2021

Applies to:

Symptoms

When attempting to execute an Oracle Data integrator (ODI) 12c Mapping that loads data from Exadata to HBase using "LKM SQL to HBase SQOOP Direct"   with SPLIT_BY Option for  SQOOP_PARALLELISM, the below error is seen:

Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "<COLUMN_FAMILY_PREFIX>:<COLUMN>": invalid identifier
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.