[ https://issues.apache.org/jira/browse/HIVE-24282?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Naresh P R updated HIVE-24282: ------------------------------ Description: 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} was: 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} > 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)