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
try it on the console.
load a small set of data, then dump it right away.

seems like you also need to handle "", if you are using the default loader
On Feb 26, 2013, at 5:16 PM, Dan Yi <[EMAIL PROTECTED]> wrote:

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