Just to clarify, do you have a semicolon after f1 > 20?
A = LOAD 'data' USING PigStorage(',');
B = FOREACH A GENERATE f1;
C = FILTER B BY f1 > 20;
DUMP C;
This should be correct.
On Sun, Feb 1, 2015 at 4:50 PM, Amit <am...@yahoo.com.invalid> wrote:
> Hello,I am trying to run a Ad-hoc pig script on IBM Bluemix platform that
> has a arithmetic comparison.Suppose the data is ----f1-----10203040..
> Let us say I would like to select the records where f1 > 20 . It is pretty
> easy operation, however I am not sure why I cannot see expected results in
> there.The data is initially loaded from a CSV file.Here is may pig script
> -
> ********************************************************************************************A
> = << Load from CSV file >> B = FOREACH A generate f1;C = FILTER B by f1 >
> 20DUMP
> C;********************************************************************************************
> Appreciate if someone points out what I am doing wrong here.
> I also tried to run this in local mode just to make sure I am doing this
> right.
> Regards,Amit
