hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brock Noland (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-7390) Make quote character optional and configurable in BeeLine CSV/TSV output
Date Wed, 25 Feb 2015 18:39:07 GMT

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

Mime
View raw message