[HIVE-5999] Allow other characters for LINES TERMINATED BY

• Type: Improvement
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 0.12.0
• Component/s: Beeline, Database/Schema, Hive
• Labels: Delimiter Hive Row SerDe
• Assignee: Nemon Lou
• Reporter: Mariano Dominguez
• Created: 10/Dec/13 15:55
• Updated: 11/Jul/23 18:50

Description

LINES TERMINATED BY only supports newline '\n' right now.

It would be nice to loosen this constraint and allow other characters.

This limitation seems to be hardcoded here:
https://github.com/apache/hive/blob/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java#L171

The DDL Definition on the Hive Language manual shows this as a configurable property whereas it is not. This may lead to mileading assement of being able to choose a choice of field delimiter.

Issue Links

• is cloned by: HIVE-11996 Row Delimiter other than '\n' throws error in Hive.