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  definitive
answer in the web. I am in thr process of installing HIVE locally, but
wanted to check with you before trying it.

Thanks,
-Sukhendu

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
<[EMAIL PROTECTED]> 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  definitive
> answer in the web. I am in thr process of installing HIVE locally, but
> wanted to check with you before trying it.
>
> Thanks,
> -Sukhendu

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

www: oanda.com www: fxtrade.com
e: [EMAIL PROTECTED]

"Best Trading Platform" - World Finance's Forex Awards 2009.
"The One to Watch" - Treasury Today's Adam Smith Awards 2009.
----- Original Message -----
From: "Sukhendu Chakraborty" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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
<[EMAIL PROTECTED]> 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  definitive
> answer in the web. I am in thr process of installing HIVE locally, but
> wanted to check with you before trying it.
>
> Thanks,
> -Sukhendu

We are looking to build an abstraction layer on top of hive where
objects store Hive queries. These queries gets executed when those
objects are accessed by the user. There can be derived obects, for eg.
y = op(x), where y is another Hive query built on top of the  query
represented by x depending on the operator 'op'.

We thought of using WITH clause to achieve these extensions easily.
However, since Hive does not support WITH clause yet, we will look
into the options you suggested.

Thanks,
-Sukhendu

On Tue, Apr 17, 2012 at 11:46 AM, Mark Grover <[EMAIL PROTECTED]> wrote:
> 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
>
> www: oanda.com www: fxtrade.com
> e: [EMAIL PROTECTED]
>
> "Best Trading Platform" - World Finance's Forex Awards 2009.
> "The One to Watch" - Treasury Today's Adam Smith Awards 2009.
>
>
> ----- Original Message -----
> From: "Sukhendu Chakraborty" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> 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
> <[EMAIL PROTECTED]> 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  definitive
>> answer in the web. I am in thr process of installing HIVE locally, but
>> wanted to check with you before trying it.
>>
>> Thanks,
>> -Sukhendu