You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@pig.apache.org by "Ted Dunning (JIRA)" <ji...@apache.org> on 2008/08/21 20:46:46 UTC

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

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.