[
https://issues.apache.org/jira/browse/HIVE-7200?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14029727#comment-14029727
]
Naveen Gangam commented on HIVE-7200:
-------------------------------------
{code}
0: jdbc:hive2://localhost:10000> select * from stringvals;
+------+
| val |
+------+
| t |
| f |
| T |
| F |
| 0 |
| 1 |
+------+
6 rows selected (3.729 seconds)
0: jdbc:hive2://localhost:10000> select * from employees;
+-------+---------+---------------+-------------+----------+----------+--------+
| name | salary | subordinates | deductions | address | country | state |
+-------+---------+---------------+-------------+----------+----------+--------+
+-------+---------+---------------+-------------+----------+----------+--------+
No rows selected (2 seconds)
0: jdbc:hive2://localhost:10000> !set showHeader false
0: jdbc:hive2://localhost:10000> select * from stringvals;
+------+
| t |
| f |
| T |
| F |
| 0 |
| 1 |
+------+
6 rows selected (0.882 seconds)
0: jdbc:hive2://localhost:10000> select * from employees;
+-------+---------+---------------+-------------+----------+----------+--------+
+-------+---------+---------------+-------------+----------+----------+--------+
No rows selected (1.914 seconds)
0: jdbc:hive2://localhost:10000> !set headerInterval 2
0: jdbc:hive2://localhost:10000> select * from stringvals;
+------+
| t |
| f |
| T |
| F |
| 0 |
| 1 |
+------+
6 rows selected (1.923 seconds)
0: jdbc:hive2://localhost:10000> select * from employees;
+-------+---------+---------------+-------------+----------+----------+--------+
+-------+---------+---------------+-------------+----------+----------+--------+
No rows selected (6.866 seconds)
0: jdbc:hive2://localhost:10000> !set showHeader true
0: jdbc:hive2://localhost:10000> select * from stringvals;
+------+
| val |
+------+
| t |
| f |
+------+
| val |
+------+
| T |
| F |
+------+
| val |
+------+
| 0 |
| 1 |
+------+
6 rows selected (2.447 seconds)
0: jdbc:hive2://localhost:10000> select * from employees;
+-------+---------+---------------+-------------+----------+----------+--------+
| name | salary | subordinates | deductions | address | country | state |
+-------+---------+---------------+-------------+----------+----------+--------+
+-------+---------+---------------+-------------+----------+----------+--------+
No rows selected (1.509 seconds)
{code}
> 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
> Fix For: 0.14.0
>
> Attachments: HIVE-7200.1.patch, HIVE-7200.2.patch
>
>
> 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.
> {code}
> 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)
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
