Home | About | Sematext search-lucene.com search-hadoop.com
 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
MiaoMiao 2012-09-14, 03:07
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