Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Pig >> mail # user >> BinCond is not working


Copy link to this message
-
Re: BinCond is not working
What is the error?

Russell Jurney http://datasyndrome.com

On Apr 26, 2013, at 11:43 AM, soniya B <[EMAIL PROTECTED]> 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
> <[EMAIL PROTECTED]>wrote:
>
>> Paste code?
>> On Apr 26, 2013 10:05 AM, "soniya B" <[EMAIL PROTECTED]> 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?
>>>
>>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB