[ https://issues.apache.org/jira/browse/PIG-3021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16024340#comment-16024340 ]
Nian Ji commented on PIG-3021: ------------------------------ Daniel Dai, thank you. I will create another Jira and add a patch with adding documentation. > 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: Nian Ji > Fix For: 0.17.0 > > Attachments: PIG-3021-2.patch, PIG-3021-3.patch, PIG-3021-4.patch, > PIG-3021.patch > > > 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 was sent by Atlassian JIRA (v6.3.15#6346)