Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

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


+
VanHuy Pham 2012-07-10, 06:06
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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB