hive-dev 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-7200) Beeline output displays column heading even if --showHeader=false is set
Date Mon, 09 Jun 2014 19:55:07 GMT

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

Naveen Gangam commented on HIVE-7200:
-------------------------------------

A few cosmetic issues here

1) 
http://sqlline.sourceforge.net/#setting_showheader
http://sqlline.sourceforge.net/#setting_headerinterval

Although these properties are loosely defined in the SQLLine documentation above, it makes
sense to assume showHeader is for all headers, not just subsequent ones.

2) headerInterval causes the header to be printed 1 row sooner the first time ONLY. The code
suggests that it is including the header information as the first row, which is wrong, semantically
speaking. From then on, the header is printed at the set "headerInterval" number of rows after.

3) The line that closes the table ("------" in this case) at the bottom, is also dependent
on whether or not --showHeader is set to true. I believe that is incorrect too.

> Beeline output displays column heading even if --showHeader=false is set
> ------------------------------------------------------------------------
>
>                 Key: HIVE-7200
>                 URL: https://issues.apache.org/jira/browse/HIVE-7200
>             Project: Hive
>          Issue Type: Bug
>          Components: CLI
>    Affects Versions: 0.13.0
>            Reporter: Naveen Gangam
>            Assignee: Naveen Gangam
>            Priority: Minor
>
> A few minor/cosmetic issues with the beeline CLI.
> 1) Tool prints the column headers despite setting the --showHeader to false. This property
only seems to affect the subsequent header information that gets printed based on the value
of property "headerInterval" (default value is 100).
> 2) When "showHeader" is true & "headerInterval > 0", the header after the first
interval gets printed after <headerInterval - 1> rows. The code seems to count the initial
header as a row, if you will.
> 3) The table footer(the line that closes the table) does not get printed if the "showHeader"
is false. I think the table should get closed irrespective of whether it prints the header
or not.
> 0: jdbc:hive2://localhost:10000> select * from stringvals;
> +------+
> | val  |
> +------+
> | t    |
> | f    |
> | T    |
> | F    |
> | 0    |
> | 1    |
> +------+
> 6 rows selected (3.998 seconds)
> 0: jdbc:hive2://localhost:10000> !set headerInterval 2
> 0: jdbc:hive2://localhost:10000> select * from stringvals;
> +------+
> | val  |
> +------+
> | t    |
> +------+
> | val  |
> +------+
> | f    |
> | T    |
> +------+
> | val  |
> +------+
> | F    |
> | 0    |
> +------+
> | val  |
> +------+
> | 1    |
> +------+
> 6 rows selected (0.691 seconds)
> 0: jdbc:hive2://localhost:10000> !set showHeader false
> 0: jdbc:hive2://localhost:10000> select * from stringvals;
> +------+
> | val  |
> +------+
> | t    |
> | f    |
> | T    |
> | F    |
> | 0    |
> | 1    |
> 6 rows selected (1.728 seconds)



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message