Re: Is this a known Bug: Multi Inserts from partitioned source ignore Where Clauses

2013-01-27 Thread Navis류승우
For problems with INSERT INTO, there are HIVE-3465 and HIVE-3676. 2013/1/27 John Omernik : > I am not a code expert, this looks very much like the bug I posted, but my > bug is not using INSERT OVERWRITE (just INSERT INTO) and I am not doing any > group by (probably not an issue) > > Just to be cl

Re: Is this a known Bug: Multi Inserts from partitioned source ignore Where Clauses

2013-01-26 Thread John Omernik
I am not a code expert, this looks very much like the bug I posted, but my bug is not using INSERT OVERWRITE (just INSERT INTO) and I am not doing any group by (probably not an issue) Just to be clear, this is probably the same issue as mine, but if someone with more knowledge of the underlying st

Re: Is this a known Bug: Multi Inserts from partitioned source ignore Where Clauses

2013-01-26 Thread Philip Tromans
This is a known (recently fixed) bug: https://issues.apache.org/jira/browse/HIVE-3699 Phil. On 26 January 2013 15:17, John Omernik wrote: > I ran into an interesting bug. Basically, if your FROM() source is > a partitioned table and you use a where clause that prunes, all of the > INSERT HERE

Is this a known Bug: Multi Inserts from partitioned source ignore Where Clauses

2013-01-26 Thread John Omernik
I ran into an interesting bug. Basically, if your FROM() source is a partitioned table and you use a where clause that prunes, all of the INSERT HERE SELECT * WHERE x=y ignores each specified where clause. This does not occur if the source partition is not specified, but if the source as where par