You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Aman Sinha (JIRA)" <ji...@apache.org> on 2015/05/14 01:04:00 UTC

[jira] [Created] (DRILL-3069) Wrong result for aggregate query with filter on SF100

Aman Sinha created DRILL-3069:
---------------------------------

             Summary: Wrong result for aggregate query with filter  on SF100 
                 Key: DRILL-3069
                 URL: https://issues.apache.org/jira/browse/DRILL-3069
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Relational Operators
    Affects Versions: 1.0.0
            Reporter: Aman Sinha
            Assignee: Chris Westin


Wrong result on TPCH sf100: 

{code}
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
{code}

Plan looks correct: 
{code}
+------------+------------+
|    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`]]])
{code}




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)