[
https://issues.apache.org/jira/browse/PIG-3021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13691795#comment-13691795
]
Ville Weijo commented on PIG-3021:
----------------------------------
Hi,
I strongly suggest either fixing the implementation or at least changing
documentation of OTHERWISE. At the moment what is documented
(http://pig.apache.org/docs/r0.11.1/basic.html#SPLIT) and what is implemented
does not follow the principle of least surprise, and without knowing the
implementation details of 'OTHERWISE', the documentation is even outright wrong.
Please excuse my perhaps strong wording, but I spent some hours trying to
figure out what on earth is happening. :)
> 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
