Grokbase Groups Pig user April 2013
FAQ
Hi Friends,

I have registered piggy bank.I tried to to use BinCond funcation but it is
not working . Any one can suggest why it not working?

Search Discussions

  • Russell Jurney at Apr 26, 2013 at 5:32 pm
    Paste code?
    On Apr 26, 2013 10:05 AM, "soniya B" wrote:

    Hi Friends,

    I have registered piggy bank.I tried to to use BinCond funcation but it is
    not working . Any one can suggest why it not working?
  • soniya B at Apr 26, 2013 at 6:43 pm
    Hi Russell,

    Actually i am trying to convert sql queries to PIG script.


    SELECT SUP1,DEP_NO,

    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
    script below

    A = Load 'PEP_ACC_Details' ;

    B= foreach A generate
    SUP1,DEP_NO,BinCond(SVT1,'Y','A',SVT2,'Y','B',SVT3,'Y','C',SVT4,'I','D',SVT5,'J','E','F');

    but it is not working. Could you please verify and let me know..

    Yours

    Soniya


    On Fri, Apr 26, 2013 at 11:02 PM, Russell Jurney
    wrote:
    Paste code?
    On Apr 26, 2013 10:05 AM, "soniya B" wrote:

    Hi Friends,

    I have registered piggy bank.I tried to to use BinCond funcation but it is
    not working . Any one can suggest why it not working?
  • Russell Jurney at Apr 26, 2013 at 7:10 pm
    What is the error?

    Russell Jurney http://datasyndrome.com
    On Apr 26, 2013, at 11:43 AM, soniya B wrote:

    Hi Russell,

    Actually i am trying to convert sql queries to PIG script.


    SELECT SUP1,DEP_NO,

    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
    script below

    A = Load 'PEP_ACC_Details' ;

    B= foreach A generate
    SUP1,DEP_NO,BinCond(SVT1,'Y','A',SVT2,'Y','B',SVT3,'Y','C',SVT4,'I','D',SVT5,'J','E','F');

    but it is not working. Could you please verify and let me know..

    Yours

    Soniya


    On Fri, Apr 26, 2013 at 11:02 PM, Russell Jurney
    wrote:
    Paste code?
    On Apr 26, 2013 10:05 AM, "soniya B" wrote:

    Hi Friends,

    I have registered piggy bank.I tried to to use BinCond funcation but it is
    not working . Any one can suggest why it not working?
  • soniya B at Apr 27, 2013 at 3:23 am
    Hi Russell,

    I have already executed below one but no luck

    register piggybank.jar
    *define BinCond org.apache.pig.piggybank.evaluation.decode.BinCond();*

    I am getting syntax error as mismatched input '(' expecting SEMI_COLON

    Is the syntax correct that i have written?

    Thanks
    Soniya


    On Sat, Apr 27, 2013 at 12:40 AM, Russell Jurney
    wrote:
    What is the error?

    Russell Jurney http://datasyndrome.com
    On Apr 26, 2013, at 11:43 AM, soniya B wrote:

    Hi Russell,

    Actually i am trying to convert sql queries to PIG script.


    SELECT SUP1,DEP_NO,

    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
    script below

    A = Load 'PEP_ACC_Details' ;

    B= foreach A generate
    SUP1,DEP_NO,BinCond(SVT1,'Y','A',SVT2,'Y','B',SVT3,'Y','C',SVT4,'I','D',SVT5,'J','E','F');
    but it is not working. Could you please verify and let me know..

    Yours

    Soniya


    On Fri, Apr 26, 2013 at 11:02 PM, Russell Jurney
    wrote:
    Paste code?
    On Apr 26, 2013 10:05 AM, "soniya B" wrote:

    Hi Friends,

    I have registered piggy bank.I tried to to use BinCond funcation but it is
    not working . Any one can suggest why it not working?
  • Miguel Angel Martin junquera at Apr 29, 2013 at 3:29 pm
    register /path_to_yourjars/piggybank.jar*;*
    define BinCond org.apache.pig.piggybank.evaluation.decode.BinCond();


    2013/4/27 soniya B <soniya.bigdata@gmail.com>
    Hi Russell,

    I have already executed below one but no luck

    register piggybank.jar
    *define BinCond org.apache.pig.piggybank.evaluation.decode.BinCond();*

    I am getting syntax error as mismatched input '(' expecting SEMI_COLON

    Is the syntax correct that i have written?

    Thanks
    Soniya


    On Sat, Apr 27, 2013 at 12:40 AM, Russell Jurney
    wrote:
    What is the error?

    Russell Jurney http://datasyndrome.com
    On Apr 26, 2013, at 11:43 AM, soniya B wrote:

    Hi Russell,

    Actually i am trying to convert sql queries to PIG script.


    SELECT SUP1,DEP_NO,

    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
    script below

    A = Load 'PEP_ACC_Details' ;

    B= foreach A generate
    SUP1,DEP_NO,BinCond(SVT1,'Y','A',SVT2,'Y','B',SVT3,'Y','C',SVT4,'I','D',SVT5,'J','E','F');
    but it is not working. Could you please verify and let me know..

    Yours

    Soniya


    On Fri, Apr 26, 2013 at 11:02 PM, Russell Jurney
    wrote:
    Paste code?
    On Apr 26, 2013 10:05 AM, "soniya B" wrote:

    Hi Friends,

    I have registered piggy bank.I tried to to use BinCond funcation but
    it
    is
    not working . Any one can suggest why it not working?
  • Russell Jurney at Apr 26, 2013 at 7:15 pm
    Did you do this first?

    register piggybank.jar
    *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:

    Hi Russell,

    Actually i am trying to convert sql queries to PIG script.


    SELECT SUP1,DEP_NO,

    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
    script below

    A = Load 'PEP_ACC_Details' ;

    B= foreach A generate
    SUP1,DEP_NO,BinCond(SVT1,'Y','A',SVT2,'Y','B',SVT3,'Y','C',SVT4,'I','D',SVT5,'J','E','F');

    but it is not working. Could you please verify and let me know..

    Yours

    Soniya


    On Fri, Apr 26, 2013 at 11:02 PM, Russell Jurney
    wrote:

    Paste code?

    On Apr 26, 2013 10:05 AM, "soniya B" wrote:


    Hi Friends,


    I have registered piggy bank.I tried to to use BinCond funcation but it

    is

    not working . Any one can suggest why it not working?
  • soniya B at Apr 26, 2013 at 7:40 pm
    Hi Russell,

    I have already executed below one but no luck

    register piggybank.jar
    *define BinCond org.apache.pig.piggybank.evaluation.decode.BinCond();*

    I am getting syntax error as mismatched input '(' expecting SEMI_COLON




    On Sat, Apr 27, 2013 at 12:44 AM, Russell Jurney
    wrote:
    Did you do this first?

    register piggybank.jar
    *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:

    Hi Russell,

    Actually i am trying to convert sql queries to PIG script.


    SELECT SUP1,DEP_NO,

    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
    script below

    A = Load 'PEP_ACC_Details' ;

    B= foreach A generate

    SUP1,DEP_NO,BinCond(SVT1,'Y','A',SVT2,'Y','B',SVT3,'Y','C',SVT4,'I','D',SVT5,'J','E','F');

    but it is not working. Could you please verify and let me know..

    Yours

    Soniya


    On Fri, Apr 26, 2013 at 11:02 PM, Russell Jurney
    wrote:

    Paste code?

    On Apr 26, 2013 10:05 AM, "soniya B" wrote:


    Hi Friends,


    I have registered piggy bank.I tried to to use BinCond funcation but it

    is

    not working . Any one can suggest why it not working?

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categoriespig, hadoop
postedApr 26, '13 at 5:05p
activeApr 29, '13 at 3:29p
posts8
users3
websitepig.apache.org

People

Translate

site design / logo © 2021 Grokbase