self join in pig

Hi, I need to subtract row2 value from row1. how to get it in Pig? Thanks Rajesh

Re: Logging error messages in Pig

After I started a new session -   its working. Thanks. From: Shahab Yunus To: user@pig.apache.org; Raj Hadoop Sent: Tuesday, June 4, 2013 12:09 PM Subject: Re: Logging error messages in Pig Was there an error in your pig script? Aren't only

Re: Logging error messages in Pig

ges in Pig Hi Raj, You can use "-l" option while starting up pig, or set "pig.logfile" either in your script or pig.properties pig -l foo.log myscript.pig set pig.logfile foo.log  -- within your script pig.logfile=foo.log  # within pig.properties On Fri, May 31, 2013

Logging error messages in Pig

Hi,   How do I modify the error messages file location in Pig.   Is there any property in "pig.properties" or "log4j.properties".   Thanks, Raj

Re: Joining 3 tables in Pig

Joins; > > ILLUSTRATE Joins; > > EXPLAIN Joins: > > DUMP Joins; > > > > If you haven't tried, that would be the first thing to do. > > > > http://pig.apache.org/docs/r0.11.1/basic.html#join-inner > > > > -b > > > > > > >

Joining 3 tables in Pig

Hi, I have a where condition in sql query like below Table1.col1=Table2.col3 and Table2.col2=Table3.col1 and Table3.col3=Table1.col2 In Pig, Can i write like below A= Table1 B=Table2 C=Table3 Joins = join A by col1,B by col3 and B by col2,C by col1 and C by col3,A by cole Please help me.

Re: Generate sequence number in Pig

Thank you so much. On Thu, Apr 25, 2013 at 2:17 AM, j.barrett Strausser < j.barrett.straus...@gmail.com> wrote: > You may use the Rank function. > http://pig.apache.org/docs/r0.11.1/basic.html#rank > > > -b > > > On Wed, Apr 24, 2013 at 4:25 PM, Raj hadoop wr

Generate sequence number in Pig

Hi, Can you please help me to generate sequence number using Pig? Raj

Re: Pig script from sql query

u'll have more luck if you post the errors. > > Off the bat, I assume you are going to have problems given your load > statement. > > -b > > > On Mon, Apr 22, 2013 at 4:59 PM, Raj hadoop wrote: > > > Hi friends, > > > > I am new to PIG script. I need to

Pig script from sql query

Hi friends, I am new to PIG script. I need to convert below sql query to PIG script. SELECT ('CSS'||DB.DISTRICT_CODE||DB.BILLING_ACCOUNT_NO) BAC_KEY, CASE WHEN T1.TAC_142 IS NULL THEN 'N' ELSE T1.TAC_142 END TAC_142 FROM ( SELECT DISTRICT_CODE,BILLING_ACCOUNT_NO, MAX(CASE WHEN TAC_1 = 'Y'

Fwd: SQL to pig latin

Can anybody help on this to convert sql to pig for below query. -- Forwarded message -- From: suneel hadoop Date: Mon, Apr 22, 2013 at 2:49 PM Subject: SQL to pig latin To: user , "u...@hive.apache.org" < u...@hive.apache.org>, user-h...@pig.apache.org -- Forwarded mes

SQL to pig Latin conversion

Hi Can someone help me to convert below SQL to pig Latin SELECT ('CSS'||DB.DISTRICT_CODE||DB.BILLING_ACCOUNT_NO) BAC_KEY, CASE WHEN T1.TAC_142 IS NULL THEN 'N' ELSE T1.TAC_142 END TAC_142 FROM ( SELECT DISTRICT_CODE,BILLING_ACCOUNT_NO, MAX(CASE WHEN TAC_1 = 'Y' AND (TAC_2 = 'Y' OR TAC_3 =

Coding standards of Pig

Hi, We are new to hadoop family(Pig,Hive). We started a project on Pig, We are set to define some coding standards as well performance benchmarking activities so kindly help us with any specific doc you have which help us a lot.