hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sun, Rui" <rui....@intel.com>
Subject RE: working with HIVE VARIALBE: Pls suggest
Date Tue, 07 Jan 2014 02:48:12 GMT
Directly saving the query result into a variable is not supported now. You may consider saving
the result into an intermediate table or file to be used by subsequent queries.

If you indeed want a variable, here is some trick you may try:

Hive -e "insert overwrite local directory '/tmp/result' select max(salary) from Hive_employe_table"
Hive -e -hiveconf MY_VAR =`cat /tmp/result/000000_0`


From: yogesh dhari [mailto:yogeshhive@gmail.com]
Sent: Tuesday, January 07, 2014 2:25 AM
To: user@hive.apache.org
Subject: Re: working with HIVE VARIALBE: Pls suggest

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 <lxw1234@qq.com<mailto:lxw1234@qq.com>> wrote:

maybe you can see:
https://cwiki.apache.org/confluence/plugins/viewsource/viewpagesrc.action?pageId=30754722

------------------ Original ------------------
From:  "yogesh dhari";<yogeshhive@gmail.com<mailto:yogeshhive@gmail.com>>;
Date:  Fri, Jan 3, 2014 01:13 AM
To:  "user"<user@hive.apache.org<mailto: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


Mime
View raw message