impala-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Greg Rahn (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (IMPALA-5083) add ORDER BY clause to GROUP_CONCAT()
Date Tue, 20 Jun 2017 18:25:00 GMT

     [ https://issues.apache.org/jira/browse/IMPALA-5083?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Greg Rahn resolved IMPALA-5083.
-------------------------------
    Resolution: Won't Fix

Marking Won't Fix in favor of implementing LISTAGG() via IMPALA-5545 which provides a superset
of functionality and is part of the SQL:2016 standard.

> add ORDER BY clause to GROUP_CONCAT()
> -------------------------------------
>
>                 Key: IMPALA-5083
>                 URL: https://issues.apache.org/jira/browse/IMPALA-5083
>             Project: IMPALA
>          Issue Type: New Feature
>          Components: Backend, Frontend
>            Reporter: Greg Rahn
>              Labels: ramp-up, sql-language
>
> Currently GROUP_CONCAT() does not allow one to return an ordered result.  The MySQL version
does support this:
> {noformat}
> GROUP_CONCAT([DISTINCT] expr [,expr ...]
>              [ORDER BY {unsigned_integer | col_name | expr}
>                  [ASC | DESC] [,col_name ...]]
>              [SEPARATOR str_val])
> {noformat}
> https://dev.mysql.com/doc/refman/8.0/en/group-by-functions.html#function_group-concat
> For example:
> {noformat}
> mysql> SELECT student_name,
>     ->     GROUP_CONCAT(DISTINCT test_score
>     ->               ORDER BY test_score DESC SEPARATOR ' ')
>     ->     FROM student
>     ->     GROUP BY student_name;
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message