[jira] [Commented] (IMPALA-10672) Fix non-deterministic RANK queries in tests

["Kurt Deschler (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IMPALA-10672?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17330814#comment-17330814 ] 

Kurt Deschler commented on IMPALA-10672:
----------------------------------------

http://gerrit.cloudera.org:8080/17333

> 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