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 "Kurt Deschler (Jira)" <ji...@apache.org> on 2021/04/23 14:29:00 UTC
[jira] [Work started] (IMPALA-10672) Fix non-deterministic RANK
queries in tests
[ https://issues.apache.org/jira/browse/IMPALA-10672?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on IMPALA-10672 started by Kurt Deschler.
----------------------------------------------
> Fix non-deterministic RANK queries in tests
> -------------------------------------------
>
> Key: IMPALA-10672
> URL: https://issues.apache.org/jira/browse/IMPALA-10672
> Project: IMPALA
> Issue Type: Bug
> Components: Infrastructure
> Reporter: Kurt Deschler
> Assignee: Kurt Deschler
> Priority: Minor
>
> The following queries were producing sporadic failures with an external frontend. On inspection, the rank ordering is not strong enough to be deterministic.
>
> functional-query/queries/limit-pushdown-analytic.test
> select tinyint_col, string_col, id, rnk from (
> select *, rank() over (partition by tinyint_col *order by string_col*) rnk
> from alltypestiny) v
> where rnk <= 5
> order by tinyint_col, string_col desc, id desc
> limit 10
> select tinyint_col, string_col, id, rnk from (
> select *, rank() over (partition by tinyint_col *order by string_col*) rnk
> from alltypestiny) v
> where rnk <= 5
> order by tinyint_col, string_col desc, id desc
> limit 5
> Ordering needs to include id
> tpch/queries/limit-pushdown-analytic.test
> select l_orderkey, l_partkey, l_suppkey, l_linenumber, l_shipmode, rnk from (
> select *, rank() over (partition by l_partkey *order by l_shipmode*) rnk
> from lineitem) v
> where rnk <= 50
> order by l_partkey, l_orderkey, l_suppkey, l_linenumber, l_shipmode
> limit 50
> Ordering needs to include l_orderkey and l_linenumber
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org