You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@pig.apache.org by "Pradeep Kamath (JIRA)" <ji...@apache.org> on 2008/09/30 22:39:44 UTC

[jira] Commented: (PIG-54) built in aggregate functions fail on invalid input

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

Pradeep Kamath commented on PIG-54:
-----------------------------------

SUM handles this, we count NULLs in COUNT - AVG works based on these.

The patch fixed MIN and MAX

> built in aggregate functions fail on invalid input
> --------------------------------------------------
>
>                 Key: PIG-54
>                 URL: https://issues.apache.org/jira/browse/PIG-54
>             Project: Pig
>          Issue Type: Bug
>    Affects Versions: types_branch
>            Reporter: Olga Natkovich
>            Assignee: Pradeep Kamath
>             Fix For: types_branch
>
>         Attachments: PIG-54.patch
>
>
> This issue is true for all built-in aggregate functions. If they get type different from what they expect, they through an exception. Instead, they should treat the value as null. We still need to define what that means in Pig but if we stick with SQL definition, all but count(*) computations would ignore them.

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