[
https://issues.apache.org/jira/browse/PIG-3021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13699210#comment-13699210
]
Ville Weijo commented on PIG-3021:
----------------------------------
Hi,
I think adding a keyword is ok, as long as documentation is updated to make it
clear what is the difference between the plain OTHERWISE and OTHERWISE
NULLABLE. Of course, that should be done in any case.
About the name of the optional keyword, something like plain ALL might also do.
That way it would be clear from a pig script that the rest of the records will
go to the specified place and perhaps notify the reader that it is a good idea
to check the documentation on what is going on, although NULLABLE should raise
a question on exact mechanism of SPLIT, too.
> 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
> Fix For: 0.12
>
> Attachments: PIG-3021-2.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 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
