zhouqingqing / qpmodel

A Relational Optimizer and Executor

MIT License

66 stars 19 forks source link

Distributed TPCH incorrect results and sub-optimal plan #197

Open arzuschen opened 4 years ago

arzuschen commented 4 years ago

currently with redistribution and gather directly added from logic tree: q01, q02, q03, q04, q05, q06, q10, q11, q12, q14, a16, q17, q18, q19, q20, q21 are runnable q01, q03, q04, q06, q10, q12, q14 have output

~~q10 has incorrect result due to NLJoin with distributed data stream~~ q04 has incorrect output, wrong tuple and most part missing

arzuschen commented 4 years ago

194 q10 incorrect result fixed.

arzuschen commented 4 years ago

~~q04 has unstable output,~~ ~~q18 and q20 have unstable plan (similar to Q16, extra "loop")~~

9DemonFox commented 4 years ago

263 , they might have the same cause. The FROM clause in TPCH is not handled correctly. I am working to check it.