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

[hel...@gmail.com]

On 2018-01-03 15:40, "helifu" <hzhel...@corp.netease.com> wrote: 
> 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
> 
>  
> 
>