diff options
| author | Олег <[email protected]> | 2025-04-09 13:26:15 +0300 |
|---|---|---|
| committer | GitHub <[email protected]> | 2025-04-09 10:26:15 +0000 |
| commit | b4a15ad406e0bd7ff34461ef71216f0155a81a24 (patch) | |
| tree | 6d340ce6c6fba342daffea0b597155b89ddd911c | |
| parent | 4089bad606c857a668fa63bbb3a426274b0d3fb5 (diff) | |
Tpcds q73 order by ss ticket number (#16977)
| -rw-r--r-- | ydb/library/benchmarks/queries/tpcds/pg/q73.sql | 2 | ||||
| -rw-r--r-- | ydb/library/benchmarks/queries/tpcds/yql/q73.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/ydb/library/benchmarks/queries/tpcds/pg/q73.sql b/ydb/library/benchmarks/queries/tpcds/pg/q73.sql index 7c5223c6a3e..edfd6c029c3 100644 --- a/ydb/library/benchmarks/queries/tpcds/pg/q73.sql +++ b/ydb/library/benchmarks/queries/tpcds/pg/q73.sql @@ -24,6 +24,6 @@ select c_last_name group by ss_ticket_number,ss_customer_sk) dj,{{customer}} where ss_customer_sk = c_customer_sk and cnt between 1::int8 and 5::int8 - order by cnt desc, c_last_name asc; + order by cnt desc, c_last_name asc, ss_ticket_number asc; -- end query 1 in stream 0 using template ../query_templates/query73.tpl diff --git a/ydb/library/benchmarks/queries/tpcds/yql/q73.sql b/ydb/library/benchmarks/queries/tpcds/yql/q73.sql index 38ec16b2413..bd9a142449b 100644 --- a/ydb/library/benchmarks/queries/tpcds/yql/q73.sql +++ b/ydb/library/benchmarks/queries/tpcds/yql/q73.sql @@ -28,6 +28,6 @@ select c_last_name group by store_sales.ss_ticket_number,store_sales.ss_customer_sk) dj cross join {{customer}} as customer where ss_customer_sk = c_customer_sk and cnt between 1 and 5 - order by cnt desc, c_last_name asc; + order by cnt desc, c_last_name asc, ss_ticket_number asc; -- end query 1 in stream 0 using template query73.tpl |