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)