[ 
https://issues.apache.org/jira/browse/PIG-3021?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Cheolsoo Park updated PIG-3021:
-------------------------------

    Assignee: Cheolsoo Park

OK, I will implement the "catch-all" semantics for OTHERWISE. I will add an "IS 
NULL" expression to the otherwise branch, so null values can be caught instead 
of being discarded.

Please let me know if anyone has objection with the change.
                
> Split results missing records when there is null values in the column 
> comparison
> --------------------------------------------------------------------------------
>
>                 Key: PIG-3021
>                 URL: https://issues.apache.org/jira/browse/PIG-3021
>             Project: Pig
>          Issue Type: Bug
>    Affects Versions: 0.10.0
>            Reporter: Chang Luo
>            Assignee: Cheolsoo Park
>
> Suppose a(x, y)
> split a into b if x==y, c otherwise;
> One will expect the union of b and c will be a.  However, if x or y is null, 
> the record won't appear in either b or c.
> To workaround this, I have to change to the following:
> split a into b if x is not null and y is not null and x==y, c otherwise;

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

Reply via email to