[
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, a INT, b INT);
show columns in foo_n7;
{code:java}
// current output
a
b
c
// expected
c
a
b{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
a
b{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, a INT, b INT);
> show columns in foo_n7;
> {code:java}
> // current output
> a
> b
> c
> // expected
> c
> a
> b{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
> a
> b{code}
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
