I haven't used insert into but i observed a similar problem earlier- https://issues.apache.org/jira/browse/HIVE-2617
You can check against the trunk or open a jira. ~Aniket On Thu, Sep 13, 2012 at 1:36 PM, Kaufman Ng <kauf...@cloudera.com> 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 > -- "...:::Aniket:::... Quetzalco@tl"