Hive update question

[Andy Srine]

Hi Team,

Whats the best way to do an update on one table from another? Variations of
this syntax below doesn't seem to work:

UPDATE table_x
SET column_1 = B.column_1
FROM
table_y B
WHERE column_2 = B.column_2
;


Thanks,
Andy