[DRILL-456] Inconsistent results between Hive and Drill (an extra row appeared in Drill)

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Assignee: Aman Sinha
• Reporter: Neeraja
• Created: 26/Mar/14 23:13
• Updated: 31/Jul/14 06:32
• Resolved: 20/Apr/14 04:11

Description

Tried a simple query as below.
The results look different between Hive and Drill (note the extra result row in case of Drill)

Query:
select l_returnflag,l_linestatus, count from lineitem group by l_returnflag, l_linestatus order by l_returnflag,l_linestatus;

Hive results:
A F 147790
N F 3765
N O 300716
R F 148301

Drill results:
------------------------------------

EXPR$2

l_returnflag

l_linestatus

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

147790	A	F
3765	N	F
0	N	O
300716	N	O
148301	R	F

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

Issue Links

• duplicates: DRILL-220 streaming-aggregate returning an extra row
• is duplicated by: DRILL-220 streaming-aggregate returning an extra row