[
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)
