[incubator-doris] branch master updated: [test] tpch q3 rewrite, change join order, make lineitem on left side (#10055)

[yi...@apache.org]

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/incubator-doris.git


The following commit(s) were added to refs/heads/master by this push:
     new 15e1bb448f [test] tpch q3 rewrite, change join order, make lineitem on left side (#10055)
15e1bb448f is described below

commit 15e1bb448f79c4967ee0e38fdd6909b8f3310bc5
Author: minghong <en...@gmail.com>
AuthorDate: Tue Jun 14 17:16:33 2022 +0800

    [test] tpch q3 rewrite, change join order, make lineitem on left side (#10055)
    
    rewrite the sql in tpch test tools
---
 tools/tpch-tools/queries/q3.sql | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

diff --git a/tools/tpch-tools/queries/q3.sql b/tools/tpch-tools/queries/q3.sql
index 316a728ee3..3dcd108684 100644
--- a/tools/tpch-tools/queries/q3.sql
+++ b/tools/tpch-tools/queries/q3.sql
@@ -23,16 +23,15 @@ select /*+SET_VAR(parallel_fragment_exec_instance_num=8, enable_vectorized_engin
     o_orderdate,
     o_shippriority
 from
-    customer c join
     (
         select l_orderkey, l_extendedprice, l_discount, o_orderdate, o_shippriority, o_custkey from
         lineitem join orders
         where l_orderkey = o_orderkey
         and o_orderdate < date '1995-03-15'
         and l_shipdate > date '1995-03-15'
-    ) t1
+    ) t1 join customer c 
+    on c.c_custkey = t1.o_custkey
     where c_mktsegment = 'BUILDING'
-    and c.c_custkey = t1.o_custkey
 group by
     l_orderkey,
     o_orderdate,


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org