My Oracle Support Banner

"ParseException" Error is Received on ODI 12c Hive Table Creation when Column Name Has Diacritics (Doc ID 2314621.1)

Last updated on FEBRUARY 14, 2019

Applies to:

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

Symptoms

NOTE: In the example below, any details represent a fictitious sample (based upon made up data used in the Oracle Demo ODI instance). Any similarity to actual persons and system configurations, is purely coincidental and not intended in any manner.

Having an Oracle Data Integrator (ODI) 12c Mapping to load data from an Oracle table into Hive.

The Oracle source table has column names with diacritics also known as extended ASCII or accented characters, such as:

     COMMERCIËLE_KORT
     (Observe the diacritic Ë)

The following error is reported:

ODI-1228: Task Create work table-LKM SQL to Hive SQOOP- fails on the target connection <NAME>.
Caused By: java.sql.SQLSyntaxErrorException: [FMWGEN][Hive JDBC Driver][Hive]Error while compiling statement: FAILED: ParseException line 156:16 cannot recognize input near 'LE_KORT' 'STRING' ',' in column type
  at weblogic.jdbc.hivebase.ddcp.b(Unknown Source)
  at weblogic.jdbc.hivebase.ddcp.a(Unknown Source)
  ...

     ... the executed code being:

CREATE TABLE IF NOT EXISTS odi_work_schema.c_<NAME>
(
  ...
  COMMERCIËLE_KORT STRING,
  ...
)

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
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.