[jira] [Created] (DRILL-1565) Invalid plan for select count(*) with order by subquery

[Jacques Nadeau (JIRA)]

Jacques Nadeau created DRILL-1565:
-------------------------------------

             Summary: Invalid plan for select count(*) with order by subquery
                 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)