My Oracle Support Banner

ODI "CKM Hive" Check Knowledge Module Generates Wrong Code When Lookup and Target Table Column Names Do Not Match (Doc ID 2383343.1)

Last updated on AUGUST 20, 2020

Applies to:

Oracle Data Integrator - Version to [Release 12c]
Information in this document applies to any platform.


In Oracle Data Integrator (ODI), the ODI check knowledge module "CKM Hive" generates the wrong code when the name of the columns in the lookup table does not match the name of the columns in the target table.

The CKM fails with the following error message:

ODI-1228: Task Control-name-Insert errors fails on the target connection HiveConnection.
Caused By: java.sql.SQLException: [FMWGEN][Hive JDBC Driver][HIVE]Error while compiling statement: FAILED: SemanticException [ERROR:10002]: Line <ID>:<ID> Invalid column reference '<NAME>'




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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