Thanks all for your help.. I think was not so much clear about what I was trying to do...
I was just trying to create a variable in Hive like in RDBMS, and want to store the result of a query into that variable. lets say, I have declared a variable MY_VAR I want to store the result of hive query "select max(salary) from Hive_employe_table" ; into MY_VAR Is it possible in Hive ? if yes then how to achieve.. Thanks a lot in advance. Pls suggest or to work around it Thanks & Regards Yogesh On Mon, Jan 6, 2014 at 12:36 PM, lxw <lxw1...@qq.com> wrote: > > maybe you can see: > > > https://cwiki.apache.org/confluence/plugins/viewsource/viewpagesrc.action?pageId=30754722 > > > ------------------ Original ------------------ > *From: * "yogesh dhari";<yogeshh...@gmail.com>; > *Date: * Fri, Jan 3, 2014 01:13 AM > *To: * "user"<user@hive.apache.org>; > *Subject: * working with HIVE VARIALBE: Pls suggest > > Hello Hive Champs, > I have a case statement, where I need to check the date passed through > parameter, > If date is 1st date of the month then keep it as it as > else > set the parameter date to 1st date of the month. > and then later opretation are being performed on that date into hive > quries, > I have wrote this Hive QL > *select case when as_of_dt = ${hivevar:as_of_dt} then > ${hivevar:as_of_dt} else date_sub(${hivevar:as_of_dt} , > (day(${hivevar:as_of_dt} )) -1 ) end as as_of_dt from TABLE group by > as_of_dt ;* > O/P of this query is, lets say = 2012-08-01 > > I want to store the value of this Query into a variable. > like > > MY_VARIABLE = (*select case when as_of_dt = ${hivevar:as_of_dt} then > ${hivevar:as_of_dt} else date_sub(${hivevar:as_of_dt} , > (day(${hivevar:as_of_dt} )) -1 ) end as as_of_dt from TABLE group by > as_of_dt; )* > > > > How to achieve that. > Pls suggest, > Thanks in advance >