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
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.
>>>
>>>
>>>
>>>
>>>
>>
>
+
Jinyuan Zhou 2013-02-27, 01:22