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 Plain View
Pig >> mail # user >> how to filter empty string


+
Dan Yi 2013-02-26, 23:41
+
Young Ng 2013-02-27, 01:12
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.
>>
>>
>>
>>
>>
>
+
Young Ng 2013-02-27, 01:21
+
Jinyuan Zhou 2013-02-27, 01:22
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