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 <mgro...@oanda.com> 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: mgro...@oanda.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" <sukhendu.chakrabo...@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.chakrabo...@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 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
