Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Pig >> mail # dev >> Re: [jira] [Commented] (PIG-2726) Handling legitimate NULL values


Copy link to this message
-
Re: [jira] [Commented] (PIG-2726) Handling legitimate NULL values
Approach as described seems sound to me. Will review path early next week.

On Jun 13, 2012, at 9:46 PM, "Prasanth J (JIRA)" <[EMAIL PROTECTED]> wrote:

>
>    [ 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,unknown,12
> ,unknown,12
> 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
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB