Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
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