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