diff options
| author | Alexey Ozeritskiy <aozeritsky@ydb.tech> | 2024-01-31 21:51:17 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-01-31 21:51:17 +0100 |
| commit | 6517468519588014087caca2bc33fc32bb96fdae (patch) | |
| tree | f15a1d05a118060830fc4b3435d0f8af46919d70 | |
| parent | 5e6002c8cb8631a5ad03e3ad2ad34227c509399c (diff) | |
| download | ydb-6517468519588014087caca2bc33fc32bb96fdae.tar.gz | |
Fix tpcds query text (#1482)
| -rw-r--r-- | ydb/library/benchmarks/queries/tpcds/pg/q03.sql | 2 | ||||
| -rw-r--r-- | ydb/library/benchmarks/queries/tpcds/pg/q18.sql | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/ydb/library/benchmarks/queries/tpcds/pg/q03.sql b/ydb/library/benchmarks/queries/tpcds/pg/q03.sql index 5114ec8c2ed..a07969f8535 100644 --- a/ydb/library/benchmarks/queries/tpcds/pg/q03.sql +++ b/ydb/library/benchmarks/queries/tpcds/pg/q03.sql @@ -3,7 +3,7 @@ select dt.d_year ,item.i_brand_id brand_id ,item.i_brand brand - ,sum(ss_ext_sales_price) sum_agg + ,sum(ss_sales_price) sum_agg from {{date_dim}} dt ,{{store_sales}} ,{{item}} diff --git a/ydb/library/benchmarks/queries/tpcds/pg/q18.sql b/ydb/library/benchmarks/queries/tpcds/pg/q18.sql index 3fe31ab04a9..a135f802b38 100644 --- a/ydb/library/benchmarks/queries/tpcds/pg/q18.sql +++ b/ydb/library/benchmarks/queries/tpcds/pg/q18.sql @@ -21,8 +21,8 @@ select i_item_id, cd1.cd_education_status = 'Unknown' and c_current_cdemo_sk = cd2.cd_demo_sk and c_current_addr_sk = ca_address_sk and - c_birth_month in (9,5,12,4,1,10) and - d_year = 2001 and + c_birth_month in (5,1,4,7,8,9) and + d_year = 2002 and ca_state in ('AR','TX','NC' ,'GA','MS','WV','AL') group by rollup (i_item_id, ca_country, ca_state, ca_county) |