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/04/07 03:57:00 UTC
[jira] [Updated] (IMPALA-12051) In some cases, direct pushing down predicates that reference analytic tuple into inline view leads to incorrect query results
[ https://issues.apache.org/jira/browse/IMPALA-12051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ZhuMinghui updated IMPALA-12051:
--------------------------------
Description:
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`,
NULL AS `total_num`
),
(2, 2, 2, 2, NULL)
) 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`,
detail_measure.`total_num` AS `total_num`,
`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:
> In some cases, direct pushing down predicates that reference analytic tuple into inline view leads to incorrect query results
> -----------------------------------------------------------------------------------------------------------------------------
>
> Key: IMPALA-12051
> URL: https://issues.apache.org/jira/browse/IMPALA-12051
> Project: IMPALA
> Issue Type: Bug
> Reporter: ZhuMinghui
> Assignee: ZhuMinghui
> Priority: Major
>
> 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`,
> NULL AS `total_num`
> ),
> (2, 2, 2, 2, NULL)
> ) 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`,
> detail_measure.`total_num` AS `total_num`,
> `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:
>
--
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