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] [Updated] (HIVE-7200) Beeline output displays column heading even if --showHeader=false is set
Date Mon, 09 Jun 2014 20:05:01 GMT

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

Mime
View raw message