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)
