My Oracle Support Banner

"FAILED: ParseException line 6:1 cannot recognize input near 'column_name' 'array' '<' in column name or primary key or foreign key" with ODI when Loading into Hive Table (Doc ID 2771047.1)

Last updated on NOVEMBER 13, 2023

Applies to:

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

Symptoms

Using Oracle Data Integrator (ODI) 12.2.1.4.0, when running a mapping that uses a json file as source with complex attributes format and which injects data into a Hive table using Spark as loading process, the following error occurs:

 

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.