How to update Hive row with JOIN

[#1]

I want to port the following SQL statement to Hive from Sybase. What is the best approach to get the below to work in Hive? Hive DML UPDATE syntax doesn't mention support for JOINs or nested SELECT statements.

UPDATE table1 
 SET table1.column1 = table2.column1,
     table1.column10 = table2.column10
 FROM table1, table2
 WHERE table1.columnID = table2.columnID

After enabling transactional=true on table1 the above produces an error:

Error while compiling statement: FAILED: ParseException ... missing EOF at 'FROM' ...

[#2 · Accepted solution]

This not supported and there is no efficient way to do this. This will be handled once support for MERGE statement is added

[#3]

Thanks. I'll watch this JIRA for progress: https://issues.apache.org/jira/browse/HIVE-10924