[
https://issues.apache.org/jira/browse/IMPALA-10406?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Xianqing He updated IMPALA-10406:
---------------------------------
Description:
The query with analytic function doesn't need to materialize the predicate
pushed down to kudu.
E.g.
{code:java}
select min(n_nationkey) over(partition by n_regionkey) from tpch_kudu.nation t1
where t1.n_name in ('ALGERIA', 'ARGENTINA');
{code}
The plan
{code:java}
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
{code}
We don't need to materialize the slot 'n_name'.
was:
The query with analytic function doesn't need to materialize the predicate
pushed down to kudu.
E.g.
{code:java}
select min(n_nationkey) over(partition by n_regionkey) from tpch_kudu.nation t1
where t1.n_name in ('ALGERIA', 'ARGENTINA');
{code}
The plan
{code:java}
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
{code}
We don't need to materialize the slot 'n_name'.
> Query with analytic function doesn't need to materialize the predicate pushed
> down to kudu
> ------------------------------------------------------------------------------------------
>
> Key: IMPALA-10406
> URL: https://issues.apache.org/jira/browse/IMPALA-10406
> Project: IMPALA
> Issue Type: Improvement
> Components: Frontend
> Affects Versions: Impala 4.0
> Reporter: Xianqing He
> Assignee: Xianqing He
> Priority: Minor
> Fix For: Impala 4.0
>
>
> The query with analytic function doesn't need to materialize the predicate
> pushed down to kudu.
> E.g.
> {code:java}
> select min(n_nationkey) over(partition by n_regionkey) from tpch_kudu.nation
> t1 where t1.n_name in ('ALGERIA', 'ARGENTINA');
> {code}
> The plan
> {code:java}
> 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
> {code}
> We don't need to materialize the slot 'n_name'.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org
