[jira] [Commented] (HIVE-5999) Allow other characters for LINES TERMINATED BY

["Sameer Gupta (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-5999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14936747#comment-14936747 ] 

Sameer Gupta commented on HIVE-5999:
------------------------------------

This seems like a major roadblock as in a number of cases, we ger records that are not new line terminated and need a huge workaround. 

LINES TERMINATED BY only supports newline '\n' right now in the create table statement.

Why is there an option in the first place when we cannot change it.

Seems like nobody looked into it for years.



> Allow other characters for LINES TERMINATED BY 
> -----------------------------------------------
>
>                 Key: HIVE-5999
>                 URL: https://issues.apache.org/jira/browse/HIVE-5999
>             Project: Hive
>          Issue Type: Improvement
>          Components: Beeline, Database/Schema, Hive
>    Affects Versions: 0.12.0
>            Reporter: Mariano Dominguez
>            Priority: Critical
>
> 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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)