Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Re:working with HIVE VARIALBE: Pls suggest


+
lxw 2014-01-06, 07:06
Copy link to this message
-
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 <[EMAIL PROTECTED]> wrote:

>
> maybe you can see:
>
>
> https://cwiki.apache.org/confluence/plugins/viewsource/viewpagesrc.action?pageId=30754722
>
>
> ------------------ Original ------------------
> *From: * "yogesh dhari";<[EMAIL PROTECTED]>;
> *Date: * Fri, Jan 3, 2014 01:13 AM
> *To: * "user"<[EMAIL PROTECTED]>;
> *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
>
+
Sun, Rui 2014-01-07, 02:48
+
Stephen Sprague 2014-01-07, 21:12
+
Sun, Rui 2014-01-08, 02:06
+
Lefty Leverenz 2014-01-06, 11:24
+
yogesh dhari 2014-01-02, 16:43