Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB