[jira] Commented: (PIG-875) Making COUNT and AVG semantics SQL compliant

["David Ciemiewicz (JIRA)" <ji...@apache.org>]

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

David Ciemiewicz commented on PIG-875:
--------------------------------------

Can I suggest that we might the default to behavior to be to not count nulls, but we might want a way for nulls to be counted with AVG_WITH_NULLS and COUNT_WITH_NULLS or that we might want a DEFINE statement to set an option to turn on and off null count behavior.

> Making COUNT and AVG semantics SQL compliant
> --------------------------------------------
>
>                 Key: PIG-875
>                 URL: https://issues.apache.org/jira/browse/PIG-875
>             Project: Pig
>          Issue Type: Bug
>            Reporter: Olga Natkovich
>            Assignee: Olga Natkovich
>             Fix For: 0.4.0
>
>
> Currently both AVG and COUNT counts NULLs

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