[DRILL-220] streaming-aggregate returning an extra row

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.1.0-m1
• Fix Version/s: 0.4.0
• Assignee: Aman Sinha
• Reporter: Steven Phillips
• Created: 07/Sep/13 00:56
• Updated: 31/Jul/14 06:31
• Resolved: 27/Apr/14 22:48

Description

Here is a physical plan:

{
head : {
type : "APACHE_DRILL_PHYSICAL",
version : 1,
generator :

{ type : "optiq", info : "na" }

},
graph : [ {
pop : "parquet-scan",
@id : 1,
entries : [

{ path : "/tmp/tpc-h/customer" }

],
storageengine :

{ type : "parquet", dfsName : "file:///" }

,
ref : "_MAP",
fragmentPointer : 0
}, {
pop : "project",
@id : 2,
exprs : [

{ ref : "output.NATIONKEY", expr : "_MAP.C_NATIONKEY" }

,

{ ref : "output.CUSTKEY", expr : "_MAP.C_CUSTKEY" }

],
child : 1
}, {
pop : "sort",
@id : 3,
child : 2,
orderings : [

{ order : "ASC", expr : "NATIONKEY" }

],
reverse : false
}, {
pop : "streaming-aggregate",
@id : 4,
child : 3,
keys : [

{ ref : "NATIONKEY", expr : "NATIONKEY" }

],
exprs : [

{ ref : "CUSTOMERS", expr : "count(1) " }

]
},

{ pop : "screen", @id : 5, child : 4 }

]
}

It is returning these results:

-----------------------------------

NATIONKEY

CUSTOMERS

-----------------------------------

4	0
0	59916
1	59841
2	59952
3	59849
4	59969
5	60471
6	60316
7	60153
8	60215
9	60236
10	60101
11	60056
12	59757
13	59909
14	59476
15	59834
16	59796
17	59788
18	60065
19	60048
20	59803
21	59997
22	60065
23	60381
24	60006

-----------------------------------

Issue Links

• duplicates: DRILL-456 Inconsistent results between Hive and Drill (an extra row appeared in Drill)
• is duplicated by: DRILL-456 Inconsistent results between Hive and Drill (an extra row appeared in Drill)