Could anybody help to explain why there is such a big gap in 'ProbeTime' and How to fix this gap?

[helifu]

Hi everybody,

 

Recently I ran a simple PHJ on‘parquet’ and ‘kudu’with this sql
independently:

select count(*) from lineitem as l, orders as o where l.l_orderkey =
o.o_orderkey and o.o_orderdate < '1996-01-01' and o.o_orderdate >=
'1995-01-01';

 

And I found that the ‘ProbeTime’ on ‘kudu’is much larger than on
‘parquet’!!





 

Below are the plans and profiles:



 

Thanks in advance.

 

 

何李夫

2017-04-10 16:06:24