[DRILL-3069] Wrong result for aggregate query with filter on SF100

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Pending Closed
• Affects Version/s: 1.0.0
• Fix Version/s: 1.0.0
• Component/s: Execution - Relational Operators
• Assignee: Steven Phillips
• Reporter: Aman Sinha
• Created: 13/May/15 23:03
• Updated: 14/May/15 04:43
• Resolved: 14/May/15 04:43

Description

Wrong result on TPCH sf100:

0: jdbc:drill:zk=10.10.103.32:5181> select max(l_suppkey) from lineitem where l_suppkey = 3872;
+------------+
|   EXPR$0   |
+------------+
| 991683     |
+------------+
1 row selected

Plan looks correct:

+------------+------------+
|    text    |    json    |
+------------+------------+
| 00-00    Screen
00-01      StreamAgg(group=[{}], EXPR$0=[MAX($0)])
00-02        UnionExchange
01-01          StreamAgg(group=[{}], EXPR$0=[MAX($0)])
01-02            Filter(condition=[=($0, 3872)])
01-03              Scan(groupscan=[ParquetGroupScan [entries=[ReadEntryWithPath [path=maprfs:/data/parquet/tpch/scale100/lineitem]], selectionRoot=/data/parquet/tpch/scale100/lineitem, numFiles=1, columns=[`l_suppkey`]]])