hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Xuefu Zhang (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-7200) Beeline output displays column heading even if --showHeader=false is set
Date Wed, 11 Jun 2014 18:46:03 GMT

     [ https://issues.apache.org/jira/browse/HIVE-7200?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Xuefu Zhang updated HIVE-7200:
------------------------------

    Description: 
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}


  was:
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)




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

Mime
View raw message