[
https://issues.apache.org/jira/browse/HIVE-7200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Naveen Gangam updated HIVE-7200:
--------------------------------
Attachment: HIVE-7200.1.patch
0: jdbc:hive2://localhost:10000> select * from stringvals;
+------+
| val |
+------+
| t |
| f |
| T |
| F |
| 0 |
| 1 |
+------+
6 rows selected (2.052 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 (2.329 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.482 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 (0.997 seconds)
0: jdbc:hive2://localhost:10000> !set headerInterval 5
0: jdbc:hive2://localhost:10000> select * from stringvals;
+------+
| val |
+------+
| t |
| f |
| T |
| F |
| 0 |
+------+
| val |
+------+
| 1 |
+------+
6 rows selected (0.822 seconds)
0: jdbc:hive2://localhost:10000> !set headerInterval 50
0: jdbc:hive2://localhost:10000> select * from stringvals;
+------+
| val |
+------+
| t |
| f |
| T |
| F |
| 0 |
| 1 |
+------+
6 rows selected (0.764 seconds)
The test results with the patch above.
> 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
> Attachments: HIVE-7200.1.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.
> 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)
