This is an automated email from the ASF dual-hosted git repository.
kxiao pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.0 by this push:
new 8cbdf49458 [debug] add log for 2.0 tpch 1T shape q5/10/21/22 (#23301)
8cbdf49458 is described below
commit 8cbdf494587f8d8547209d1993577d8cf21c8b9e
Author: minghong <[email protected]>
AuthorDate: Tue Aug 22 21:18:29 2023 +0800
[debug] add log for 2.0 tpch 1T shape q5/10/21/22 (#23301)
---
.../suites/nereids_tpch_shape_sf1000_p0/shape/q10.groovy | 9 +++++++--
.../suites/nereids_tpch_shape_sf1000_p0/shape/q21.groovy | 10 +++++++---
.../suites/nereids_tpch_shape_sf1000_p0/shape/q22.groovy | 12 ++++++++----
.../suites/nereids_tpch_shape_sf1000_p0/shape/q5.groovy | 11 +++++++++--
4 files changed, 31 insertions(+), 11 deletions(-)
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q10.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q10.groovy
index f4101b5124..1161af3f3c 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q10.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q10.groovy
@@ -28,8 +28,7 @@ suite("q10") {
sql 'SET enable_pipeline_engine = true'
sql 'set be_number_for_test=3'
- qt_select """
- explain shape plan
+ String q10 = """
select
c_custkey,
c_name,
@@ -63,4 +62,10 @@ sql 'set be_number_for_test=3'
revenue desc
limit 20;
"""
+
+ String memo = sql " explain memo plan ${q10} "
+ println("q10 memo >>>")
+ println(memo)
+
+ qt_select " explain shape plan ${q10} "
}
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q21.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q21.groovy
index 3cd8e20304..e9d074b881 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q21.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q21.groovy
@@ -30,10 +30,9 @@ suite("q21") {
-sql 'set be_number_for_test=3'
+ sql 'set be_number_for_test=3'
- qt_select """
- explain shape plan
+ String q21 = """
select
s_name,
count(*) as numwait
@@ -75,4 +74,9 @@ sql 'set be_number_for_test=3'
s_name
limit 100;
"""
+ String memo = sql "explain memo plan ${q21}"
+ println("q21 memo >>>")
+ println(memo)
+
+ qt_select "explain shape plan ${q21}"
}
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q22.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q22.groovy
index 6f3e4d7aa4..06c25f756d 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q22.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q22.groovy
@@ -31,10 +31,8 @@ suite("q22") {
sql 'set be_number_for_test=3'
-
- qt_select """
- explain shape plan
- select
+ String q22 = """
+ select
cntrycode,
count(*) as numcust,
sum(c_acctbal) as totacctbal
@@ -72,4 +70,10 @@ sql 'set be_number_for_test=3'
order by
cntrycode;
"""
+
+ String memo = sql "explain memo plan ${q22}"
+ println("q22 memo >>>")
+ println(memo)
+
+ qt_select " explain shape plan ${q22} "
}
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q5.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q5.groovy
index 0a9c786326..271b75615b 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q5.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q5.groovy
@@ -32,8 +32,7 @@ suite("q5") {
sql 'set be_number_for_test=3'
- qt_select """
- explain shape plan
+ String q5 = """
select
n_name,
sum(l_extendedprice * (1 - l_discount)) as revenue
@@ -59,4 +58,12 @@ sql 'set be_number_for_test=3'
order by
revenue desc;
"""
+
+ memo = sql " explain memo plan ${q5}"
+
+ println("q5 memo >>>")
+ println(memo)
+
+ qt_select "explain shape plan ${q5}"
+
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
