My Oracle Support Banner

SemanticException "in insert schema specification is not found among regular columns" Is Received when Loading Data into Hive Using ODI 12c Knowledge Module "LKM SQL to SQL" (Doc ID 2319936.1)

Last updated on JUNE 09, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.2.6 and later
Oracle Data Integrator on Marketplace - Version 12.2.1.4.200123 and later
Information in this document applies to any platform.

Symptoms

The following error is received when using Oracle Data Integrator (ODI) and loading data into Apache Hive using a regular SQL Loading Knowledge Module (LKM) such as "LKM SQL to SQL" (built-in):

Steps to reproduce the behavior:

  1. Have an Oracle table with name and columns in upper case.
  2. Have a Mapping that loads data from above Oracle table into Hive, using the built-in "LKM SQL to SQL".
  3. Run the Mapping and observe the error message.

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!

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