hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vineet Garg (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-16064) Allow ALL set quantifier with aggregate functions
Date Wed, 01 Mar 2017 00:54:45 GMT

    [ https://issues.apache.org/jira/browse/HIVE-16064?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15889235#comment-15889235
] 

Vineet Garg commented on HIVE-16064:
------------------------------------

Currently HIVE grammar transforms all kind of functions (UDAs, UDFs, UDTFs) into three type
of functions based on presence of star, distinct -  (TOK_FUNCTION,  TOK_FUNCTIONSTAR, TOK_FUNCTIONDI).
This patch adds an optional keyword ALL for all  TOK_FUNCTION. This has a side effect of allowing
{{ALL}}for all kind of aggregates (standard doesn’t permit ALL with STDDEV_POP, STDDEV_SAMP,
VAR_POP, or VAR_SAMP), UDFs and UDTFs. But since this side effect is benign and doesn't modify
the semantics in anyway it should be a safe change.

> Allow ALL set quantifier with aggregate functions
> -------------------------------------------------
>
>                 Key: HIVE-16064
>                 URL: https://issues.apache.org/jira/browse/HIVE-16064
>             Project: Hive
>          Issue Type: Improvement
>          Components: Query Planning
>            Reporter: Vineet Garg
>            Assignee: Vineet Garg
>         Attachments: HIVE-16064.1.patch
>
>
> SQL:2011  allows <set quantifier> ALL with aggregate functions which is equivalent
to aggregate function without ALL.



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

Mime
View raw message