[
https://issues.apache.org/jira/browse/DRILL-1565?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau resolved DRILL-1565.
-----------------------------------
Resolution: Duplicate
> Invalid plan for select count(1) from (select with orderby)
> -----------------------------------------------------------
>
> Key: DRILL-1565
> URL: https://issues.apache.org/jira/browse/DRILL-1565
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Reporter: Jacques Nadeau
> Assignee: Aman Sinha
> Priority: Critical
>
> select count(*) from (select l_orderkey from lineitem l
> where l.l_commitdate < l.l_receiptdate
> order by l_orderkey);
>
> org.apache.drill.common.exceptions.PhysicalOperatorSetupException:
> SingleMergeExchange only supports a single receiver endpoint
> at
> org.apache.drill.exec.physical.config.SingleMergeExchange.setupReceivers(SingleMergeExchange.java:67)
> at
> org.apache.drill.exec.physical.base.AbstractExchange.setupReceivers(AbstractExchange.java:57)
> at
> org.apache.drill.exec.planner.fragment.Wrapper.assignEndpoints(Wrapper.java:203)
> at
> org.apache.drill.exec.planner.fragment.SimpleParallelizer.assignEndpoints(SimpleParallelizer.java:200)
> at
> org.apache.drill.exec.planner.fragment.SimpleParallelizer.getFragments(SimpleParallelizer.java:95)
> at
> org.apache.drill.exec.work.foreman.Foreman.runPhysicalPlan(Foreman.java:357)
> at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:384)
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:201)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
