pig-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Prasanth J (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PIG-2726) Handling legitimate NULL values
Date Mon, 18 Jun 2012 04:36:42 GMT

    [ 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


View raw message