You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Carter Shanklin (JIRA)" <ji...@apache.org> on 2017/02/20 05:48:44 UTC

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

Carter Shanklin created HIVE-15977:
--------------------------------------

             Summary: Support standard ARRAY_AGG
                 Key: HIVE-15977
                 URL: https://issues.apache.org/jira/browse/HIVE-15977
             Project: Hive
          Issue Type: Sub-task
            Reporter: Carter Shanklin


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)