drill-dev 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-1393) Wrong result for query with Having filter, Order-by and Limit
Date Wed, 10 Sep 2014 00:23:29 GMT
Aman Sinha created DRILL-1393:
---------------------------------

             Summary: Wrong result for query with Having filter, Order-by and Limit
                 Key: DRILL-1393
                 URL: https://issues.apache.org/jira/browse/DRILL-1393
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Operators
    Affects Versions: 0.5.0
            Reporter: Aman Sinha


The following query without LIMIT gives correct results: 
0: jdbc:drill:zk=local> select o_custkey from orders group by o_custkey having o_custkey
< 10 order by o_custkey;
+------------+
| o_custkey  |
+------------+
| 1          |
| 2          |
| 4          |
| 5          |
| 7          |
| 8          |
+------------+

Adding a LIMIT gives 0 rows: 

0: jdbc:drill:zk=local> select o_custkey from orders group by o_custkey having o_custkey
< 10 order by o_custkey limit 10;
+------------+
| o_custkey  |
+------------+
+------------+
No rows selected

Here's the EXPLAIN plan:
0: jdbc:drill:zk=local> explain plan for select o_custkey from orders group by o_custkey
having o_custkey < 10 order by o_custkey limit 10;
+------------+------------+
|    text    |    json    |
+------------+------------+
| 00-00    Screen
00-01      SelectionVectorRemover
00-02        Limit(fetch=[10])
00-03          SelectionVectorRemover
00-04            TopN(limit=[10])
00-05              Filter(condition=[<($0, 10)])
00-06                HashAgg(group=[{0}])
00-07                  HashAgg(group=[{0}])
00-08                    Scan(groupscan=[ParquetGroupScan [entries=[ReadEntryWithPath [path=file:/Users/asinha/data/tpch-sf1/orders]],
selectionRoot=/Users/asinha/data/tpch-sf1/orders, columns=[SchemaPath [`o_custkey`]]]])



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

Mime
View raw message