[DRILL-1565] Invalid plan for select count(1) from (select with orderby)

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Duplicate
• Fix Version/s: 0.7.0
• Component/s: Query Planning & Optimization
• Assignee: Aman Sinha
• Reporter: Jacques Nadeau
• Created: 22/Oct/14 04:42
• Updated: 09/Dec/14 17:47
• Resolved: 22/Oct/14 05:15

Description

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)

Issue Links

• duplicates: DRILL-1561 Doing 2 phase aggregation after an ORDER BY fails