Use explicit casting during comparison
Cheers !!!
Arvind
On 02-Feb-2015 8:39 pm, "Amit" <am...@yahoo.com.invalid> wrote:
> Thanks for the response.The Pig script as such does not fail, it runs
> successfully ( trying in local mode), however when the run is finished it
> does not dump any tuples.Has it something to do with the CSV where the f1
> is stored as a string ?The CSV data would look like this -
> *********************************************"10","abc""20","xyz""30,"lmn"...
> etc ***********************************************
> Thanks,Amit
>
> On Monday, February 2, 2015 3:37 AM, Pradeep Gollakota <
> pradeep...@gmail.com> wrote:
>
>
> 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
>
>
