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
Young Ng 2013-02-27, 01:12
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.
>
>
>
>
>