[HIVE-24282] Show columns shouldn't sort output columns unless explicitly mentioned.

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Labels: pull-request-available
• Assignee: Naresh P R Assign to me
• Reporter: Naresh P R
• Created: 17/Oct/20 06:16
• Updated: 17/Nov/22 08:48
• Resolved: 21/Oct/20 02:22

Description

CREATE TABLE foo_n7(c INT, a INT, b INT);

show columns in foo_n7;

// current output
a
b 
c
// expected
c
a 
b

HIVE-18373 changed the original behaviour to sorted output.

Suggesting to provide an optional keyword sorted to sort the show columns output

eg., 

show sorted columns in foo_n7;
a
b 
c
show columns in foo_n7
c
a 
b

 

Issue Links

• links to: GitHub Pull Request #1584