[jira] [Updated] (HIVE-22641) Columns returned in sorted order when show columns query is run with no search pattern.

["Chiran Ravani (Jira)" <ji...@apache.org>]

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

Chiran Ravani updated HIVE-22641:
---------------------------------
    Attachment: HIVE-22641.patch

> Columns returned in sorted order when show columns query is run with no search pattern.
> ---------------------------------------------------------------------------------------
>
>                 Key: HIVE-22641
>                 URL: https://issues.apache.org/jira/browse/HIVE-22641
>             Project: Hive
>          Issue Type: Improvement
>          Components: Hive, HiveServer2
>    Affects Versions: 3.0.0
>            Reporter: Chiran Ravani
>            Priority: Minor
>         Attachments: HIVE-22641.patch
>
>
> In Hive 1.2.1 and 2.0 while displaying columns for a table, it used to return in same order as it was created. for example
> {code}
> create table col_order_test(server_name string, task_name string, partition_name string, start_time string, end_time string, table_owner string, table_name string) stored as orc;
> show columns in col_order_test;
> +-----------------+--+
> |      field      |
> +-----------------+--+
> | server_name     |
> | task_name       |
> | partition_name  |
> | start_time      |
> | end_time        |
> | table_owner     |
> | table_name      |
> +-----------------+--+
> {code}
> For Hive 3 columns are returned in sorted order for the same query, below is output.
> {code}
> create table col_order_test(server_name string, task_name string, partition_name string, start_time string, end_time string, table_owner string, table_name string) stored as orc;
> show columns in col_order_test;
> +-----------------+
> |      field      |
> +-----------------+
> | end_time        |
> | partition_name  |
> | server_name     |
> | start_time      |
> | table_name      |
> | table_owner     |
> | task_name       |
> +-----------------+
> {code}
> Above behaviour looks to be changed with the introduction of search column feature as part of Jira [HIVE-18373 |https://issues.apache.org/jira/browse/HIVE-18373]
> This behaviour change can cause code to generate the INSERT OVERWRITE in a different manner,  which may result in query failure.
> Would like to request community if we can improve the Jira [HIVE-18373 |https://issues.apache.org/jira/browse/HIVE-18373] by returning column order same as it was created if search pattern provided by the user is null.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)