[
https://issues.apache.org/jira/browse/PIG-2726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13393662#comment-13393662
]
Prasanth J commented on PIG-2726:
---------------------------------
No. Currently there is no way to distinguish between the "unknown" value in
dimensions and "unknown" created by rollups.
I can think of two ways to solve the problem by getting user defined values
1) add ONNULL "some_value" to cube grammar
2) use pig property like pig.olap.onnull "some_value"
these methods allow users to specify a custom value to use for null values in
dimensions instead for defaulting to "unknown". Any thoughts?
> Handling legitimate NULL values
> -------------------------------
>
> Key: PIG-2726
> URL: https://issues.apache.org/jira/browse/PIG-2726
> Project: Pig
> Issue Type: Sub-task
> Affects Versions: 0.11
> Reporter: Prasanth J
> Assignee: Prasanth J
> Attachments: PIG-2726.1.patch
>
>
> Look into SQL/Oracle server for how they are handling legitimate NULL values
> in the input while performing operations like roll-up, filtering etc. Current
> implementation outputs NULL string which should be replaced by actual null
> value.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
