You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@pig.apache.org by "Olga Natkovich (JIRA)" <ji...@apache.org> on 2009/01/26 22:55:59 UTC

[jira] Resolved: (PIG-388) FILTER doesn't allow string expressions

     [ https://issues.apache.org/jira/browse/PIG-388?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Olga Natkovich resolved PIG-388.
--------------------------------

    Resolution: Fixed

ne seems to be broken in the latest code and I will open a separate bug on that but using != works

> FILTER doesn't allow string expressions
> ---------------------------------------
>
>                 Key: PIG-388
>                 URL: https://issues.apache.org/jira/browse/PIG-388
>             Project: Pig
>          Issue Type: Bug
>          Components: grunt
>    Affects Versions: 0.1.0
>            Reporter: Ted Dunning
>
> The following scripts fails for a string expression, but works for an arithmetic expression.
> log = LOAD 'tutorial/data/excite-small.log' USING PigStorage('\t') as (ip, date, query);
> t1 = GROUP log by ip;
> describe t1;
> counts = FOREACH t1 {
>    cnt = COUNT(log);
>    GENERATE group as ip, cnt as cnt;
> }
> describe counts;
> r1 = FILTER counts by cnt > 2;
> r2 = FILTER counts by ip ne 'BED75271605EBD0C';
> describe r1;
> describe r2
> dump r2;

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.