search

zhouqingqing / qpmodel

A Relational Optimizer and Executor
MIT License
64 stars 18 forks source link

TPCH distributed test errors (without MEMO) #188

Open arzuschen opened 3 years ago

arzuschen commented 3 years ago

Currently, only a fraction of the tpch queries can be run (q02, q04, q07, q08, q09, q13, q14, q15, q17, q18, q20, q21, q22 cannot be run)

Also, q10 has wrong output and q03 has error in cardinality estimation. (row = 0 while not 0 in non distributed plan)

related: #193

arzuschen commented 3 years ago

non-cached subquery, which requires parameters from main query, cannot be executed in the distributed @zhouruiapple - Rui, can you work on execution part to see how to implement this?

Open #208 to track it.

zhouqingqing commented 3 years ago

1. broadcast optimization; 2. fix aggr by splitting global/local;

  1. add more primitive tests;
  2. document with memo print out;

@arzuschen

arzuschen commented 3 years ago

q07, q08, q09, q22 are caused by gather not finding distributed context if placed under physicfromquery q13 is caused by memo not getting any possible solution q15 debug assertion not passed since selectstmt.distributed_ changed more than once

(q13 concerns optimizer and q15 should be a simple fix, I will work on those two first)

9DemonFox commented 3 years ago

q07, q08, q09, q22 are caused by gather not finding distributed context if placed under physicfromquery

fixed, see PR#264.