Hi, I am new to mapd and I am trying to run tpch on mapd. Now I am confused on how to join three or more tables on mapd use mapd join .
For example, I rewrote the Q5 of tpch, it will damage the performance severely. so I want to know if there are some rules for join that I ignored?
3 sum(l_extendedprice * (1 - l_discount)) as revenue
5 (select * from nation join region on n_regionkey = r_regionkey) join
6 (select * from (select * from orders join lineitem on o_orderkey = l_orderkey) join
7 (select * from supplier join customer on s_nationkey = c_nationkey) on o_custkey = c_custkey where s_suppkey = l_suppkey) on n_nationkey = s_nationkey
9 r_name = ‘ASIA’
10 and o_orderdate >= date ‘1994-01-01’
11 and o_orderdate < date ‘1994-01-01’ + interval ‘1’ year
12 group by
14 order by
15 revenue desc