diff options
| author | Олег <[email protected]> | 2025-02-17 18:31:10 +0300 |
|---|---|---|
| committer | GitHub <[email protected]> | 2025-02-17 15:31:10 +0000 |
| commit | de939b687dddf6116a291a37feb4e445138a980a (patch) | |
| tree | 4591da3434ddf9068b0f201dd364903523901a6f | |
| parent | f3e40ce482e36213ae2d4da6b93d40f951aab69c (diff) | |
Make tpcds q44 more deteminated (#14665)
| -rw-r--r-- | ydb/library/benchmarks/queries/tpcds/yql/q44.sql | 4 |
1 files 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 |