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
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
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