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