Details
-
Improvement
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
Impala 4.0.0
-
None
-
ghx-label-10
Description
The query with analytic function doesn't need to materialize the predicate pushed down to kudu.
E.g.
select min(n_nationkey) over(partition by n_regionkey) from tpch_kudu.nation t1 where t1.n_name in ('ALGERIA', 'ARGENTINA');
The plan
PLAN-ROOT SINK | 02:ANALYTIC | functions: min(n_nationkey) | partition by: n_regionkey | row-size=25B cardinality=2 | 01:SORT | order by: n_regionkey ASC NULLS LAST | row-size=23B cardinality=2 | 00:SCAN KUDU [tpch_kudu.nation t1] kudu predicates: t1.n_name IN ('ALGERIA', 'ARGENTINA') row-size=27B cardinality=2
We don't need to materialize the slot 'n_name'.