Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

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


Copy link to this message
-
Re: working with HIVE VARIALBE: Pls suggest
Here's the same wikidoc in its usual display mode:  Variable
Substitution<https://cwiki.apache.org/confluence/display/Hive/LanguageManual+VariableSubstitution>
.

-- Lefty
On Sun, Jan 5, 2014 at 11:06 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
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB