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

Posted to dev@hive.apache.org by "Shreepadma Venugopalan (JIRA)" <ji...@apache.org> on 2012/10/20 23:50:11 UTC

[jira] [Commented] (HIVE-2794) Aggregations without grouping should return NULL when applied to partitioning column of a partitionless table

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

Shreepadma Venugopalan commented on HIVE-2794:
----------------------------------------------

SQL standard dictates that the return value should be NULL. However, HiveQL seems to deviate and return an empty result set for other aggregate functions as well. This needs to be fixed to achieve parity with the SQL standard.
                
> Aggregations without grouping should return NULL when applied to partitioning column of a partitionless table
> -------------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-2794
>                 URL: https://issues.apache.org/jira/browse/HIVE-2794
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Carl Steinbach
>            Assignee: Zhenxiao Luo
>         Attachments: HIVE-2794.1.patch.txt
>
>


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira