I can't answer your question, but here are some links to documentation in the Hive wiki:
- DML -- Update <https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-Update> - Hive Transactions <https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions> -- Lefty Leverenz On Fri, Jan 16, 2015 at 6:09 AM, Devopam Mittra <devo...@gmail.com> wrote: > hi All, > I wanted to UPDATE multiple rows in a table by joining it with another > table for identification of matching records (otherwise in the RDBMS world > also commonly known as SET based UPDATE). > > The idea is to update multiple records in one go , to downsize the lead > time for each MR job to kick off. > > Is it supported or I am being greedy here with my wishlist ? > > Also, at an atomic level update as well, is there a way I can update a > table without providing explicit variables (aka expression) in the WHERE > clause. > e.g.: I want to update one row in a table and in the where clause i wish > to use a SELECT with other table to identify / match the record. > > Kindly drop a pointer to the syntax manual to look it up. > > Happy weekend ! > -- > Devopam Mittra > Life and Relations are not binary >
