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 Threaded View
Hive >> mail # user >> insert into table not working with tables prefixed with database name


Copy link to this message
-
Re: insert into table not working with tables prefixed with database name
This query works on my hive 0.8

insert into table tmp.testtest select user,city from source;

On Fri, Sep 14, 2012 at 4:36 AM, Kaufman Ng <[EMAIL PROTECTED]> wrote:
> Does anyone know if insert into statement is supposed to work across
> databases/schemas?
>
> For instance if I do this the target table gets appended correctly:
>
> insert into table target select * from source;
>
> However, if I have another target table in a different database, the
> target table simply gets overwritten instead of appended:
>
> insert into table my_database.target select * from source;
>
> To get around this, one needs to switch to the target database first,
> then run the insert into statement like this:
>
> insert into table target select * from default.source;
>
> Just wanna confirm if this is a bug.  Thx.
>
> Kaufman
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