Home | About | Sematext search-lucene.com search-hadoop.com
 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
+
Dan Yi 2013-02-27, 01:16
+
Young Ng 2013-02-27, 01:21
Copy link to this message
-
Re: how to filter empty string
for null:

itemid is not null
should be used
On Tue, 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.
>
>
>
>
>
>
--
-- Jinyuan (Jack) Zhou