Kurt Deschler created IMPALA-10672:
--------------------------------------
Summary: 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
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)
