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-1561) Doing 2 phase aggregation after an ORDER BY fails
Date Tue, 21 Oct 2014 21:24:34 GMT
Aman Sinha created DRILL-1561:
---------------------------------

             Summary: Doing 2 phase aggregation after an ORDER BY fails 
                 Key: DRILL-1561
                 URL: https://issues.apache.org/jira/browse/DRILL-1561
             Project: Apache Drill
          Issue Type: Bug
          Components: Query Planning & Optimization
    Affects Versions: 0.7.0
            Reporter: Aman Sinha


Doing a COUNT(*) on top of a subquery that has ORDER-BY causes an error 'SingleMergeExchange
only supports a single receiver endpoint'.  See below.
 
// set slice_target to 1 to force introducing Exchanges
0: jdbc:drill:zk=local> alter session set `planner.slice_target` = 1;
+------------+------------+
|     ok     |  summary   |
+------------+------------+
| true       | planner.slice_target updated. |
+------------+------------+
1 row selected (0.066 seconds)

0: jdbc:drill:zk=local> select count(*) from (select o_custkey from cp.`tpch/orders.parquet`
order by o_custkey);
Query failed: Failure while setting up query. SingleMergeExchange only supports a single receiver
endpoint [624ab231-755b-4915-8efd-f19758e514a6]




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

Mime
View raw message