Home | About | Sematext search-lucene.com search-hadoop.com
 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.
>>
>>
>>
>>
>>
>