hi Lefty, Thanks again for the crisp response. After going through it all over again , and brooding over the weekend I understood that my ask is yet not there and I was trying to do things in a (yet) impractical way.
I am sure it will be the need in future , if we were to use and promote Hive as The 'SQL' engine for Hadoop in the longer run. Till then I will rather stick to my old technique of handling UPDATE as DELETE+INSERT and leveraging dynamic partitions to achieve the objective. warm regards Devopam On Sat, Jan 17, 2015 at 1:48 PM, Lefty Leverenz <leftylever...@gmail.com> wrote: > 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 >> > > -- Devopam Mittra Life and Relations are not binary
