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.
On Tue, Apr 17, 2012 at 11:46 AM, Mark Grover <[EMAIL PROTECTED]> wrote:
> 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:
> 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.