You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by mo...@apache.org on 2023/04/28 11:46:20 UTC
[doris] 03/03: [enhancement](test) split large data of p2 cases (#19186)
This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch branch-2.0-alpha
in repository https://gitbox.apache.org/repos/asf/doris.git
commit e341114166ec9f1d7e3998ef9d35e9563e17698b
Author: zgxme <u1...@qq.com>
AuthorDate: Fri Apr 28 18:18:25 2023 +0800
[enhancement](test) split large data of p2 cases (#19186)
---
regression-test/suites/tpcds_sf100_p2/ddl/catalog_sales_load.sql | 2 +-
regression-test/suites/tpcds_sf100_p2/ddl/store_sales_load.sql | 2 +-
regression-test/suites/tpch_sf100_p2/ddl/lineitem_load.sql | 2 +-
regression-test/suites/tpch_sf100_unique_p2/ddl/lineitem_load.sql | 2 +-
.../suites/tpch_sf100_unique_p2/ddl/lineitem_load_sequence.sql | 2 +-
regression-test/suites/tpch_sf100_unique_sql_p2/ddl/lineitem_load.sql | 2 +-
6 files changed, 6 insertions(+), 6 deletions(-)
diff --git a/regression-test/suites/tpcds_sf100_p2/ddl/catalog_sales_load.sql b/regression-test/suites/tpcds_sf100_p2/ddl/catalog_sales_load.sql
index e4dadaf5fc..23fbbc1cfc 100644
--- a/regression-test/suites/tpcds_sf100_p2/ddl/catalog_sales_load.sql
+++ b/regression-test/suites/tpcds_sf100_p2/ddl/catalog_sales_load.sql
@@ -1,5 +1,5 @@
LOAD LABEL ${loadLabel} (
- DATA INFILE("s3://${s3BucketName}/regression/tpcds/sf100/catalog_sales.dat.gz")
+ DATA INFILE("s3://${s3BucketName}/regression/tpcds/sf100_split/catalog_sales.dat.*.gz")
INTO TABLE catalog_sales
COLUMNS TERMINATED BY "|"
(cs_sold_date_sk, cs_sold_time_sk, cs_ship_date_sk, cs_bill_customer_sk, cs_bill_cdemo_sk, cs_bill_hdemo_sk, cs_bill_addr_sk, cs_ship_customer_sk, cs_ship_cdemo_sk, cs_ship_hdemo_sk, cs_ship_addr_sk, cs_call_center_sk, cs_catalog_page_sk, cs_ship_mode_sk, cs_warehouse_sk, cs_item_sk, cs_promo_sk, cs_order_number, cs_quantity, cs_wholesale_cost, cs_list_price, cs_sales_price, cs_ext_discount_amt, cs_ext_sales_price, cs_ext_wholesale_cost, cs_ext_list_price, cs_ext_tax, cs_coupon_amt, [...]
diff --git a/regression-test/suites/tpcds_sf100_p2/ddl/store_sales_load.sql b/regression-test/suites/tpcds_sf100_p2/ddl/store_sales_load.sql
index 099efa2763..d9ab553885 100644
--- a/regression-test/suites/tpcds_sf100_p2/ddl/store_sales_load.sql
+++ b/regression-test/suites/tpcds_sf100_p2/ddl/store_sales_load.sql
@@ -1,5 +1,5 @@
LOAD LABEL ${loadLabel} (
- DATA INFILE("s3://${s3BucketName}/regression/tpcds/sf100/store_sales.dat.gz")
+ DATA INFILE("s3://${s3BucketName}/regression/tpcds/sf100_split/store_sales.dat.*.gz")
INTO TABLE store_sales
COLUMNS TERMINATED BY "|"
(ss_sold_date_sk, ss_sold_time_sk, ss_item_sk, ss_customer_sk, ss_cdemo_sk, ss_hdemo_sk, ss_addr_sk, ss_store_sk, ss_promo_sk, ss_ticket_number, ss_quantity, ss_wholesale_cost, ss_list_price, ss_sales_price, ss_ext_discount_amt, ss_ext_sales_price, ss_ext_wholesale_cost, ss_ext_list_price, ss_ext_tax, ss_coupon_amt, ss_net_paid, ss_net_paid_inc_tax, ss_net_profit)
diff --git a/regression-test/suites/tpch_sf100_p2/ddl/lineitem_load.sql b/regression-test/suites/tpch_sf100_p2/ddl/lineitem_load.sql
index 11ccc204fe..d17e84ff4b 100644
--- a/regression-test/suites/tpch_sf100_p2/ddl/lineitem_load.sql
+++ b/regression-test/suites/tpch_sf100_p2/ddl/lineitem_load.sql
@@ -1,5 +1,5 @@
LOAD LABEL ${loadLabel} (
- DATA INFILE("s3://${s3BucketName}/regression/tpch/sf100/lineitem.tbl.*")
+ DATA INFILE("s3://${s3BucketName}/regression/tpch/sf100_split/lineitem.tbl.*")
INTO TABLE lineitem
COLUMNS TERMINATED BY "|"
(l_orderkey, l_partkey, l_suppkey, l_linenumber, l_quantity, l_extendedprice, l_discount, l_tax, l_returnflag, l_linestatus, l_shipdate, l_commitdate, l_receiptdate, l_shipinstruct, l_shipmode, l_comment, temp)
diff --git a/regression-test/suites/tpch_sf100_unique_p2/ddl/lineitem_load.sql b/regression-test/suites/tpch_sf100_unique_p2/ddl/lineitem_load.sql
index 7f1050c5dc..b0da953829 100644
--- a/regression-test/suites/tpch_sf100_unique_p2/ddl/lineitem_load.sql
+++ b/regression-test/suites/tpch_sf100_unique_p2/ddl/lineitem_load.sql
@@ -1,5 +1,5 @@
LOAD LABEL ${loadLabel} (
- DATA INFILE("s3://${s3BucketName}/regression/tpch/sf100/lineitem.tbl.*")
+ DATA INFILE("s3://${s3BucketName}/regression/tpch/sf100_split/lineitem.tbl.*")
INTO TABLE lineitem
COLUMNS TERMINATED BY "|"
(l_orderkey, l_partkey, l_suppkey, l_linenumber, l_quantity, l_extendedprice, l_discount, l_tax, l_returnflag,l_linestatus, l_shipdate,l_commitdate,l_receiptdate,l_shipinstruct,l_shipmode,l_comment,temp)
diff --git a/regression-test/suites/tpch_sf100_unique_p2/ddl/lineitem_load_sequence.sql b/regression-test/suites/tpch_sf100_unique_p2/ddl/lineitem_load_sequence.sql
index 4c0c304a34..bfcfac6f38 100644
--- a/regression-test/suites/tpch_sf100_unique_p2/ddl/lineitem_load_sequence.sql
+++ b/regression-test/suites/tpch_sf100_unique_p2/ddl/lineitem_load_sequence.sql
@@ -1,5 +1,5 @@
LOAD LABEL ${loadLabel} (
- DATA INFILE("s3://${s3BucketName}/regression/tpch/sf100/lineitem.tbl.*")
+ DATA INFILE("s3://${s3BucketName}/regression/tpch/sf100_split/lineitem.tbl.*")
INTO TABLE lineitem
COLUMNS TERMINATED BY "|"
(l_orderkey, l_partkey, l_suppkey, l_linenumber, l_quantity, l_extendedprice, l_discount, l_tax, l_returnflag,l_linestatus, l_shipdate,l_commitdate,l_receiptdate,l_shipinstruct,l_shipmode,l_comment,temp)
diff --git a/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/lineitem_load.sql b/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/lineitem_load.sql
index 7f1050c5dc..b0da953829 100644
--- a/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/lineitem_load.sql
+++ b/regression-test/suites/tpch_sf100_unique_sql_p2/ddl/lineitem_load.sql
@@ -1,5 +1,5 @@
LOAD LABEL ${loadLabel} (
- DATA INFILE("s3://${s3BucketName}/regression/tpch/sf100/lineitem.tbl.*")
+ DATA INFILE("s3://${s3BucketName}/regression/tpch/sf100_split/lineitem.tbl.*")
INTO TABLE lineitem
COLUMNS TERMINATED BY "|"
(l_orderkey, l_partkey, l_suppkey, l_linenumber, l_quantity, l_extendedprice, l_discount, l_tax, l_returnflag,l_linestatus, l_shipdate,l_commitdate,l_receiptdate,l_shipinstruct,l_shipmode,l_comment,temp)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org