drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aman Sinha (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3069) Wrong result for aggregate query with filter on SF100
Date Wed, 13 May 2015 23:03:59 GMT
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)

Mime
View raw message