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 <[EMAIL PROTECTED]> 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?