[HIVE-15977] Support standard ARRAY_AGG

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: SQL
• Assignee: Teddy Choi
• Reporter: Carter Shanklin
• Created: 20/Feb/17 05:48
• Updated: 26/Feb/17 12:57

Description

SQL defines array_agg as a function that returns an array given a value expression in Section 10.9. Hive has something similar called collect_list. The SQL standard array_agg additionally allows sorting by a value expression. It would be good to move to the standard and as a first step it might be worthwhile to have array_agg as an alias and then to add support for sort specifications.