[IMPALA-4139] add support for ORDER BY to GROUP_CONCAT()

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: Impala 2.8.0
• Component/s: Backend, Frontend
• Labels: built-in-function ramp-up
• Assignee: Unassigned
• Reporter: Greg Rahn
• Created: 15/Sep/16 21:18
• Updated: 19/Jun/17 22:38
• Resolved: 19/Jun/17 22:38

Description

Currently Impala does not support ORDER BY for GROUP_CONCAT(), nor DISTINCT, but seems ordered lists would be most useful of those two if forced to choose just one.

MySQL syntax:

GROUP_CONCAT([DISTINCT] expr [,expr ...]
             [ORDER BY {unsigned_integer | col_name | expr}
                 [ASC | DESC] [,col_name ...]]
             [SEPARATOR str_val])

Issue Links

• is duplicated by: IMPALA-5083 add ORDER BY clause to GROUP_CONCAT()