Hi,
I need to subtract row2 value from row1. how to get it in Pig?
Thanks
Rajesh
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
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
Hi,
How do I modify the error messages file location in Pig.
Is there any property in "pig.properties" or "log4j.properties".
Thanks,
Raj
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
> >
> >
> >
>
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.
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
Hi,
Can you please help me to generate sequence number using Pig?
Raj
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
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'
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
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 =
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.
13 matches
Mail list logo