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
