Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Tue, 29 Jul 2014 19:32:39 +0000 (UTC)
From: "Szehon Ho (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <JIRA.12726797.1405082541280.68337.1406662359949@arcas>
In-Reply-To: <JIRA.12726797.1405082541280@arcas>
References: <JIRA.12726797.1405082541280@arcas>
Subject: [jira] [Commented] (HIVE-7390) Make quote character optional and
 configurable in BeeLine CSV/TSV output
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

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

Hi, I guess we will continue the discussion here from HIVE-7390.  First, thanks for incorporating my feedback from that partial patch.

So I read this patch, and it has one option:
{noformat} 'outputAsCLICSVFormat=[true/false]	display the output in the csv format as Hive command line\n \ {noformat}

The only difference is quote, right?   If my understanding is right, can't we have a new output format called 'quotedCSV', and change the default csv format to be unquoted, as was discussed earlier on this JIRA by Jim Halfpenny.  (He mentioned single-quote is not standard).  Some disadvantages of 'outputAsCliCSVFormat' option is that its name is not very descriptive for users, and as Xuefu mentioned it is universal option even though it should only apply to CSV.  What do you think?

> 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
>         Attachments: HIVE-7390.1.patch, HIVE-7390.2.patch, HIVE-7390.3.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.2#6252)