Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (nike.apache.org: domain of
 prvs=mgrover=447a300e1@oanda.com designates 98.158.95.75 as permitted sender)
Date: Tue, 17 Apr 2012 14:46:53 -0400 (EDT)
From: Mark Grover <mgrover@oanda.com>
To: user@hive.apache.org
Message-ID: 
 <1168282010.67653.1334688413036.JavaMail.root@sms-zimbra-message-store-03.sms.scalar.ca>
In-Reply-To: 
 <CADgokzGc3C3k=P+u0TCMMGVo2WrcEqE0xd3tHq9JZag7_du0OQ@mail.gmail.com>
Subject: Re: WITH clause support in HIVE
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Sukhendu,
Perhaps you can use a view or derived table to accomplish the same.

What's  your use case?

Mark Grover, Business Intelligence Analyst
OANDA Corporation=20

www: oanda.com www: fxtrade.com=20
e: mgrover@oanda.com=20

"Best Trading Platform" - World Finance's Forex Awards 2009.=20
"The One to Watch" - Treasury Today's Adam Smith Awards 2009.=20


----- Original Message -----
From: "Sukhendu Chakraborty" <sukhendu.chakraborty@gmail.com>
To: user@hive.apache.org
Sent: Tuesday, April 17, 2012 2:23:33 PM
Subject: Re: WITH clause support in HIVE

Never mind. Its not implemented yet:
https://issues.apache.org/jira/browse/HIVE-1180

On Tue, Apr 17, 2012 at 11:02 AM, Sukhendu Chakraborty
<sukhendu.chakraborty@gmail.com> wrote:
> Resending, as I forgot to change the subject line in my last post. Pls
> respond to this email.
>
> Does HIVE support SQL 99 'WITH' clause yet? I dod not find =C2=A0definiti=
ve
> answer in the web. I am in thr process of installing HIVE locally, but
> wanted to check with you before trying it.
>
> Thanks,
> -Sukhendu