-Re: insert into table not working with tables prefixed with database name
Aniket Mokashi 2012-09-13, 23:34
I haven't used insert into but i observed a similar problem earlier-
You can check against the trunk or open a jira.
On Thu, Sep 13, 2012 at 1:36 PM, 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.