[ 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.