Re: insert into table not working with tables prefixed with database name
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
Re: insert into table not working with tables prefixed with database name
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
Re: insert into table not working with tables prefixed with database name
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
Re: insert into table not working with tables prefixed with database name
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
Re: insert into table not working with tables prefixed with database name
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