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 # user >> how to filter empty string


Copy link to this message
-
Re: how to filter empty string
Hi,Young,

I tried that one too, still won't work

On 2/26/13 5:12 PM, "Young Ng" <[EMAIL PROTECTED]> wrote:

>C = FILTER B BY itemid  is null;
>
>you cant use == or != for null value
>
>On Feb 26, 2013, at 3:41 PM, Dan Yi <[EMAIL PROTECTED]> wrote:
>
>> Hi,
>>
>> I have data as following :
>>
>> Timestamp  itemid  actiontype
>>
>> "2012-11-01T23:59:59.000+0000" "" "Search"
>> "2012-11-01T23:59:59.000+0000" "688531" "ShowItemDetail"
>> ..
>>
>> I want to filter out all the lines that have itemid as empty,
>> I tried different approach but none of work:
>>
>> C = FILTER B BY itemid != '';
>> C = FILTER B BY itemid != null;
>>
>>
>> Anyone knows how to do it? Thanks.
>>
>>
>>
>>
>>
>
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