I have created HIVE-3465 for this issue.
On Mon, Sep 17, 2012 at 1:17 AM, MiaoMiao <liy...@gmail.com> wrote: > 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