[
https://issues.apache.org/jira/browse/IMPALA-14158?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Steve Carlin resolved IMPALA-14158.
-----------------------------------
Resolution: Fixed
> Calcite planner: nulls last not being handled correctly for analytical
> function
> -------------------------------------------------------------------------------
>
> Key: IMPALA-14158
> URL: https://issues.apache.org/jira/browse/IMPALA-14158
> Project: IMPALA
> Issue Type: Sub-task
> Reporter: Steve Carlin
> Priority: Major
>
> The following query is putting nulls first in
> analytic-fns-tpcds-partitioned-topn.test
> select *
> from (
> select s_store_name, s_state, ss_list_price,
> rank() over (partition by s_store_name, s_state order by
> ss_list_price desc nulls last) rnk
> from store_sales ss
> join store s on ss_store_sk = s_store_sk) v
> where rnk <= 5;
--
This message was sent by Atlassian Jira
(v8.20.10#820010)