This is an automated email from the ASF dual-hosted git repository.
englefly pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 3ec52dc7da [tpch](nereids) add regression test for tpch_sf500 plan
shape #18631
3ec52dc7da is described below
commit 3ec52dc7da3fb12401afa468fcc833702d75ee48
Author: minghong <[email protected]>
AuthorDate: Sun Apr 16 11:37:33 2023 +0800
[tpch](nereids) add regression test for tpch_sf500 plan shape #18631
add regression test to check tpch_sf500 plan shape by explain shape plan.
---
.../shape/q1.out | 0
.../shape/q10.out | 0
.../shape/q11.out | 0
.../shape/q12.out | 0
.../shape/q13.out | 0
.../shape/q14.out | 0
.../shape/q15.out | 0
.../shape/q16.out | 0
.../shape/q17.out | 0
.../shape/q18.out | 0
.../shape/q19.out | 0
.../shape/q2.out | 0
.../shape/q20.out | 0
.../shape/q21.out | 0
.../shape/q22.out | 0
.../shape/q3.out | 0
.../shape/q4.out | 0
.../shape/q5.out | 0
.../shape/q6.out | 0
.../shape/q7.out | 0
.../shape/q8.out | 0
.../shape/q9.out | 0
.../shape/q1.out | 0
.../shape/q10.out | 0
.../shape/q11.out | 0
.../shape/q12.out | 0
.../shape/q13.out | 0
.../shape/q14.out | 0
.../shape/q15.out | 0
.../shape/q16.out | 0
.../shape/q17.out | 0
.../shape/q18.out | 0
.../data/nereids_tpch_shape_sf500_p0/shape/q19.out | 15 +++
.../shape/q2.out | 0
.../shape/q20.out | 0
.../shape/q21.out | 0
.../shape/q22.out | 0
.../shape/q3.out | 0
.../shape/q4.out | 0
.../data/nereids_tpch_shape_sf500_p0/shape/q5.out | 35 +++++++
.../shape/q6.out | 0
.../shape/q7.out | 0
.../shape/q8.out | 0
.../data/nereids_tpch_shape_sf500_p0/shape/q9.out | 35 +++++++
.../load.groovy | 0
.../shape/q1.groovy | 0
.../shape/q10.groovy | 0
.../shape/q11.groovy | 0
.../shape/q12.groovy | 0
.../shape/q13.groovy | 0
.../shape/q14.groovy | 0
.../shape/q15.groovy | 0
.../shape/q16.groovy | 0
.../shape/q17.groovy | 0
.../shape/q18.groovy | 0
.../shape/q19.groovy | 0
.../shape/q2.groovy | 0
.../shape/q20.groovy | 0
.../shape/q21.groovy | 0
.../shape/q22.groovy | 0
.../shape/q3.groovy | 0
.../shape/q4.groovy | 0
.../shape/q5.groovy | 0
.../shape/q6.groovy | 0
.../shape/q7.groovy | 0
.../shape/q8.groovy | 0
.../shape/q9.groovy | 0
.../load.groovy | 108 ++++++++++-----------
.../shape/q1.groovy | 0
.../shape/q10.groovy | 5 +-
.../shape/q11.groovy | 5 +-
.../shape/q12.groovy | 5 +-
.../shape/q13.groovy | 4 +
.../shape/q14.groovy | 5 +-
.../shape/q15.groovy | 5 +-
.../shape/q16.groovy | 5 +-
.../shape/q17.groovy | 5 +-
.../shape/q18.groovy | 5 +-
.../shape/q19.groovy | 5 +-
.../shape/q2.groovy | 3 +
.../shape/q20.groovy | 5 +-
.../shape/q21.groovy | 5 +-
.../shape/q22.groovy | 5 +-
.../shape/q3.groovy | 5 +-
.../shape/q4.groovy | 5 +-
.../shape/q5.groovy | 5 +-
.../shape/q6.groovy | 5 +-
.../shape/q7.groovy | 5 +-
.../shape/q8.groovy | 5 +-
.../shape/q9.groovy | 3 +
90 files changed, 221 insertions(+), 72 deletions(-)
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q1.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q1.out
similarity index 100%
copy from regression-test/data/nereids_tpchPlanShape_p0/shape/q1.out
copy to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q1.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q10.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q10.out
similarity index 100%
copy from regression-test/data/nereids_tpchPlanShape_p0/shape/q10.out
copy to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q10.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q11.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q11.out
similarity index 100%
copy from regression-test/data/nereids_tpchPlanShape_p0/shape/q11.out
copy to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q11.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q12.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q12.out
similarity index 100%
copy from regression-test/data/nereids_tpchPlanShape_p0/shape/q12.out
copy to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q12.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q13.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q13.out
similarity index 100%
copy from regression-test/data/nereids_tpchPlanShape_p0/shape/q13.out
copy to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q13.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q14.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q14.out
similarity index 100%
copy from regression-test/data/nereids_tpchPlanShape_p0/shape/q14.out
copy to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q14.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q15.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q15.out
similarity index 100%
copy from regression-test/data/nereids_tpchPlanShape_p0/shape/q15.out
copy to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q15.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q16.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q16.out
similarity index 100%
copy from regression-test/data/nereids_tpchPlanShape_p0/shape/q16.out
copy to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q16.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q17.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q17.out
similarity index 100%
copy from regression-test/data/nereids_tpchPlanShape_p0/shape/q17.out
copy to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q17.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q18.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q18.out
similarity index 100%
copy from regression-test/data/nereids_tpchPlanShape_p0/shape/q18.out
copy to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q18.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q19.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q19.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q19.out
rename to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q19.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q2.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q2.out
similarity index 100%
copy from regression-test/data/nereids_tpchPlanShape_p0/shape/q2.out
copy to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q2.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q20.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q20.out
similarity index 100%
copy from regression-test/data/nereids_tpchPlanShape_p0/shape/q20.out
copy to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q20.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q21.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q21.out
similarity index 100%
copy from regression-test/data/nereids_tpchPlanShape_p0/shape/q21.out
copy to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q21.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q22.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q22.out
similarity index 100%
copy from regression-test/data/nereids_tpchPlanShape_p0/shape/q22.out
copy to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q22.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q3.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q3.out
similarity index 100%
copy from regression-test/data/nereids_tpchPlanShape_p0/shape/q3.out
copy to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q3.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q4.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q4.out
similarity index 100%
copy from regression-test/data/nereids_tpchPlanShape_p0/shape/q4.out
copy to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q4.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q5.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q5.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q5.out
rename to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q5.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q6.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q6.out
similarity index 100%
copy from regression-test/data/nereids_tpchPlanShape_p0/shape/q6.out
copy to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q6.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q7.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q7.out
similarity index 100%
copy from regression-test/data/nereids_tpchPlanShape_p0/shape/q7.out
copy to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q7.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q8.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q8.out
similarity index 100%
copy from regression-test/data/nereids_tpchPlanShape_p0/shape/q8.out
copy to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q8.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q9.out
b/regression-test/data/nereids_tpch_shape_sf1_p0/shape/q9.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q9.out
rename to regression-test/data/nereids_tpch_shape_sf1_p0/shape/q9.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q1.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q1.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q1.out
rename to regression-test/data/nereids_tpch_shape_sf500_p0/shape/q1.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q10.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q10.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q10.out
rename to regression-test/data/nereids_tpch_shape_sf500_p0/shape/q10.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q11.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q11.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q11.out
rename to regression-test/data/nereids_tpch_shape_sf500_p0/shape/q11.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q12.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q12.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q12.out
rename to regression-test/data/nereids_tpch_shape_sf500_p0/shape/q12.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q13.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q13.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q13.out
rename to regression-test/data/nereids_tpch_shape_sf500_p0/shape/q13.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q14.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q14.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q14.out
rename to regression-test/data/nereids_tpch_shape_sf500_p0/shape/q14.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q15.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q15.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q15.out
rename to regression-test/data/nereids_tpch_shape_sf500_p0/shape/q15.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q16.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q16.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q16.out
rename to regression-test/data/nereids_tpch_shape_sf500_p0/shape/q16.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q17.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q17.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q17.out
rename to regression-test/data/nereids_tpch_shape_sf500_p0/shape/q17.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q18.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q18.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q18.out
rename to regression-test/data/nereids_tpch_shape_sf500_p0/shape/q18.out
diff --git a/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q19.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q19.out
new file mode 100644
index 0000000000..1b877ad328
--- /dev/null
+++ b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q19.out
@@ -0,0 +1,15 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !select --
+hashAgg[GLOBAL]
+--PhysicalDistribute
+----hashAgg[LOCAL]
+------PhysicalProject
+--------hashJoin[INNER_JOIN](part.p_partkey =
lineitem.l_partkey)((((((part.p_brand = 'Brand#12') AND p_container IN ('SM
CASE', 'SM BOX', 'SM PACK', 'SM PKG')) AND ((lineitem.l_quantity >= 1.00) AND
(lineitem.l_quantity <= 11.00))) AND (part.p_size <= 5)) OR ((((part.p_brand =
'Brand#23') AND p_container IN ('MED BAG', 'MED BOX', 'MED PKG', 'MED PACK'))
AND ((lineitem.l_quantity >= 10.00) AND (lineitem.l_quantity <= 20.00))) AND
(part.p_size <= 10))) OR ((((part.p_brand = 'Brand#34') AN [...]
+----------PhysicalProject
+------------filter((lineitem.l_shipinstruct = 'DELIVER IN
PERSON')((((lineitem.l_quantity >= 1.00) AND (lineitem.l_quantity <= 11.00)) OR
((lineitem.l_quantity >= 10.00) AND (lineitem.l_quantity <= 20.00))) OR
((lineitem.l_quantity >= 20.00) AND (lineitem.l_quantity <=
30.00)))((lineitem.l_shipmode = 'AIR') OR (lineitem.l_shipmode = 'AIR REG')))
+--------------PhysicalOlapScan[lineitem]
+----------PhysicalDistribute
+------------PhysicalProject
+--------------filter((((((part.p_brand = 'Brand#12') AND p_container IN ('SM
CASE', 'SM BOX', 'SM PACK', 'SM PKG')) AND (part.p_size <= 5)) OR
(((part.p_brand = 'Brand#23') AND p_container IN ('MED BAG', 'MED BOX', 'MED
PKG', 'MED PACK')) AND (part.p_size <= 10))) OR (((part.p_brand = 'Brand#34')
AND p_container IN ('LG CASE', 'LG BOX', 'LG PACK', 'LG PKG')) AND (part.p_size
<= 15)))(part.p_size >= 1))
+----------------PhysicalOlapScan[part]
+
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q2.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q2.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q2.out
rename to regression-test/data/nereids_tpch_shape_sf500_p0/shape/q2.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q20.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q20.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q20.out
rename to regression-test/data/nereids_tpch_shape_sf500_p0/shape/q20.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q21.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q21.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q21.out
rename to regression-test/data/nereids_tpch_shape_sf500_p0/shape/q21.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q22.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q22.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q22.out
rename to regression-test/data/nereids_tpch_shape_sf500_p0/shape/q22.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q3.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q3.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q3.out
rename to regression-test/data/nereids_tpch_shape_sf500_p0/shape/q3.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q4.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q4.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q4.out
rename to regression-test/data/nereids_tpch_shape_sf500_p0/shape/q4.out
diff --git a/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q5.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q5.out
new file mode 100644
index 0000000000..e7bd14a143
--- /dev/null
+++ b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q5.out
@@ -0,0 +1,35 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !select --
+PhysicalQuickSort
+--PhysicalDistribute
+----PhysicalQuickSort
+------hashAgg[GLOBAL]
+--------PhysicalDistribute
+----------hashAgg[LOCAL]
+------------PhysicalProject
+--------------hashJoin[INNER_JOIN](customer.c_nationkey =
supplier.s_nationkey)(customer.c_custkey = orders.o_custkey)
+----------------PhysicalDistribute
+------------------PhysicalProject
+--------------------hashJoin[INNER_JOIN](lineitem.l_suppkey =
supplier.s_suppkey)
+----------------------hashJoin[INNER_JOIN](lineitem.l_orderkey =
orders.o_orderkey)
+------------------------PhysicalProject
+--------------------------PhysicalOlapScan[lineitem]
+------------------------PhysicalProject
+--------------------------filter((orders.o_orderdate <
1995-01-01)(orders.o_orderdate >= 1994-01-01))
+----------------------------PhysicalOlapScan[orders]
+----------------------PhysicalDistribute
+------------------------PhysicalProject
+--------------------------hashJoin[INNER_JOIN](supplier.s_nationkey =
nation.n_nationkey)
+----------------------------PhysicalProject
+------------------------------PhysicalOlapScan[supplier]
+----------------------------PhysicalDistribute
+------------------------------hashJoin[INNER_JOIN](nation.n_regionkey =
region.r_regionkey)
+--------------------------------PhysicalProject
+----------------------------------PhysicalOlapScan[nation]
+--------------------------------PhysicalDistribute
+----------------------------------PhysicalProject
+------------------------------------filter((region.r_name = 'ASIA'))
+--------------------------------------PhysicalOlapScan[region]
+----------------PhysicalProject
+------------------PhysicalOlapScan[customer]
+
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q6.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q6.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q6.out
rename to regression-test/data/nereids_tpch_shape_sf500_p0/shape/q6.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q7.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q7.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q7.out
rename to regression-test/data/nereids_tpch_shape_sf500_p0/shape/q7.out
diff --git a/regression-test/data/nereids_tpchPlanShape_p0/shape/q8.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q8.out
similarity index 100%
rename from regression-test/data/nereids_tpchPlanShape_p0/shape/q8.out
rename to regression-test/data/nereids_tpch_shape_sf500_p0/shape/q8.out
diff --git a/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q9.out
b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q9.out
new file mode 100644
index 0000000000..1df33d14e3
--- /dev/null
+++ b/regression-test/data/nereids_tpch_shape_sf500_p0/shape/q9.out
@@ -0,0 +1,35 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !select --
+PhysicalQuickSort
+--PhysicalDistribute
+----PhysicalQuickSort
+------hashAgg[GLOBAL]
+--------PhysicalDistribute
+----------hashAgg[LOCAL]
+------------PhysicalProject
+--------------hashJoin[INNER_JOIN](partsupp.ps_suppkey =
lineitem.l_suppkey)(partsupp.ps_partkey = lineitem.l_partkey)
+----------------PhysicalDistribute
+------------------PhysicalProject
+--------------------hashJoin[INNER_JOIN](orders.o_orderkey =
lineitem.l_orderkey)
+----------------------PhysicalProject
+------------------------PhysicalOlapScan[orders]
+----------------------PhysicalProject
+------------------------hashJoin[INNER_JOIN](supplier.s_suppkey =
lineitem.l_suppkey)
+--------------------------PhysicalProject
+----------------------------hashJoin[INNER_JOIN](part.p_partkey =
lineitem.l_partkey)
+------------------------------PhysicalProject
+--------------------------------PhysicalOlapScan[lineitem]
+------------------------------PhysicalDistribute
+--------------------------------PhysicalProject
+----------------------------------filter((p_name like '%green%'))
+------------------------------------PhysicalOlapScan[part]
+--------------------------PhysicalDistribute
+----------------------------hashJoin[INNER_JOIN](supplier.s_nationkey =
nation.n_nationkey)
+------------------------------PhysicalProject
+--------------------------------PhysicalOlapScan[supplier]
+------------------------------PhysicalDistribute
+--------------------------------PhysicalProject
+----------------------------------PhysicalOlapScan[nation]
+----------------PhysicalProject
+------------------PhysicalOlapScan[partsupp]
+
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/load.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/load.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/load.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/load.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q1.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q1.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q1.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q1.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q10.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q10.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q10.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q10.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q11.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q11.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q11.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q11.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q12.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q12.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q12.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q12.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q13.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q13.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q13.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q13.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q14.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q14.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q14.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q14.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q15.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q15.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q15.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q15.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q16.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q16.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q16.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q16.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q17.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q17.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q17.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q17.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q18.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q18.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q18.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q18.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q19.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q19.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q19.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q19.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q2.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q2.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q2.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q2.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q20.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q20.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q20.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q20.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q21.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q21.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q21.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q21.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q22.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q22.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q22.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q22.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q3.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q3.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q3.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q3.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q4.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q4.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q4.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q4.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q5.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q5.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q5.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q5.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q6.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q6.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q6.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q6.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q7.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q7.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q7.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q7.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q8.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q8.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q8.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q8.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q9.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q9.groovy
similarity index 100%
copy from regression-test/suites/nereids_tpchPlanShape_p0/shape/q9.groovy
copy to regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q9.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/load.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/load.groovy
similarity index 70%
rename from regression-test/suites/nereids_tpchPlanShape_p0/load.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/load.groovy
index 1ddd23a60c..7018c40037 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/load.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/load.groovy
@@ -222,151 +222,151 @@ suite("load") {
'''
sql '''
- alter table lineitem modify column l_receiptdate set stats ('ndv'='2567',
'avg_size'='16', 'max_size'='16', 'num_nulls'='0', 'min_value'='1992-01-04',
'max_value'='1998-12-31', 'row_count'='6001215')
+ alter table lineitem modify column l_receiptdate set stats ('ndv'='2587',
'avg_size'='16', 'max_size'='16', 'num_nulls'='0', 'min_value'='1992-01-03',
'max_value'='1998-12-31', 'row_count'='3000028242')
'''
sql '''
- alter table lineitem modify column l_returnflag set stats ('ndv'='3',
'avg_size'='1', 'max_size'='1', 'num_nulls'='0', 'min_value'='A',
'max_value'='R', 'row_count'='6001215');
+ alter table lineitem modify column l_returnflag set stats ('ndv'='3',
'avg_size'='1', 'max_size'='1', 'num_nulls'='0', 'min_value'='A',
'max_value'='R', 'row_count'='3000028242');
'''
sql '''
- alter table lineitem modify column l_tax set stats ('ndv'='9',
'avg_size'='16', 'max_size'='16', 'num_nulls'='0', 'min_value'='0',
'max_value'='0.08', 'row_count'='6001215');
+ alter table lineitem modify column l_tax set stats ('ndv'='9',
'avg_size'='16', 'max_size'='16', 'num_nulls'='0', 'min_value'='0',
'max_value'='0.08', 'row_count'='3000028242');
'''
sql '''
- alter table lineitem modify column l_shipmode set stats ('ndv'='7',
'avg_size'='4', 'max_size'='7', 'num_nulls'='0', 'min_value'='AIR',
'max_value'='TRUCK', 'row_count'='6001215');
+ alter table lineitem modify column l_shipmode set stats ('ndv'='7',
'avg_size'='4', 'max_size'='7', 'num_nulls'='0', 'min_value'='AIR',
'max_value'='TRUCK', 'row_count'='3000028242');
'''
sql '''
- alter table lineitem modify column l_suppkey set stats ('ndv'='9990',
'avg_size'='4', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='10000', 'row_count'='6001215');
+ alter table lineitem modify column l_suppkey set stats ('ndv'='4995648',
'avg_size'='4', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='5000000', 'row_count'='3000028242');
'''
sql '''
- alter table lineitem modify column l_shipdate set stats ('ndv'='2549',
'avg_size'='16', 'max_size'='16', 'num_nulls'='0', 'min_value'='1992-01-02',
'max_value'='1998-12-01', 'row_count'='6001215');
+ alter table lineitem modify column l_shipdate set stats ('ndv'='2549',
'avg_size'='16', 'max_size'='16', 'num_nulls'='0', 'min_value'='1992-01-02',
'max_value'='1998-12-01', 'row_count'='3000028242');
'''
sql '''
- alter table lineitem modify column l_commitdate set stats ('ndv'='2485',
'avg_size'='16', 'max_size'='16', 'num_nulls'='0', 'min_value'='1992-01-31',
'max_value'='1998-10-31', 'row_count'='6001215');
+ alter table lineitem modify column l_commitdate set stats ('ndv'='2485',
'avg_size'='16', 'max_size'='16', 'num_nulls'='0', 'min_value'='1992-01-31',
'max_value'='1998-10-31', 'row_count'='3000028242');
'''
sql '''
- alter table lineitem modify column l_partkey set stats ('ndv'='196099',
'avg_size'='4', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='10000', 'row_count'='6001215');
+ alter table lineitem modify column l_partkey set stats ('ndv'='101686464',
'avg_size'='4', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='100000000', 'row_count'='3000028242');
'''
sql '''
- alter table lineitem modify column l_orderkey set stats ('ndv'='1500000',
'avg_size'='8', 'max_size'='8', 'num_nulls'='0', 'min_value'='1',
'max_value'='10000', 'row_count'='6001215');
+ alter table lineitem modify column l_orderkey set stats
('ndv'='756756416', 'avg_size'='8', 'max_size'='8', 'num_nulls'='0',
'min_value'='1', 'max_value'='3000000000', 'row_count'='3000028242');
'''
sql '''
- alter table lineitem modify column l_quantity set stats ('ndv'='50',
'avg_size'='16', 'max_size'='16', 'num_nulls'='0', 'min_value'='1',
'max_value'='10000', 'row_count'='6001215');
+ alter table lineitem modify column l_quantity set stats ('ndv'='50',
'avg_size'='16', 'max_size'='16', 'num_nulls'='0', 'min_value'='1',
'max_value'='50', 'row_count'='3000028242');
'''
sql '''
- alter table lineitem modify column l_linestatus set stats ('ndv'='2',
'avg_size'='1', 'max_size'='1', 'num_nulls'='0', 'min_value'='F',
'max_value'='o', 'row_count'='6001215');
+ alter table lineitem modify column l_linestatus set stats ('ndv'='2',
'avg_size'='1', 'max_size'='1', 'num_nulls'='0', 'min_value'='F',
'max_value'='o', 'row_count'='3000028242');
'''
sql '''
- alter table lineitem modify column l_comment set stats ('ndv'='4619207',
'avg_size'='26', 'max_size'='43', 'num_nulls'='0', 'min_value'='1',
'max_value'='10000', 'row_count'='6001215');
+ alter table lineitem modify column l_comment set stats ('ndv'='154387840',
'avg_size'='26', 'max_size'='43', 'num_nulls'='0', 'min_value'='1',
'max_value'='10000', 'row_count'='3000028242');
'''
sql '''
- alter table lineitem modify column l_extendedprice set stats
('ndv'='929697', 'avg_size'='16', 'max_size'='16', 'num_nulls'='0',
'min_value'='1', 'max_value'='10000', 'row_count'='6001215');
+ alter table lineitem modify column l_extendedprice set stats
('ndv'='3805461', 'avg_size'='16', 'max_size'='16', 'num_nulls'='0',
'min_value'='900', 'max_value'='104949', 'row_count'='3000028242');
'''
sql '''
- alter table lineitem modify column l_linenumber set stats ('ndv'='7',
'avg_size'='4', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='7', 'row_count'='6001215');
+ alter table lineitem modify column l_linenumber set stats ('ndv'='7',
'avg_size'='4', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='7', 'row_count'='3000028242');
'''
sql '''
- alter table lineitem modify column l_discount set stats ('ndv'='11',
'avg_size'='16', 'max_size'='16', 'num_nulls'='0', 'min_value'='0',
'max_value'='0.1', 'row_count'='6001215');
+ alter table lineitem modify column l_discount set stats ('ndv'='11',
'avg_size'='16', 'max_size'='16', 'num_nulls'='0', 'min_value'='0',
'max_value'='0.1', 'row_count'='3000028242');
'''
sql '''
- alter table lineitem modify column l_shipinstruct set stats ('ndv'='4',
'avg_size'='12', 'max_size'='17', 'num_nulls'='0', 'min_value'='COLLECT COD',
'max_value'='TAKE BACK RETURN', 'row_count'='6001215');
+ alter table lineitem modify column l_shipinstruct set stats ('ndv'='4',
'avg_size'='12', 'max_size'='17', 'num_nulls'='0', 'min_value'='COLLECT COD',
'max_value'='TAKE BACK RETURN', 'row_count'='3000028242');
'''
sql '''
- alter table partsupp modify column ps_suppkey set stats ('ndv'='10009',
'avg_size'='4.0', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='10000', 'row_count'='800000');
+ alter table partsupp modify column ps_suppkey set stats ('ndv'='4995648',
'avg_size'='4.0', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='5000000', 'row_count'='400000000');
'''
sql '''
- alter table partsupp modify column ps_availqty set stats ('ndv'='10008',
'avg_size'='4.0', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='9999', 'row_count'='800000');
+ alter table partsupp modify column ps_availqty set stats ('ndv'='10008',
'avg_size'='4.0', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='9999', 'row_count'='400000000');
'''
sql '''
- alter table partsupp modify column ps_comment set stats ('ndv'='794782',
'avg_size'='123.6', 'max_size'='198', 'num_nulls'='0', 'min_value'='Tiresias
according to the quiet courts sleep against the ironic', 'max_value'='zzle.
unusual decoys detec', 'row_count'='800000');
+ alter table partsupp modify column ps_comment set stats
('ndv'='238546544', 'avg_size'='123.6', 'max_size'='198', 'num_nulls'='0',
'min_value'='Tiresias according to the quiet courts sleep against the ironic',
'max_value'='zzle. unusual decoys detec', 'row_count'='400000000');
'''
sql '''
- alter table partsupp modify column ps_partkey set stats ('ndv'='196099',
'avg_size'='4.0', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='200000', 'row_count'='800000');
+ alter table partsupp modify column ps_partkey set stats
('ndv'='101686464', 'avg_size'='4.0', 'max_size'='4', 'num_nulls'='0',
'min_value'='1', 'max_value'='100000000', 'row_count'='400000000');
'''
sql '''
- alter table partsupp modify column ps_supplycost set stats
('ndv'='100274', 'avg_size'='16.0', 'max_size'='16', 'num_nulls'='0',
'min_value'='1', 'max_value'='1000', 'row_count'='800000');
+ alter table partsupp modify column ps_supplycost set stats
('ndv'='100279', 'avg_size'='16.0', 'max_size'='16', 'num_nulls'='0',
'min_value'='1', 'max_value'='1000', 'row_count'='400000000');
'''
sql '''
- alter table supplier modify column s_comment set stats ('ndv'='10039',
'avg_size'='62.56950', 'max_size'='100', 'num_nulls'='0', 'min_value'='about
the blithely express foxes. bli', 'max_value'='zzle furiously. bold accounts
haggle fu', 'row_count'='10000');
+ alter table supplier modify column s_comment set stats ('ndv'='4942827',
'avg_size'='62.56950', 'max_size'='100', 'num_nulls'='0', 'min_value'='about
the blithely express foxes. bli', 'max_value'='zzle furiously. bold accounts
haggle fu', 'row_count'='5000000');
'''
sql '''
- alter table supplier modify column s_phone set stats ('ndv'='10021',
'avg_size'='15.0', 'max_size'='15', 'num_nulls'='0',
'min_value'='10-102-116-6785', 'max_value'='34-998-900-4911',
'row_count'='10000');
+ alter table supplier modify column s_phone set stats ('ndv'='5070193',
'avg_size'='15.0', 'max_size'='15', 'num_nulls'='0',
'min_value'='10-102-116-6785', 'max_value'='34-998-900-4911',
'row_count'='5000000');
'''
sql '''
- alter table supplier modify column s_nationkey set stats ('ndv'='25',
'avg_size'='4.0', 'max_size'='4', 'num_nulls'='0', 'min_value'='0',
'max_value'='24', 'row_count'='10000');
+ alter table supplier modify column s_nationkey set stats ('ndv'='25',
'avg_size'='4.0', 'max_size'='4', 'num_nulls'='0', 'min_value'='0',
'max_value'='24', 'row_count'='5000000');
'''
sql '''
- alter table supplier modify column s_name set stats ('ndv'='10002',
'avg_size'='18.0', 'max_size'='18', 'num_nulls'='0',
'min_value'='Supplier#000000001', 'max_value'='Supplier#000010000',
'row_count'='10000');
+ alter table supplier modify column s_name set stats ('ndv'='4930031',
'avg_size'='18.0', 'max_size'='18', 'num_nulls'='0',
'min_value'='Supplier#000000001', 'max_value'='Supplier#005000000',
'row_count'='5000000');
'''
sql '''
- alter table supplier modify column s_acctbal set stats ('ndv'='9954',
'avg_size'='16.0', 'max_size'='16', 'num_nulls'='0', 'min_value'='-998.22',
'max_value'='9999.72', 'row_count'='10000');
+ alter table supplier modify column s_acctbal set stats ('ndv'='1099069',
'avg_size'='16.0', 'max_size'='16', 'num_nulls'='0', 'min_value'='-998.22',
'max_value'='9999.72', 'row_count'='5000000');
'''
sql '''
- alter table supplier modify column s_address set stats ('ndv'='9888',
'avg_size'='24.9771', 'max_size'='40', 'num_nulls'='0', 'min_value'='
9aW1wwnBJJPnCx,n', 'max_value'='zzfDhdtZcvmVzA8rNFU,Yctj1zBN',
'row_count'='10000');
+ alter table supplier modify column s_address set stats ('ndv'='5000000',
'avg_size'='24.9771', 'max_size'='40', 'num_nulls'='0', 'min_value'='
9aW1wwnBJJPnCx,n', 'max_value'='zzfDhdtZcvmVzA8rNFU,Yctj1zBN',
'row_count'='5000000');
'''
sql '''
- alter table supplier modify column s_suppkey set stats ('ndv'='10000',
'avg_size'='4.0', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='10000', 'row_count'='10000');
+ alter table supplier modify column s_suppkey set stats ('ndv'='5000000',
'avg_size'='4.0', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='5000000', 'row_count'='5000000');
'''
sql '''
- alter table part modify column p_partkey set stats ('ndv'='200000',
'avg_size'='4.0', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='200000', 'row_count'='200000');
+ alter table part modify column p_partkey set stats ('ndv'='101686464',
'avg_size'='4.0', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='100000000', 'row_count'='100000000');
'''
sql '''
- alter table part modify column p_container set stats ('ndv'='40',
'avg_size'='7.57', 'max_size'='10', 'num_nulls'='0', 'min_value'='JUMBO BAG',
'max_value'='WRAP PKG', 'row_count'='200000');
+ alter table part modify column p_container set stats ('ndv'='40',
'avg_size'='7.57', 'max_size'='10', 'num_nulls'='0', 'min_value'='JUMBO BAG',
'max_value'='WRAP PKG', 'row_count'='100000000');
'''
sql '''
- alter table part modify column p_name set stats ('ndv'='200000',
'avg_size'='32.0', 'max_size'='50', 'num_nulls'='0', 'min_value'='almond
antique blue royal burnished', 'max_value'='yellow white seashell lavender
black', 'row_count'='200000');
+ alter table part modify column p_name set stats ('ndv'='98622912',
'avg_size'='32.0', 'max_size'='50', 'num_nulls'='0', 'min_value'='almond
antique blue royal burnished', 'max_value'='yellow white seashell lavender
black', 'row_count'='100000000');
'''
sql '''
- alter table part modify column p_comment set stats ('ndv'='133106',
'avg_size'='13', 'max_size'='22', 'num_nulls'='0', 'min_value'='Tire',
'max_value'='zzle. quickly si', 'row_count'='200000');
+ alter table part modify column p_comment set stats ('ndv'='10190453',
'avg_size'='13', 'max_size'='22', 'num_nulls'='0', 'min_value'='Tire',
'max_value'='zzle. quickly si', 'row_count'='100000000');
'''
sql '''
- alter table part modify column p_brand set stats ('ndv'='25',
'avg_size'='22', 'max_size'='22', 'num_nulls'='0', 'min_value'='Brand#11',
'max_value'='Brand#55', 'row_count'='200000');
+ alter table part modify column p_brand set stats ('ndv'='25',
'avg_size'='22', 'max_size'='22', 'num_nulls'='0', 'min_value'='Brand#11',
'max_value'='Brand#55', 'row_count'='100000000');
'''
sql '''
- alter table part modify column p_retailprice set stats ('ndv'='21096',
'avg_size'='16.0', 'max_size'='16', 'num_nulls'='0', 'min_value'='901',
'max_value'='2098.99', 'row_count'='200000');
+ alter table part modify column p_retailprice set stats ('ndv'='120904',
'avg_size'='16.0', 'max_size'='16', 'num_nulls'='0', 'min_value'='901',
'max_value'='2098.99', 'row_count'='100000000');
'''
sql '''
- alter table part modify column p_type set stats ('ndv'='150',
'avg_size'='20', 'max_size'='25', 'num_nulls'='0', 'min_value'='ECONOMY
ANODIZED BRASSe', 'max_value'='STANDARD POLISHED TIN ', 'row_count'='200000');
+ alter table part modify column p_type set stats ('ndv'='150',
'avg_size'='20', 'max_size'='25', 'num_nulls'='0', 'min_value'='ECONOMY
ANODIZED BRASSe', 'max_value'='STANDARD POLISHED TIN ',
'row_count'='100000000');
'''
sql '''
- alter table part modify column p_size set stats ('ndv'='50',
'avg_size'='4', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='50', 'row_count'='200000');
+ alter table part modify column p_size set stats ('ndv'='50',
'avg_size'='4', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='50', 'row_count'='100000000');
'''
sql '''
- alter table part modify column p_mfgr set stats ('ndv'='5',
'avg_size'='14', 'max_size'='14', 'num_nulls'='0',
'min_value'='Manufacturer#1', 'max_value'='Manufacturer#5',
'row_count'='200000');
+ alter table part modify column p_mfgr set stats ('ndv'='5',
'avg_size'='14', 'max_size'='14', 'num_nulls'='0',
'min_value'='Manufacturer#1', 'max_value'='Manufacturer#5',
'row_count'='100000000');
'''
sql '''
@@ -398,70 +398,70 @@ suite("load") {
'''
sql '''
- alter table customer modify column c_custkey set stats ('ndv'='150000',
'avg_size'='4', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='150000', 'row_count'='150000');
+ alter table customer modify column c_custkey set stats ('ndv'='76285424',
'avg_size'='4', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='75000000', 'row_count'='75000000');
'''
sql '''
- alter table customer modify column c_acctbal set stats ('ndv'='142496',
'avg_size'='16', 'max_size'='16', 'num_nulls'='0', 'min_value'='-999.99',
'max_value'='9999.99', 'row_count'='150000');
+ alter table customer modify column c_acctbal set stats ('ndv'='1109296',
'avg_size'='16', 'max_size'='16', 'num_nulls'='0', 'min_value'='-999.99',
'max_value'='9999.99', 'row_count'='75000000');
'''
sql '''
- alter table customer modify column c_phone set stats ('ndv'='150000',
'avg_size'='15', 'max_size'='15', 'num_nulls'='0',
'min_value'='10-100-106-1617', 'max_value'='34-999-618-6881',
'row_count'='150000');
+ alter table customer modify column c_phone set stats ('ndv'='75783176',
'avg_size'='15', 'max_size'='15', 'num_nulls'='0',
'min_value'='10-100-106-1617', 'max_value'='34-999-618-6881',
'row_count'='75000000');
'''
sql '''
- alter table customer modify column c_mktsegment set stats ('ndv'='5',
'avg_size'='8.9', 'max_size'='10', 'num_nulls'='0', 'min_value'='AUTOMOBILE',
'max_value'='MACHINERY', 'row_count'='150000');
+ alter table customer modify column c_mktsegment set stats ('ndv'='5',
'avg_size'='8.9', 'max_size'='10', 'num_nulls'='0', 'min_value'='AUTOMOBILE',
'max_value'='MACHINERY', 'row_count'='75000000');
'''
sql '''
- alter table customer modify column c_address set stats ('ndv'='150000',
'avg_size'='25', 'max_size'='40', 'num_nulls'='0', 'min_value'=' 2uZwVhQvwA',
'max_value'='zzxGktzXTMKS1BxZlgQ9nqQ', 'row_count'='150000');
+ alter table customer modify column c_address set stats ('ndv'='75000000',
'avg_size'='25', 'max_size'='40', 'num_nulls'='0', 'min_value'=' 2uZwVhQvwA',
'max_value'='zzxGktzXTMKS1BxZlgQ9nqQ', 'row_count'='75000000');
'''
sql '''
- alter table customer modify column c_nationkey set stats ('ndv'='25',
'avg_size'='4', 'max_size'='4', 'num_nulls'='0', 'min_value'='0',
'max_value'='24', 'row_count'='150000');
+ alter table customer modify column c_nationkey set stats ('ndv'='25',
'avg_size'='4', 'max_size'='4', 'num_nulls'='0', 'min_value'='0',
'max_value'='24', 'row_count'='75000000');
'''
sql '''
- alter table customer modify column c_name set stats ('ndv'='150000',
'avg_size'='25', 'max_size'='25', 'num_nulls'='0',
'min_value'='Customer#000000001', 'max_value'='Customer#000150000',
'row_count'='150000');
+ alter table customer modify column c_name set stats ('ndv'='75889840',
'avg_size'='25', 'max_size'='25', 'num_nulls'='0',
'min_value'='Customer#000000001', 'max_value'='Customer#075000000',
'row_count'='75000000');
'''
sql '''
- alter table customer modify column c_comment set stats ('ndv'='150000',
'avg_size'='72', 'max_size'='116', 'num_nulls'='0', 'min_value'=' Tiresias
according to the sly', 'max_value'='zzle. blithely regu0',
'row_count'='150000');
+ alter table customer modify column c_comment set stats ('ndv'='66629836',
'avg_size'='72', 'max_size'='116', 'num_nulls'='0', 'min_value'=' Tiresias
according to the sly', 'max_value'='zzle. blithely regu0',
'row_count'='75000000');
'''
sql '''
- alter table orders modify column o_orderstatus set stats ('ndv'='3',
'avg_size'='1.0', 'max_size'='1', 'num_nulls'='0', 'min_value'='F',
'max_value'='P', 'row_count'='1500000');
+ alter table orders modify column o_orderstatus set stats ('ndv'='3',
'avg_size'='1.0', 'max_size'='1', 'num_nulls'='0', 'min_value'='F',
'max_value'='P', 'row_count'='750000000');
'''
sql '''
- alter table orders modify column o_clerk set stats ('ndv'='988',
'avg_size'='15.0', 'max_size'='15', 'num_nulls'='0',
'min_value'='Clerk#000000001', 'max_value'='Clerk#000001000',
'row_count'='1500000');
+ alter table orders modify column o_clerk set stats ('ndv'='508347',
'avg_size'='15.0', 'max_size'='15', 'num_nulls'='0',
'min_value'='Clerk#000000001', 'max_value'='Clerk#000500000',
'row_count'='750000000');
'''
sql '''
- alter table orders modify column o_orderdate set stats ('ndv'='2417',
'avg_size'='16.0', 'max_size'='16', 'num_nulls'='0', 'min_value'='1992-01-01',
'max_value'='1998-08-02', 'row_count'='1500000');
+ alter table orders modify column o_orderdate set stats ('ndv'='2428',
'avg_size'='16.0', 'max_size'='16', 'num_nulls'='0', 'min_value'='1992-01-01',
'max_value'='1998-08-02', 'row_count'='750000000');
'''
sql '''
- alter table orders modify column o_shippriority set stats ('ndv'='1',
'avg_size'='4.0', 'max_size'='4', 'num_nulls'='0', 'min_value'='0',
'max_value'='0', 'row_count'='1500000');
+ alter table orders modify column o_shippriority set stats ('ndv'='1',
'avg_size'='4.0', 'max_size'='4', 'num_nulls'='0', 'min_value'='0',
'max_value'='0', 'row_count'='750000000');
'''
sql '''
- alter table orders modify column o_custkey set stats ('ndv'='99149',
'avg_size'='4.0', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='149999', 'row_count'='1500000');
+ alter table orders modify column o_custkey set stats ('ndv'='50471848',
'avg_size'='4.0', 'max_size'='4', 'num_nulls'='0', 'min_value'='1',
'max_value'='74999999', 'row_count'='750000000');
'''
sql '''
- alter table orders modify column o_totalprice set stats ('ndv'='1462416',
'avg_size'='16.0', 'max_size'='16', 'num_nulls'='0', 'min_value'='857.71',
'max_value'='555285.16', 'row_count'='1500000');
+ alter table orders modify column o_totalprice set stats ('ndv'='1462416',
'avg_size'='16.0', 'max_size'='16', 'num_nulls'='0', 'min_value'='857.71',
'max_value'='555285.16', 'row_count'='750000000');
'''
sql '''
- alter table orders modify column o_orderkey set stats ('ndv'='1500000',
'avg_size'='8.0', 'max_size'='8', 'num_nulls'='0', 'min_value'='1',
'max_value'='6000000', 'row_count'='1500000');
+ alter table orders modify column o_orderkey set stats ('ndv'='750000000',
'avg_size'='8.0', 'max_size'='8', 'num_nulls'='0', 'min_value'='1',
'max_value'='3000000000', 'row_count'='750000000');
'''
sql '''
- alter table orders modify column o_comment set stats ('ndv'='1465415',
'avg_size'='48.51387', 'max_size'='78', 'num_nulls'='0', 'min_value'='Tiresias
about the blithely ironic a', 'max_value'='zzle? furiously ironic instructions
among the unusual t ', 'row_count'='1500000');
+ alter table orders modify column o_comment set stats ('ndv'='260882608',
'avg_size'='48.51387', 'max_size'='78', 'num_nulls'='0', 'min_value'='Tiresias
about the blithely ironic a', 'max_value'='zzle? furiously ironic instructions
among the unusual t ', 'row_count'='750000000');
'''
sql '''
- alter table orders modify column o_orderpriority set stats ('ndv'='5',
'avg_size'='8.4', 'max_size'='15', 'num_nulls'='0', 'min_value'='1-URGENT',
'max_value'='5-LOW', 'row_count'='1500000');
+ alter table orders modify column o_orderpriority set stats ('ndv'='5',
'avg_size'='8.4', 'max_size'='15', 'num_nulls'='0', 'min_value'='1-URGENT',
'max_value'='5-LOW', 'row_count'='750000000');
'''
}
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q1.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q1.groovy
similarity index 100%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q1.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q1.groovy
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q10.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q10.groovy
similarity index 89%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q10.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q10.groovy
index e7a0ed87a9..8b8d1c8a08 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q10.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q10.groovy
@@ -25,7 +25,10 @@ suite("q10") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
-
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q11.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q11.groovy
similarity index 90%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q11.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q11.groovy
index 028c7529aa..90921595ec 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q11.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q11.groovy
@@ -25,7 +25,10 @@ suite("q11") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
-
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q12.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q12.groovy
similarity index 90%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q12.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q12.groovy
index 6221ca9c90..da84e2ae06 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q12.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q12.groovy
@@ -25,7 +25,10 @@ suite("q12") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
-
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q13.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q13.groovy
similarity index 89%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q13.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q13.groovy
index 460a316b17..b576084dad 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q13.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q13.groovy
@@ -25,7 +25,11 @@ suite("q13") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q14.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q14.groovy
similarity index 89%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q14.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q14.groovy
index c8d28ef6ca..ddbfb307b7 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q14.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q14.groovy
@@ -25,7 +25,10 @@ suite("q14") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
-
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q15.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q15.groovy
similarity index 88%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q15.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q15.groovy
index b6888c2cc8..9365f0d2e2 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q15.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q15.groovy
@@ -25,7 +25,10 @@ suite("q15") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
-
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q16.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q16.groovy
similarity index 89%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q16.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q16.groovy
index 565cbc8dd2..e7fc3d6a83 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q16.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q16.groovy
@@ -25,7 +25,10 @@ suite("q16") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
-
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q17.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q17.groovy
similarity index 88%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q17.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q17.groovy
index bf85f08e54..ab910f33c1 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q17.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q17.groovy
@@ -25,7 +25,10 @@ suite("q17") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
-
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q18.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q18.groovy
similarity index 90%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q18.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q18.groovy
index 79ab60654d..d7a2e2a142 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q18.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q18.groovy
@@ -25,7 +25,10 @@ suite("q18") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
-
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q19.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q19.groovy
similarity index 92%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q19.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q19.groovy
index 41b078eb40..b950ec8fea 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q19.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q19.groovy
@@ -26,7 +26,10 @@ suite("q19") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
-
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q2.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q2.groovy
similarity index 93%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q2.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q2.groovy
index 8476049746..2e27bfd1f6 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q2.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q2.groovy
@@ -25,6 +25,9 @@ suite("q2") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
qt_select """
explain shape plan
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q20.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q20.groovy
similarity index 91%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q20.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q20.groovy
index 37c97ffe2f..297dd4cf36 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q20.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q20.groovy
@@ -26,7 +26,10 @@ suite("q20") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
-
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q21.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q21.groovy
similarity index 91%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q21.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q21.groovy
index 6a17489bc3..78d0817533 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q21.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q21.groovy
@@ -25,7 +25,10 @@ suite("q21") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
-
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q22.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q22.groovy
similarity index 91%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q22.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q22.groovy
index 6b9ed6713b..9f9f99afe8 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q22.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q22.groovy
@@ -25,7 +25,10 @@ suite("q22") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
-
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q3.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q3.groovy
similarity index 89%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q3.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q3.groovy
index 4fd26f615f..6d99ce30d2 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q3.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q3.groovy
@@ -26,7 +26,10 @@ suite("q3") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
-
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q4.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q4.groovy
similarity index 89%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q4.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q4.groovy
index 67e98d6d66..c08531db12 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q4.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q4.groovy
@@ -25,7 +25,10 @@ suite("q4") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
-
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q5.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q5.groovy
similarity index 89%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q5.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q5.groovy
index a070bb76fa..7346489d6f 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q5.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q5.groovy
@@ -25,7 +25,10 @@ suite("q5") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
-
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q6.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q6.groovy
similarity index 88%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q6.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q6.groovy
index f846b4016a..adc3976561 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q6.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q6.groovy
@@ -25,7 +25,10 @@ suite("q6") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
-
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q7.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q7.groovy
similarity index 91%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q7.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q7.groovy
index 54e6eaf404..e21a857f07 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q7.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q7.groovy
@@ -25,7 +25,10 @@ suite("q7") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
-
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q8.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q8.groovy
similarity index 91%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q8.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q8.groovy
index 73fbca0524..627bc8b03c 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q8.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q8.groovy
@@ -25,7 +25,10 @@ suite("q8") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
-
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q9.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q9.groovy
similarity index 90%
rename from regression-test/suites/nereids_tpchPlanShape_p0/shape/q9.groovy
rename to regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q9.groovy
index 0e38b7bb7b..efb81269df 100644
--- a/regression-test/suites/nereids_tpchPlanShape_p0/shape/q9.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q9.groovy
@@ -25,6 +25,9 @@ suite("q9") {
sql "set runtime_filter_mode='GLOBAL'"
sql "set enable_runtime_filter_prune=true"
sql 'set exec_mem_limit=21G'
+ sql 'set enable_new_cost_model=false'
+ sql 'set global exec_mem_limit = 21G'
+ sql 'set global broadcast_row_count_limit = 30000000'
qt_select """
explain shape plan
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
