From de939b687dddf6116a291a37feb4e445138a980a Mon Sep 17 00:00:00 2001 From: Олег <150132506+iddqdex@users.noreply.github.com> Date: Mon, 17 Feb 2025 18:31:10 +0300 Subject: Make tpcds q44 more deteminated (#14665) --- ydb/library/benchmarks/queries/tpcds/yql/q44.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/ydb/library/benchmarks/queries/tpcds/yql/q44.sql b/ydb/library/benchmarks/queries/tpcds/yql/q44.sql index 12572832203..74d6925111c 100644 --- a/ydb/library/benchmarks/queries/tpcds/yql/q44.sql +++ b/ydb/library/benchmarks/queries/tpcds/yql/q44.sql @@ -11,7 +11,7 @@ $avg_net_profit = (select avg(ss_net_profit) rank_col select asceding.rnk, i1.i_product_name best_performing, i2.i_product_name worst_performing from(select * from (select item_sk,rank() over (order by rank_col asc) rnk - from (select ss_item_sk item_sk,avg(ss_net_profit) rank_col + from (select ss_item_sk item_sk,$round(avg(ss_net_profit), -2) rank_col from {{store_sales}} ss1 where ss_store_sk = 4 group by ss_item_sk @@ -20,7 +20,7 @@ from(select * cross join (select * from (select item_sk,rank() over (order by rank_col desc) rnk - from (select ss_item_sk item_sk,avg(ss_net_profit) rank_col + from (select ss_item_sk item_sk,$round(avg(ss_net_profit), -2) rank_col from {{store_sales}} ss1 where ss_store_sk = 4 group by ss_item_sk -- cgit v1.3