HIVE QUERY HELP:: HOW TO IMPLEMENT THIS CASE

[yogesh dhari]

Hello All,

I have a use case in RDBMS query which I have implemented in
HIVE as..



*1.1) Update statement* *in RDBMS*

update  TABLE1
set
Age= case when isnull(age,'') ='' then 'A= Current' else '240+ Days' end,
Prev_Age=case when isnull(prev_age,'') ='' then 'A= Current' else '240+
Days' end;
*1.2) Update statement* *in HIVE*

create table  TABLE2 as select
a.* ,
case when coalesce(a.age,'')='' then 'A=Current' else '240+ Days' end as
Age,
case when coalesce(a.prev_age,'')='' then 'A=Current' else '240+ Days' end
as Prev_age from TABLE1 a ;





*Now I have a case statement in which I have a join condition*.



*2) Join in RDBMS*
update  TABLE1
set a.Age = c.sys_buscd_item_desc1
from  TABLE1 a
join  TABLE2 c
on c.sys_type_cd='AGE'
where isnull(a.age,'00')=c.sys_item;
commit;





How can I implement this query into Hive, Pls help and suggest.



Thanks In Advance

Yogesh Kumar