hadoop-pig-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alan Gates (JIRA)" <j...@apache.org>
Subject [jira] Commented: (PIG-1014) Pig should convert COUNT(relation) to COUNT_STAR(relation) so that all records are counted without considering nullness of the fields in the records
Date Tue, 13 Oct 2009 16:23:31 GMT

    [ https://issues.apache.org/jira/browse/PIG-1014?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12765136#action_12765136
] 

Alan Gates commented on PIG-1014:
---------------------------------

I think I agree with Santhosh here.  While it may be unfortunate that our syntax makes it
difficult to match the rather strange semantics of COUNT(x) vs COUNT(*) in SQL, I'm not sure
trying to make a distinct between COUNT(A) and COUNT(A.$0) is the right solution.  This will
not be obvious at all to users.  If anything, the right way to do this would be COUNT(A.*),
but I'm not sure even about that.

> Pig should convert COUNT(relation) to COUNT_STAR(relation) so that all records are counted
without considering nullness of the fields in the records
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: PIG-1014
>                 URL: https://issues.apache.org/jira/browse/PIG-1014
>             Project: Pig
>          Issue Type: Bug
>    Affects Versions: 0.4.0
>            Reporter: Pradeep Kamath
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message