You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "ZhuMinghui (Jira)" <ji...@apache.org> on 2023/06/08 02:17:00 UTC
[jira] [Resolved] (IMPALA-12051) Propagate analytic tuple predicates of outer-joined InlineView
[ https://issues.apache.org/jira/browse/IMPALA-12051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ZhuMinghui resolved IMPALA-12051.
---------------------------------
Resolution: Fixed
> Propagate analytic tuple predicates of outer-joined InlineView
> --------------------------------------------------------------
>
> Key: IMPALA-12051
> URL: https://issues.apache.org/jira/browse/IMPALA-12051
> Project: IMPALA
> Issue Type: Bug
> Reporter: ZhuMinghui
> Assignee: ZhuMinghui
> Priority: Major
> Attachments: image-2023-04-07-11-57-13-571.png, image-2023-04-07-11-57-59-883.png
>
>
> In some cases, direct pushing down predicates that reference analytic tuple into inline view leads to incorrect query results. such as sql:
> {code:java}
> WITH detail_measure AS (
> SELECT
> *
> FROM
> (
> VALUES
> (
> 1 AS `isqbiuar`,
> 1 AS `bgsfrbun`,
> 1 AS `result_type`,
> 1 AS `bjuzzevg`
> ),
> (2, 2, 2, 2)
> ) a
> ),
> order_measure_sql0 AS (
> SELECT
> row_number() OVER (
> ORDER BY
> row_number_0 DESC NULLS LAST,
> isqbiuar ASC NULLS LAST
> ) AS `row_number_0`,
> `isqbiuar`
> FROM
> (
> VALUES
> (1 AS `row_number_0`, 1 AS `isqbiuar`),
> (2, 2)
> ) b
> )
> SELECT
> detail_measure.`isqbiuar` AS `isqbiuar`,
> detail_measure.`bgsfrbun` AS `bgsfrbun`,
> detail_measure.`result_type` AS `result_type`,
> detail_measure.`bjuzzevg` AS `bjuzzevg`,
> `row_number_0` AS `row_number_0`
> FROM
> detail_measure
> LEFT JOIN order_measure_sql0 ON order_measure_sql0.isqbiuar = detail_measure.isqbiuar
> WHERE
> row_number_0 BETWEEN 1
> AND 1
> ORDER BY
> `row_number_0` ASC NULLS LAST,
> `bgsfrbun` ASC NULLS LAST{code}
> The current query result is:
> !image-2023-04-07-11-57-13-571.png!
> The correct query result is:
> !image-2023-04-07-11-57-59-883.png!
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org