Re: insert into table not working with tables prefixed with database name

2012-09-18 Thread Kaufman Ng
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

Re: insert into table not working with tables prefixed with database name

2012-09-16 Thread MiaoMiao
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

Re: insert into table not working with tables prefixed with database name

2012-09-14 Thread Kaufman Ng
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

Re: insert into table not working with tables prefixed with database name

2012-09-13 Thread MiaoMiao
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

Re: insert into table not working with tables prefixed with database name

2012-09-13 Thread Aniket Mokashi
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