hive-issues mailing list archives

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


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:
>             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

View raw message