hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kenneth MacArthur (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-14679) csv2/tsv2 output format disables quoting by default and it's difficult to enable
Date Tue, 18 Oct 2016 14:26:58 GMT

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

Kenneth MacArthur commented on HIVE-14679:
------------------------------------------

Commands like "more" choke on these null characters. View a CSV file with nulls instead of
quotes and you'll see - the line is truncated. Even in "vi", you see some bizarre character
that makes you think there's something wrong with the character set of the file.

It's all very confusing (and, more importantly, time-wasting) for the user.

I would say user convenience should trump implementation convenience. ;)

What do you say?

> csv2/tsv2 output format disables quoting by default and it's difficult to enable
> --------------------------------------------------------------------------------
>
>                 Key: HIVE-14679
>                 URL: https://issues.apache.org/jira/browse/HIVE-14679
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Brock Noland
>            Assignee: Jianguo Tian
>
> Over in HIVE-9788 we made quoting optional for csv2/tsv2.
> However I see the following issues:
> * JIRA doc doesn't mention it's disabled by default, this should be there an in the output
of beeline help.
> * The JIRA says the property is {{--disableQuotingForSV}} but it's actually a system
property. We should not use a system property as it's non-standard so extremely hard for users
to set. For example I must do: {{env HADOOP_CLIENT_OPTS="-Ddisable.quoting.for.sv=false" beeline
...}}
> * The arg {{--disableQuotingForSV}} should be documented in beeline help.



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

Mime
View raw message