Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive table update from another table

Hive table update from another table

New Contributor

Hi,

I have a clustered bucketted table, with ACID enabled

Does hive supports updates from another table?

This is something I am trying to achieve, updating a column values from another table

UPDATE transaction_bak

SET fl_t_order = tt.t_order

FROM trans_temp tt

WHERE transaction_bak.id = tt.id;

I tried with left join, but no success, getting ParseException line 2:0 missing SET at 'left'

UPDATE transaction_bak

LEFT OUTER JOIN trans_temp tt

SET fl_t_order = tt.t_order

WHERE transaction_bak.id = tt.id;

Any idea