impala-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "helifu@gmail.com"<hel...@gmail.com>
Subject Re: Could anybody help to explain why there is such a big gap in 'ProbeTime' and How to fix this gap?
Date Tue, 09 Jan 2018 06:17:32 GMT


On 2018-01-03 15:40, "helifu" <hzhelifu@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
> 
>  
> 
> 

Mime
View raw message