impala-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "helifu" <hzhel...@corp.netease.com>
Subject Could anybody help to explain why there is such a big gap in 'ProbeTime' and How to fix this gap?
Date Wed, 03 Jan 2018 07:40:59 GMT
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