hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Naveen Gangam (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-9770) Beeline ignores --showHeader for non-tablular output formats i.e csv,tsv,dsv
Date Tue, 24 Feb 2015 18:08:04 GMT

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

Naveen Gangam commented on HIVE-9770:
-------------------------------------

IMHO the "table" output format is primarily for console viewing, so options like color &
headerInterval for readability and pagination make sense for this format. But the non-tablular
OF(csv(2), tsv(2),dsv) could be used for generating output files that can be serve as input
to other systems. So I dont think it makes sense to support options like headerInterval and
color for delimited output formats but showHeader is important.  It enables the users to generate
output in standard formats with or without the header.

So I am proposing the following behavior. Please let me know if you disagree.
   * showHeader support for all output formats. T
   * headerInterval and color are only supported for "table: OF. Change documentation to state
this.

> Beeline ignores --showHeader for non-tablular output formats i.e csv,tsv,dsv
> ----------------------------------------------------------------------------
>
>                 Key: HIVE-9770
>                 URL: https://issues.apache.org/jira/browse/HIVE-9770
>             Project: Hive
>          Issue Type: Bug
>          Components: Beeline
>    Affects Versions: 0.14.0
>            Reporter: Naveen Gangam
>            Assignee: Naveen Gangam
>            Priority: Critical
>
> [root@s1 ~]# beeline --silent=true --showHeader=false --outputformat=table -u "jdbc:hive2://localhost:10000"
-e "select * from t1;"
> --------+
> 1
> --------+
> [root@s1 ~]# beeline --silent=true --showHeader=false --outputformat=vertical -u "jdbc:hive2://localhost:10000"
-e "select * from t1;"
> t1.c1 1
> [root@s1 ~]# beeline --silent=true --showHeader=false --outputformat=csv -u "jdbc:hive2://localhost:10000"
-e "select * from t1;"
> 't1.c1'
> '1'
> [root@s1 ~]# beeline --silent=true --showHeader=false --outputformat=tsv -u "jdbc:hive2://localhost:10000"
-e "select * from t1;"
> 't1.c1'
> '1'
> [root@s1 ~]# beeline --silent=true --showHeader=false --outputformat=dsv -u "jdbc:hive2://localhost:10000"
-e "select * from t1;"
> t1.c1
> 1
> [root@s1 ~]# beeline --silent=true --showHeader=false --outputformat=csv2 -u "jdbc:hive2://localhost:10000"
-e "select * from t1;"
> t1.c1
> 1
> [root@s1 ~]# beeline --silent=true --showHeader=false --outputformat=tsv2 -u "jdbc:hive2://localhost:10000"
-e "select * from t1;"
> t1.c1
> 1



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message