-Re: insert into table not working with tables prefixed with database name
MiaoMiao 2012-09-17, 05:17
Yes, same problem here, sorry I missed your point and tested only once.
On Fri, Sep 14, 2012 at 10:13 PM, Kaufman Ng <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> wrote:
>>> Does anyone know if insert into statement is supposed to work across
>>> 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.