Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> insert into table not working with tables prefixed with database name


+
Kaufman Ng 2012-09-13, 20:36
Copy link to this message
-
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 <[EMAIL PROTECTED]> 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"
+
MiaoMiao 2012-09-14, 03:07
+
Kaufman Ng 2012-09-14, 14:13
+
MiaoMiao 2012-09-17, 05:17