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
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'
LEFT OUTER JOIN trans_temp tt
SET fl_t_order = tt.t_order