My Oracle Support Banner

Upload File Data to Hive Fails with "Error while compiling statement: FAILED: SemanticException 8:20 LINES TERMINATED BY only supports newline '\n' right now. Error encountered near token '' \n''" (Doc ID 2373052.1)

Last updated on MARCH 22, 2018

Applies to:

Oracle Data Integrator - Version 12.2.1.1.0 and later
Information in this document applies to any platform.

Symptoms

In Oracle Data Integrator (ODI) 12c, while trying to load a .CSV file into HIVE Tables, the following error occurs:

ODI-1228: Task Create work table-HiveBaseLKM- fails on the target connection HIVE_PROD.
Caused By: java.sql.SQLException: [FMWGEN][Hive JDBC Driver][Hive]Error while compiling statement: FAILED: SemanticException 8:20 LINES TERMINATED BY only supports newline '\n' right now. Error encountered near token '' \n''

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.