You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Tim Armstrong (Jira)" <ji...@apache.org> on 2020/12/28 06:54:00 UTC
[jira] [Resolved] (IMPALA-2092) Query generator creates
non-deterministic analytic queries
[ https://issues.apache.org/jira/browse/IMPALA-2092?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong resolved IMPALA-2092.
-----------------------------------
Resolution: Cannot Reproduce
> Query generator creates non-deterministic analytic queries
> ----------------------------------------------------------
>
> Key: IMPALA-2092
> URL: https://issues.apache.org/jira/browse/IMPALA-2092
> Project: IMPALA
> Issue Type: Bug
> Components: Infrastructure
> Affects Versions: Impala 2.3.0
> Reporter: Taras Bobrovytsky
> Priority: Major
> Labels: query_generator_development
>
> Impala Query:
> {code}
> SELECT
> LAG('644', 66) OVER (ORDER BY string_col ASC, tinyint_col) AS char_col,
> LAG(COALESCE(306, -86, -391), 77) OVER (ORDER BY month ASC, smallint_col DESC) AS int_col
> FROM alltypesagg
> order by char_col desc, int_col desc
> limit 15;
> {code}
> Equivalent Postgres Query:
> {code}
> SELECT
> LAG('644' || '', 66) OVER (ORDER BY CAST(string_col AS BYTEA) ASC, tinyint_col) AS char_col,
> LAG(COALESCE(306, -86, -391), 77) OVER (ORDER BY month ASC, smallint_col DESC) AS int_col
> FROM alltypesagg
> order by char_col desc, int_col desc
> limit 15;
> {code}
> Impala Result:
> {code}
> +----------+---------+
> | char_col | int_col |
> +----------+---------+
> | NULL | NULL |
> | NULL | NULL |
> | NULL | NULL |
> | NULL | NULL |
> | NULL | NULL |
> | NULL | NULL |
> | NULL | NULL |
> | NULL | NULL |
> | NULL | NULL |
> | NULL | NULL |
> | NULL | NULL |
> | NULL | NULL |
> | NULL | NULL |
> | NULL | 306 |
> | NULL | 306 |
> +----------+---------+
> Fetched 15 row(s) in 0.84s
> {code}
> Postgres Result:
> {code}
> char_col | int_col
> ----------+---------
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> |
> | 306
> | 306
> | 306
> (15 rows)
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)