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
