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

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


Copy link to this message
-
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 <[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
>>> 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