[
https://issues.apache.org/jira/browse/DRILL-1846?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Aman Sinha updated DRILL-1846:
------------------------------
Attachment: 0001-DRILL-1846-Use-max-receiver-width-during-stats-colle.patch
Uploaded patch for this. Added an interface method for exchanges to determine
the maximum receiver width and used this during stats collection for
determining fragment parallelism. SingleMergeExchange and UnionExchange return
a value of 1 while others use default of Integer.MAX_VALUE. [~jnadeau] could
you pls review ?
> Re-ordering output of a subquery on a different column causes error
> -------------------------------------------------------------------
>
> Key: DRILL-1846
> URL: https://issues.apache.org/jira/browse/DRILL-1846
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Aman Sinha
> Assignee: Aman Sinha
> Attachments:
> 0001-DRILL-1846-Use-max-receiver-width-during-stats-colle.patch
>
>
> 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:
> {code}
> 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
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
