I have created HIVE-3465 for this issue.
On Mon, Sep 17, 2012 at 1:17 AM, MiaoMiao wrote:
> Yes, same problem here, sorry I missed your point and tested only once.
>
> On Fri, Sep 14, 2012 at 10:13 PM, Kaufman Ng wrote:
>> Did you run the insert into query twice? And did it append?
>>
>> From w
Yes, same problem here, sorry I missed your point and tested only once.
On Fri, Sep 14, 2012 at 10:13 PM, Kaufman Ng 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
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 wrote:
> This query works on my hive 0.8
>
> insert into table tmp.testt
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 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
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 wrote:
> Does anyone know if insert into statement is supposed to work across