Yes, same problem here, sorry I missed your point and tested only once.
On Fri, Sep 14, 2012 at 10:13 PM, Kaufman Ng <kauf...@cloudera.com> wrote: > Did you run the insert into query twice? And did it append? > > From what I observred the query will complete successfully, but it > overwrites instead of append. That's the problem. > > > On Thu, Sep 13, 2012 at 11:07 PM, MiaoMiao <liy...@gmail.com> wrote: >> 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
