This is an automated email from the ASF dual-hosted git repository.
yiguolei 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 7075bcc526 [tools](refactor) remove unused session variables (#21405)
7075bcc526 is described below
commit 7075bcc52645e8953c982d884f075fe27debe0a9
Author: Gabriel <[email protected]>
AuthorDate: Sat Jul 1 16:14:36 2023 +0800
[tools](refactor) remove unused session variables (#21405)
---
tools/ssb-tools/ssb-queries/q4.1.sql | 2 +-
tools/ssb-tools/ssb-queries/q4.2.sql | 2 +-
tools/ssb-tools/ssb-queries/q4.3.sql | 2 +-
tools/tpch-tools/queries/q1.sql | 2 +-
tools/tpch-tools/queries/q10.sql | 2 +-
tools/tpch-tools/queries/q11.sql | 2 +-
tools/tpch-tools/queries/q12.sql | 2 +-
tools/tpch-tools/queries/q13.sql | 2 +-
tools/tpch-tools/queries/q14.sql | 2 +-
tools/tpch-tools/queries/q15.sql | 2 +-
tools/tpch-tools/queries/q16.sql | 2 +-
tools/tpch-tools/queries/q17.sql | 2 +-
tools/tpch-tools/queries/q18.sql | 2 +-
tools/tpch-tools/queries/q19.sql | 2 +-
tools/tpch-tools/queries/q2.sql | 2 +-
tools/tpch-tools/queries/q20.sql | 2 +-
tools/tpch-tools/queries/q21.sql | 2 +-
tools/tpch-tools/queries/q22.sql | 2 +-
tools/tpch-tools/queries/q3.sql | 2 +-
tools/tpch-tools/queries/q4.sql | 2 +-
tools/tpch-tools/queries/q5.sql | 2 +-
tools/tpch-tools/queries/q6.sql | 2 +-
tools/tpch-tools/queries/q7.sql | 2 +-
tools/tpch-tools/queries/q8.sql | 2 +-
tools/tpch-tools/queries/q9.sql | 2 +-
25 files changed, 25 insertions(+), 25 deletions(-)
diff --git a/tools/ssb-tools/ssb-queries/q4.1.sql
b/tools/ssb-tools/ssb-queries/q4.1.sql
index db2fe5c1f7..d6efe570a3 100644
--- a/tools/ssb-tools/ssb-queries/q4.1.sql
+++ b/tools/ssb-tools/ssb-queries/q4.1.sql
@@ -14,7 +14,7 @@
-- KIND, either express or implied. See the License for the
-- specific language governing permissions and limitations
-- under the License.
-SELECT /*+SET_VAR(parallel_fragment_exec_instance_num=4, batch_size=4096,
enable_cost_based_join_reorder=true, enable_projection=true) */
+SELECT
d_year,
c_nation,
SUM(lo_revenue - lo_supplycost) AS PROFIT
diff --git a/tools/ssb-tools/ssb-queries/q4.2.sql
b/tools/ssb-tools/ssb-queries/q4.2.sql
index 1d6c8779c2..c2f1a0ffdd 100644
--- a/tools/ssb-tools/ssb-queries/q4.2.sql
+++ b/tools/ssb-tools/ssb-queries/q4.2.sql
@@ -14,7 +14,7 @@
-- KIND, either express or implied. See the License for the
-- specific language governing permissions and limitations
-- under the License.
-SELECT /*+SET_VAR(parallel_fragment_exec_instance_num=2, batch_size=4096,
enable_cost_based_join_reorder=true, enable_projection=true) */
+SELECT
d_year,
s_nation,
p_category,
diff --git a/tools/ssb-tools/ssb-queries/q4.3.sql
b/tools/ssb-tools/ssb-queries/q4.3.sql
index ca368f77cd..f593a10291 100644
--- a/tools/ssb-tools/ssb-queries/q4.3.sql
+++ b/tools/ssb-tools/ssb-queries/q4.3.sql
@@ -14,7 +14,7 @@
-- KIND, either express or implied. See the License for the
-- specific language governing permissions and limitations
-- under the License.
-SELECT /*+SET_VAR(parallel_fragment_exec_instance_num=2, batch_size=4096,
enable_cost_based_join_reorder=true, enable_projection=true) */
+SELECT
d_year,
s_city,
p_brand,
diff --git a/tools/tpch-tools/queries/q1.sql b/tools/tpch-tools/queries/q1.sql
index 488bd9a4e3..a888c2bdb1 100644
--- a/tools/tpch-tools/queries/q1.sql
+++ b/tools/tpch-tools/queries/q1.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
l_returnflag,
l_linestatus,
sum(l_quantity) as sum_qty,
diff --git a/tools/tpch-tools/queries/q10.sql b/tools/tpch-tools/queries/q10.sql
index 3e68b96f96..bcfdace8c3 100644
--- a/tools/tpch-tools/queries/q10.sql
+++ b/tools/tpch-tools/queries/q10.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
c_custkey,
c_name,
sum(l_extendedprice * (1 - l_discount)) as revenue,
diff --git a/tools/tpch-tools/queries/q11.sql b/tools/tpch-tools/queries/q11.sql
index e17cb3cd79..4aa0813f02 100644
--- a/tools/tpch-tools/queries/q11.sql
+++ b/tools/tpch-tools/queries/q11.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
ps_partkey,
sum(ps_supplycost * ps_availqty) as value
from
diff --git a/tools/tpch-tools/queries/q12.sql b/tools/tpch-tools/queries/q12.sql
index 7e9e723fc0..d53dd9c809 100644
--- a/tools/tpch-tools/queries/q12.sql
+++ b/tools/tpch-tools/queries/q12.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
l_shipmode,
sum(case
when o_orderpriority = '1-URGENT'
diff --git a/tools/tpch-tools/queries/q13.sql b/tools/tpch-tools/queries/q13.sql
index e934a7e0ed..a35497cd57 100644
--- a/tools/tpch-tools/queries/q13.sql
+++ b/tools/tpch-tools/queries/q13.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
c_count,
count(*) as custdist
from
diff --git a/tools/tpch-tools/queries/q14.sql b/tools/tpch-tools/queries/q14.sql
index 4f72e3eb5d..960cd15fb3 100644
--- a/tools/tpch-tools/queries/q14.sql
+++ b/tools/tpch-tools/queries/q14.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
100.00 * sum(case
when p_type like 'PROMO%'
then l_extendedprice * (1 - l_discount)
diff --git a/tools/tpch-tools/queries/q15.sql b/tools/tpch-tools/queries/q15.sql
index 696526a099..afc83e47d1 100644
--- a/tools/tpch-tools/queries/q15.sql
+++ b/tools/tpch-tools/queries/q15.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
s_suppkey,
s_name,
s_address,
diff --git a/tools/tpch-tools/queries/q16.sql b/tools/tpch-tools/queries/q16.sql
index 30fa1e1a8a..6027b5c2d0 100644
--- a/tools/tpch-tools/queries/q16.sql
+++ b/tools/tpch-tools/queries/q16.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
p_brand,
p_type,
p_size,
diff --git a/tools/tpch-tools/queries/q17.sql b/tools/tpch-tools/queries/q17.sql
index eb312b6fa6..ca5c843d79 100644
--- a/tools/tpch-tools/queries/q17.sql
+++ b/tools/tpch-tools/queries/q17.sql
@@ -17,7 +17,7 @@
-- Modified
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
sum(l_extendedprice) / 7.0 as avg_yearly
from
lineitem,
diff --git a/tools/tpch-tools/queries/q18.sql b/tools/tpch-tools/queries/q18.sql
index 6b2eea1d3b..84f9808a14 100644
--- a/tools/tpch-tools/queries/q18.sql
+++ b/tools/tpch-tools/queries/q18.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
c_name,
c_custkey,
o_orderkey,
diff --git a/tools/tpch-tools/queries/q19.sql b/tools/tpch-tools/queries/q19.sql
index d3750eddcb..a20a62533a 100644
--- a/tools/tpch-tools/queries/q19.sql
+++ b/tools/tpch-tools/queries/q19.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
sum(l_extendedprice* (1 - l_discount)) as revenue
from
lineitem,
diff --git a/tools/tpch-tools/queries/q2.sql b/tools/tpch-tools/queries/q2.sql
index 6e8f2ecffa..3bd5c6198a 100644
--- a/tools/tpch-tools/queries/q2.sql
+++ b/tools/tpch-tools/queries/q2.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
s_acctbal,
s_name,
n_name,
diff --git a/tools/tpch-tools/queries/q20.sql b/tools/tpch-tools/queries/q20.sql
index e693f36ad3..9d19db62a4 100644
--- a/tools/tpch-tools/queries/q20.sql
+++ b/tools/tpch-tools/queries/q20.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
s_name,
s_address
from
diff --git a/tools/tpch-tools/queries/q21.sql b/tools/tpch-tools/queries/q21.sql
index 146fe1fd82..7233be7ecf 100644
--- a/tools/tpch-tools/queries/q21.sql
+++ b/tools/tpch-tools/queries/q21.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
s_name,
count(*) as numwait
from
diff --git a/tools/tpch-tools/queries/q22.sql b/tools/tpch-tools/queries/q22.sql
index 498307535a..79ae53445e 100644
--- a/tools/tpch-tools/queries/q22.sql
+++ b/tools/tpch-tools/queries/q22.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
cntrycode,
count(*) as numcust,
sum(c_acctbal) as totacctbal
diff --git a/tools/tpch-tools/queries/q3.sql b/tools/tpch-tools/queries/q3.sql
index f0f97f8e07..73fbb51ede 100644
--- a/tools/tpch-tools/queries/q3.sql
+++ b/tools/tpch-tools/queries/q3.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
l_orderkey,
sum(l_extendedprice * (1 - l_discount)) as revenue,
o_orderdate,
diff --git a/tools/tpch-tools/queries/q4.sql b/tools/tpch-tools/queries/q4.sql
index 0fd4f871a3..cf6021b035 100644
--- a/tools/tpch-tools/queries/q4.sql
+++ b/tools/tpch-tools/queries/q4.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
o_orderpriority,
count(*) as order_count
from
diff --git a/tools/tpch-tools/queries/q5.sql b/tools/tpch-tools/queries/q5.sql
index f43d7ab542..5e3bc4116f 100644
--- a/tools/tpch-tools/queries/q5.sql
+++ b/tools/tpch-tools/queries/q5.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
n_name,
sum(l_extendedprice * (1 - l_discount)) as revenue
from
diff --git a/tools/tpch-tools/queries/q6.sql b/tools/tpch-tools/queries/q6.sql
index 65f9d90112..2d62a6a4f1 100644
--- a/tools/tpch-tools/queries/q6.sql
+++ b/tools/tpch-tools/queries/q6.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
sum(l_extendedprice * l_discount) as revenue
from
lineitem
diff --git a/tools/tpch-tools/queries/q7.sql b/tools/tpch-tools/queries/q7.sql
index 5939c82523..32ec856ae1 100644
--- a/tools/tpch-tools/queries/q7.sql
+++ b/tools/tpch-tools/queries/q7.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
supp_nation,
cust_nation,
l_year,
diff --git a/tools/tpch-tools/queries/q8.sql b/tools/tpch-tools/queries/q8.sql
index 1d031cc0f1..e61c8632d0 100644
--- a/tools/tpch-tools/queries/q8.sql
+++ b/tools/tpch-tools/queries/q8.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
o_year,
sum(case
when nation = 'BRAZIL' then volume
diff --git a/tools/tpch-tools/queries/q9.sql b/tools/tpch-tools/queries/q9.sql
index a4f58b34df..8e486d8fa3 100644
--- a/tools/tpch-tools/queries/q9.sql
+++ b/tools/tpch-tools/queries/q9.sql
@@ -15,7 +15,7 @@
-- specific language governing permissions and limitations
-- under the License.
-select /*+SET_VAR(enable_nereids_planner=true,enable_pipeline_engine=true) */
+select
nation,
o_year,
sum(amount) as sum_profit
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
