You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Brock Noland (JIRA)" <ji...@apache.org> on 2015/02/25 19:39:07 UTC
[jira] [Commented] (HIVE-7390) Make quote character optional and
configurable in BeeLine CSV/TSV output
[ https://issues.apache.org/jira/browse/HIVE-7390?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14336940#comment-14336940 ]
Brock Noland commented on HIVE-7390:
------------------------------------
FYI this jira makes the single quote character optional but not the double quote. e.g.:
source data:
{noformat}
beeline -u jdbc:hive2://localhost:10000 -e "select * from quote_test" 2>&1 | grep -Ev '^SLF4J'
+----------------+----------------+--+
| quote_test.c1 | quote_test.c2 |
+----------------+----------------+--+
| "A" | B |
| ""C"" | "D" |
+----------------+----------------+--+
{noformat}
csv:
{noformat}
beeline -u jdbc:hive2://localhost:10000 --outputformat=csv -e "select * from quote_test" 2>&1 | grep -Ev '^SLF4J'
'quote_test.c1','quote_test.c2'
'"A"','B'
'""C""','"D"'
{noformat}
csv2:
{noformat}
beeline -u jdbc:hive2://localhost:10000 --outputformat=csv2 -e "select * from quote_test" 2>&1 | grep -Ev '^SLF4J'
quote_test.c1,quote_test.c2
"""A""",B
"""""C""""","""D"""
{noformat}
> Make quote character optional and configurable in BeeLine CSV/TSV output
> ------------------------------------------------------------------------
>
> Key: HIVE-7390
> URL: https://issues.apache.org/jira/browse/HIVE-7390
> Project: Hive
> Issue Type: New Feature
> Components: Clients
> Affects Versions: 0.13.1
> Reporter: Jim Halfpenny
> Assignee: Ferdinand Xu
> Fix For: 0.14.0
>
> Attachments: HIVE-7390.1.patch, HIVE-7390.2.patch, HIVE-7390.3.patch, HIVE-7390.4.patch, HIVE-7390.5.patch, HIVE-7390.6.patch, HIVE-7390.7.patch, HIVE-7390.8.patch, HIVE-7390.9.patch, HIVE-7390.patch
>
>
> Currently when either the CSV or TSV output formats are used in beeline each column is wrapped in single quotes. Quote wrapping of columns should be optional and the user should be able to choose the character used to wrap the columns.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)