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

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

Naresh P R created HIVE-24282:
---------------------------------

             Summary: 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


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)