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 APRIL 18, 2018

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 and later
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 300:40 Invalid column reference 'xxx_xxx_xxx'

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms