[jira] [Assigned] (HIVE-24282) Show columns shouldn't sort table output columns unless explicitly mentioned.

["Naresh P R (Jira)" <ji...@apache.org>]

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

Naresh P R reassigned HIVE-24282:
---------------------------------


> Show columns shouldn't sort table output columns unless explicitly mentioned.
> -----------------------------------------------------------------------------
>
>                 Key: HIVE-24282
>                 URL: https://issues.apache.org/jira/browse/HIVE-24282
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Naresh P R
>            Assignee: Naresh P R
>            Priority: Major
>
> CREATE TABLE foo_n7(c INT, b INT, a INT);
> show columns in foo_n7;
>  
> {code:java}
> // current output
> a
> b 
> c
> // expected
> c
> b 
> a
> {code}
>  
> HIVE-18373 changed the original behaviour to sorted output.
> Suggesting to provide an optional keyword sorted to sort the show columns output
> eg., 
>  
> {code:java}
> show sorted columns in foo_n7;
> a
> b 
> c
> show columns in foo_n7
> c
> b 
> a
> {code}
>  



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