qpmodel icon indicating copy to clipboard operation
qpmodel copied to clipboard

Published 20 hours ago • verified publisher icon zhouqingqing

Distributed TPCH incorrect results and sub-optimal plan

Open arzuschen opened this issue 4 years ago • 3 comments

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 avatar Aug 18 '20 18:08 arzuschen

#194 q10 incorrect result fixed.

arzuschen avatar Aug 19 '20 00:08 arzuschen

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

arzuschen avatar Aug 19 '20 21:08 arzuschen

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

9DemonFox avatar Nov 09 '20 08:11 9DemonFox