hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marta Kuczora (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-14387) Add an option to skip the table names for the column headers
Date Mon, 01 Aug 2016 15:09:20 GMT

    [ https://issues.apache.org/jira/browse/HIVE-14387?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15402213#comment-15402213
] 

Marta Kuczora commented on HIVE-14387:
--------------------------------------

Found the following config parameter: 
hive.resultset.use.unique.column.names
Make column names unique in the result set by qualifying column names with table alias if
needed. Table alias will be added to column names for queries of type "select *" or if query
explicitly uses table alias "select r1.x..".
Default value: true

If this parameter is set to false, the result will contain only the column names without the
table name prefix.

Example:
hive.resultset.use.unique.column.names=true
{noformat}
0: jdbc:hive2://> select * from car limit 1;
OK
+------------+-----------+------------+-----------+-----------+--+
| car.carid  | car.type  | car.color  | car.lnum  | car.year  |
+------------+-----------+------------+-----------+-----------+--+
| 1000       | Audi      | red        | AAA111    | 2009      |
+------------+-----------+------------+-----------+-----------+--+
1 row selected (0.084 seconds)
{noformat}

hive.resultset.use.unique.column.names=false
{noformat}
0: jdbc:hive2://> select * from car limit 1;
OK
+--------+-------+--------+---------+-------+--+
| carid  | type  | color  |  lnum   | year  |
+--------+-------+--------+---------+-------+--+
| 1000   | Audi  | red    | AAA111  | 2009  |
+--------+-------+--------+---------+-------+--+
1 row selected (0.084 seconds)
{noformat}

[~vihangk1], would this parameter be a suitable option?

> Add an option to skip the table names for the column headers
> ------------------------------------------------------------
>
>                 Key: HIVE-14387
>                 URL: https://issues.apache.org/jira/browse/HIVE-14387
>             Project: Hive
>          Issue Type: Improvement
>          Components: Beeline
>            Reporter: Vihang Karajgaonkar
>            Assignee: Marta Kuczora
>            Priority: Minor
>
> It would be good to have an option where the beeline output could skip reporting the
<table_name>.<column_name> in the headers.
> Eg:
> {noformat}
> 0: jdbc:hive2://:> select * from sample_07 limit 1; 
> --------------------------------------------------------------------------------------------------
> sample_07.code	sample_07.description	sample_07.total_emp	sample_07.salary
> --------------------------------------------------------------------------------------------------
> 00-0000	Operations	123	12345
> --------------------------------------------------------------------------------------------------
> {noformat}
> b) After the option is set:
> {noformat}
> 0: jdbc:hive2://:> select * from sample_07 limit 1; 
> ---------------------------------------------------
> code	 description	total_emp	 salary
> ---------------------------------------------------
> 00-0000	Operations	123	12345
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message