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 Thu, 14 Jun 2012 04:46:43 GMT

    [ https://issues.apache.org/jira/browse/PIG-2726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13294806#comment-13294806

Prasanth J commented on PIG-2726:

This patch converts null values in dimensions to "unknown" and uses actual null value for
rollup. For a sample input 

red, ,12

CUBE operator will now generate

red, ,12
 , ,12

Please let me know if it is ok to go ahead with null for rollup? another alternative would
be to use "*" or "all" to represent rollup value. 
> 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