Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Insert not through any file

Copy link to this message
Re: Insert not through any file
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?
> Thanks

Nitin Pawar