Did you do this first?
*define BinCond org.apache.pig.piggybank.evaluation.decode.BinCond();*
Russell Jurney http://datasyndrome.com
On Apr 26, 2013, at 11:43 AM, soniya B wrote:
Actually i am trying to convert sql queries to PIG script.
CASE WHEN SVT1= 'Y' THEN 'A'
WHEN SVT2= 'Y' THEN 'B'
WHEN SVT3 = 'Y' THEN 'C'
WHEN SVT4= 'I' THEN 'D'
WHEN SVT5 = 'J' THEN 'E' ELSE 'F' END FROM PEP_ACC_Details
I am trying to convert above statement into PIG script and i have written
A = Load 'PEP_ACC_Details' ;
B= foreach A generate
but it is not working. Could you please verify and let me know..
On Fri, Apr 26, 2013 at 11:02 PM, Russell Jurney
On Apr 26, 2013 10:05 AM, "soniya B" wrote:
I have registered piggy bank.I tried to to use BinCond funcation but it
not working . Any one can suggest why it not working?