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

Cheolsoo Park commented on PIG-3021:
------------------------------------

Given the discussion on the user mailing list, I don't think that we're going 
to change the current behavior:
http://search-hadoop.com/m/5KtFWXN4me1/CONCAT%2528null%252C+%2522something%2522%2529+%253D%253D+NULL+%253F&subj=CONCAT+null+something+NULL+

I am going to close this jira as a 'won't fix'. Please let me if anyone has 
objections.

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