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

        

Mime
View raw message