ok. my conscience got the best of me. maybe for worse though. :)
This to me is like giving you a rope and a stool and i don't think it'll
end well.
That said consider something like this:
{code}
select
a.foo1,
a.foo2,
--column to be updated. you need to position it properly
--if null th
Let's just say this. Coercing hive into doing something its not meant to
do is kinda a waste of time. Sure you can rewrite any update as a
delete/insert but that's not the point of Hive.
Seems like your going down a path here that's not optimal for your
situation.
You know, I could buy a Tesla a
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;
*