[DRILL-1846] Re-ordering output of a subquery on a different column causes error

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.7.0
• Assignee: Aman Sinha
• Reporter: Aman Sinha
• Created: 11/Dec/14 23:47
• Updated: 14/Dec/14 06:36
• Resolved: 14/Dec/14 06:36

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