[DRILL-4825] Wrong data with UNION ALL when querying different sub-directories under the same table

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.6.0, 1.7.0, 1.8.0
• Fix Version/s: 1.8.0
• Component/s: Query Planning & Optimization
• Assignee: Jinfeng Ni
• Reporter: Rahul Kumar Challapalli
• Reviewer: Rahul Kumar Challapalli
• Created: 03/Aug/16 20:38
• Updated: 22/Aug/16 18:54
• Resolved: 05/Aug/16 20:31

Description

git.commit.id.abbrev=0700c6b

The below query returns wrongs results

select count (*) from (
  select l_orderkey, dir0 from l_3level t1 where t1.dir0 = 1 and t1.dir1='one' and t1.dir2 = '2015-7-12'
  union all 
  select l_orderkey, dir0 from l_3level t2 where t2.dir0 = 1 and t2.dir1='two' and t2.dir2 = '2015-8-12') data;
+---------+
| EXPR$0  |
+---------+
| 20      |
+---------+

The wrong result is evident from the output of the below queries

0: jdbc:drill:zk=10.10.100.190:5181> select count (*) from (select l_orderkey, dir0 from l_3level t2 where t2.dir0 = 1 and t2.dir1='two' and t2.dir2 = '2015-8-12');
+---------+
| EXPR$0  |
+---------+
| 30      |
+---------+
1 row selected (0.258 seconds)
0: jdbc:drill:zk=10.10.100.190:5181> select count (*) from (select l_orderkey, dir0 from l_3level t2 where t2.dir0 = 1 and t2.dir1='one' and t2.dir2 = '2015-7-12');
+---------+
| EXPR$0  |
+---------+
| 10      |
+---------+

I attached the data set. Let me know if you need anything more

Issue Links

• links to: GitHub Pull Request #559