You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Greg Rahn (JIRA)" <ji...@apache.org> on 2017/06/19 22:39:00 UTC

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

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

Greg Rahn closed IMPALA-4139.
-----------------------------
    Resolution: Duplicate

[~dhecht] - Yes.  Closing as such.

> add support for ORDER BY to GROUP_CONCAT()
> ------------------------------------------
>
>                 Key: IMPALA-4139
>                 URL: https://issues.apache.org/jira/browse/IMPALA-4139
>             Project: IMPALA
>          Issue Type: Improvement
>          Components: Backend, Frontend
>    Affects Versions: Impala 2.8.0
>            Reporter: Greg Rahn
>            Priority: Minor
>              Labels: built-in-function, ramp-up
>
> 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|http://www.cloudera.com/documentation/enterprise/latest/topics/impala_group_concat.html]:
> {noformat}
> GROUP_CONCAT([DISTINCT] expr [,expr ...]
>              [ORDER BY {unsigned_integer | col_name | expr}
>                  [ASC | DESC] [,col_name ...]]
>              [SEPARATOR str_val])
> {noformat}



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