hive does not support update as a query its a costly operation to update records in hive as a hadoop based system mainly its meant like write once read many times
On Tue, Jul 10, 2012 at 11:36 AM, VanHuy Pham <huy.pham...@gmail.com> wrote: > Hi All, > Is it possible to insert and/or update some data in a hive table not > through any local file? > To be specific, I look to insert and update some data (not large > amount) to a hive table through queries (like insert into...) in a > traditional SQL style, where you specify the new data in the queries. > I only found INSERT or LOAD where you have to specify SELECT...from > some other tables or files, and did not find any UPDATE. > Any ideas? > > Thanks > -- Nitin Pawar
