Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> WITH clause support in HIVE

Sukhendu Chakraborty 2012-04-17, 18:02
Sukhendu Chakraborty 2012-04-17, 18:23
Mark Grover 2012-04-17, 18:46
Copy link to this message
Re: WITH clause support in HIVE
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:
> 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
> "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]>
> 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