This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
commit 9c15a857d3a557e63c72af3c11c5115ee5cc82fa
Author: xzj7019 <131111794+xzj7...@users.noreply.github.com>
AuthorDate: Mon May 27 21:55:16 2024 +0800
[fix](tools) update tools cases #35467
Remove useless filter of tpcds sf1000 query78
---
tools/tpcds-tools/queries/sf1/query78.sql | 2 +-
tools/tpcds-tools/queries/sf100/query78.sql | 2 +-
tools/tpcds-tools/queries/sf1000/query78.sql | 6 +++---
tools/tpcds-tools/queries/sf10000/query78.sql | 2 +-
4 files changed, 6 insertions(+), 6 deletions(-)
diff --git a/tools/tpcds-tools/queries/sf1/query78.sql
b/tools/tpcds-tools/queries/sf1/query78.sql
index 9a827172b0f..0d4d04ce41f 100644
--- a/tools/tpcds-tools/queries/sf1/query78.sql
+++ b/tools/tpcds-tools/queries/sf1/query78.sql
@@ -34,7 +34,7 @@ ss as
where sr_ticket_number is null
group by d_year, ss_item_sk, ss_customer_sk
)
- select
+select
ss_customer_sk,
round(ss_qty/(coalesce(ws_qty,0)+coalesce(cs_qty,0)),2) ratio,
ss_qty store_qty, ss_wc store_wholesale_cost, ss_sp store_sales_price,
diff --git a/tools/tpcds-tools/queries/sf100/query78.sql
b/tools/tpcds-tools/queries/sf100/query78.sql
index 182f13c726e..684e2a7e54d 100644
--- a/tools/tpcds-tools/queries/sf100/query78.sql
+++ b/tools/tpcds-tools/queries/sf100/query78.sql
@@ -34,7 +34,7 @@ ss as
where sr_ticket_number is null
group by d_year, ss_item_sk, ss_customer_sk
)
- select
+select
ss_item_sk,
round(ss_qty/(coalesce(ws_qty,0)+coalesce(cs_qty,0)),2) ratio,
ss_qty store_qty, ss_wc store_wholesale_cost, ss_sp store_sales_price,
diff --git a/tools/tpcds-tools/queries/sf1000/query78.sql
b/tools/tpcds-tools/queries/sf1000/query78.sql
index 62dca42e44e..0d4d04ce41f 100644
--- a/tools/tpcds-tools/queries/sf1000/query78.sql
+++ b/tools/tpcds-tools/queries/sf1000/query78.sql
@@ -7,7 +7,7 @@ with ws as
from web_sales
left join web_returns on wr_order_number=ws_order_number and
ws_item_sk=wr_item_sk
join date_dim on ws_sold_date_sk = d_date_sk
- where wr_order_number is null and d_year=1998
+ where wr_order_number is null
group by d_year, ws_item_sk, ws_bill_customer_sk
),
cs as
@@ -19,7 +19,7 @@ cs as
from catalog_sales
left join catalog_returns on cr_order_number=cs_order_number and
cs_item_sk=cr_item_sk
join date_dim on cs_sold_date_sk = d_date_sk
- where cr_order_number is null and d_year=1998
+ where cr_order_number is null
group by d_year, cs_item_sk, cs_bill_customer_sk
),
ss as
@@ -31,7 +31,7 @@ ss as
from store_sales
left join store_returns on sr_ticket_number=ss_ticket_number and
ss_item_sk=sr_item_sk
join date_dim on ss_sold_date_sk = d_date_sk
- where sr_ticket_number is null and d_year=1998
+ where sr_ticket_number is null
group by d_year, ss_item_sk, ss_customer_sk
)
select
diff --git a/tools/tpcds-tools/queries/sf10000/query78.sql
b/tools/tpcds-tools/queries/sf10000/query78.sql
index 1c34f237f09..53543ec8cc4 100644
--- a/tools/tpcds-tools/queries/sf10000/query78.sql
+++ b/tools/tpcds-tools/queries/sf10000/query78.sql
@@ -34,7 +34,7 @@ ss as
where sr_ticket_number is null
group by d_year, ss_item_sk, ss_customer_sk
)
- select
+select
ss_customer_sk,
round(ss_qty/(coalesce(ws_qty,0)+coalesce(cs_qty,0)),2) ratio,
ss_qty store_qty, ss_wc store_wholesale_cost, ss_sp store_sales_price,
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
