You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Teddy Choi (JIRA)" <ji...@apache.org> on 2017/02/26 12:57:46 UTC

[jira] [Assigned] (HIVE-15977) Support standard ARRAY_AGG

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

Teddy Choi reassigned HIVE-15977:
---------------------------------

    Assignee: Teddy Choi

> Support standard ARRAY_AGG
> --------------------------
>
>                 Key: HIVE-15977
>                 URL: https://issues.apache.org/jira/browse/HIVE-15977
>             Project: Hive
>          Issue Type: Sub-task
>          Components: SQL
>            Reporter: Carter Shanklin
>            Assignee: Teddy Choi
>
> 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.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)