question Re: How to update Hive row with JOIN in Archives of Support Questions (Read Only)

How to update Hive row with JOIN

vzlatkin — Tue, 26 Jan 2016 04:51:12 GMT

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' ...

Re: How to update Hive row with JOIN

ekoifman — Tue, 26 Jan 2016 05:02:22 GMT

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

Re: How to update Hive row with JOIN

vzlatkin — Mon, 07 Mar 2016 07:35:33 GMT

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