[IMPALA-10672] Fix non-deterministic RANK queries in tests

• Type: Bug
• Status: In Progress
• Priority: Minor
• Resolution: Unresolved
• Component/s: Infrastructure
• Epic Color: ghx-label-11
• Assignee: Kurt Deschler
• Reporter: Kurt Deschler
• Created: 23/Apr/21 13:34
• Updated: 23/Apr/21 14:28

Description

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