> On Apr 18, 2016, at 15:34, Mich Talebzadeh <mich.talebza...@gmail.com> wrote: > > Hi, > <snip> > > If Hive had the ability (organic) to have local variable and stored procedure > support then it would be top notch Data Warehouse. Given its metastore, I > don't see any technical reason why it cannot support these constructs. > Are you aware of the HPL/SQL module added in Hive 2.0? If not see https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=59690156 It’s not deeply integrated yet but it’s a step in the procedural direction.
Alan.
