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 FEBRUARY 26, 2019

Applies to:

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

Symptoms

In Oracle Data Integrator (ODI) 12.2.1.3.0, 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>'

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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