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 <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