Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-1846

Re-ordering output of a subquery on a different column causes error

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.7.0
    • Component/s: None
    • Labels:
      None

      Description

      In the following the subquery does an order by on n_regionkey and the outer query does another order-by on n_nationkey. I have to set the slice_target = 1 for this particular data set but for the general case it is not needed. This query errors out:

      alter session set `planner.slice_target` = 1
       select n.n_nationkey 
            from  (select n_nationkey, n_regionkey from cp.`tpch/nation.parquet` 
                         order by n_regionkey) n 
        order by n.n_nationkey;
      
        Query failed: Query failed: Unexpected exception during fragment initialization: SingleMergeExchange only supports a single receiver endpoint
      

        Attachments

          Activity

            People

            • Assignee:
              amansinha100 Aman Sinha
              Reporter:
              amansinha100 Aman Sinha
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: