Hive update with subquery

Question

I'm trying to update a Hive table from subquery and I know hive doesn't support such updates. Is there any work-around for this?

My update looks like this

UPDATE tmp_aka
    SET guid = (SELECT mguid FROM tmp_maxs
                                        WHERE tmp_maxs.guid = tmp_aka.guid);

Answer 1

May be you can create a table for your select statement result and insert a new value with insert into table select values from newly created table