[
https://issues.apache.org/jira/browse/DRILL-8137?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17493025#comment-17493025
]
ASF GitHub Bot commented on DRILL-8137:
---------------------------------------
jnturton merged pull request #2462:
URL: https://github.com/apache/drill/pull/2462
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
> Prevent reading union inputs after cancellation request
> -------------------------------------------------------
>
> Key: DRILL-8137
> URL: https://issues.apache.org/jira/browse/DRILL-8137
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.19.0
> Reporter: Vova Vysotskyi
> Assignee: Vova Vysotskyi
> Priority: Critical
>
> When running a union all query that has right side operators like join or
> aggregate, and limit on top of the union, such query will fail for the case
> when right input shouldn't read because the left one had required number of
> records for limit.
> Example of such failing query (thanks to [~dzamo] for helping to minimize it):
> {code:sql}
> WITH foo AS
> (SELECT 1 AS a
> FROM cp.`/tpch/nation.parquet`
> UNION ALL SELECT 1 AS a
> FROM cp.`/tpch/nation.parquet`
> WHERE n_nationkey >
> (SELECT 1) )
> SELECT *
> FROM foo
> LIMIT 1
> {code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
