Re: Hive update question

Overwrite your table by taking left join with another table. Let me know if you want any syntactical help. On 14-Feb-2018 12:54 PM, "Andy Srine" wrote: > Hi Team, > > Whats the best way to do an update on one table from another? Variations > of this syntax below doesn't

Hive update question

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