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