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

Reply via email to