hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Szehon Ho (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-7390) Make quote character optional and configurable in BeeLine CSV/TSV output
Date Wed, 22 Oct 2014 19:07:34 GMT

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

Szehon Ho commented on HIVE-7390:
---------------------------------

I made a typo in point two, the separator is comma for CSV only.  For DSV it's configurable
as explained in point one, but defaults to |.  For TSV it is a tab character.
CSV:  a,b,c
DSV:   a|b|c  (can configure this)
TSV:  a\tb\tc

Addendum: to give another example of when it does quote, the code seems to indicate it will
use double-quote, so:
CSV:  "a","b","c"
DSV:  "a"|"b"|"c"
TSV: ...
but only if these values {a,b,c} fit into the critiera as explained.

> 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
>              Labels: TODOC14
>             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