[HIVE-4598] Incorrect results when using subquery in multi table insert

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.10.0, 0.11.0
• Component/s: Query Processor
• Assignee: Navis Ryu
• Reporter: Sebastian
• Created: 23/May/13 07:44
• Updated: 22/Mar/14 05:46
• Resolved: 22/Mar/14 05:46

Description

I'm using a multi table insert like this:
FROM <x>
INSERT INTO TABLE t PARTITION (type='x')
SELECT * WHERE type='x'
INSERT INTO TABLE t PARTITION (type='y')
SELECT * WHERE type='y';

Now when <x> is the name of a table, everything works as expected.
However if I use a subquery as <x>, the query runs but it inserts all results from the subquery into each partition, as if there were no "WHERE" clauses in the selects.

Issue Links

• is related to: HIVE-4293 Predicates following UDTF operator are removed by PPD