[
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)
