You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Quanlong Huang (Jira)" <ji...@apache.org> on 2022/07/29 09:10:00 UTC
[jira] [Resolved] (IMPALA-10806) Create single node plan is slow when hundreds of inline views are joined
[ https://issues.apache.org/jira/browse/IMPALA-10806?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Quanlong Huang resolved IMPALA-10806.
-------------------------------------
Fix Version/s: Impala 4.1.0
(was: Impala 4.2.0)
Resolution: Fixed
This is merged in 4.1.0. Thank [~xqhe] !
> Create single node plan is slow when hundreds of inline views are joined
> ------------------------------------------------------------------------
>
> Key: IMPALA-10806
> URL: https://issues.apache.org/jira/browse/IMPALA-10806
> Project: IMPALA
> Issue Type: Improvement
> Components: Frontend
> Affects Versions: Impala 3.2.0, Impala 4.0.0
> Reporter: Xianqing He
> Assignee: Xianqing He
> Priority: Major
> Fix For: Impala 4.1.0
>
>
> The sql form like
> {code:java}
> select c1 from (select c1, id from view1 where c1>10) t1 join (select c2, id from view2 where c1>10) t2 on t1.id=t2.id join ...{code}
> Query Compilation: 3s642ms
> - Metadata of all 90 tables cached: 1.757ms (1.757ms)
> - Analysis finished: 229.621ms (227.863ms)
> - Authorization finished (noop): 235.024ms (5.402ms)
> - Value transfer graph computed: 275.756ms (40.731ms)
> - Single node plan created: 3s518ms ({color:#FF0000}3s242ms{color})
> - Runtime filters computed: 3s625ms (106.697ms)
> - Distributed plan created: 3s625ms (424.022us)
> - Planning finished: 3s642ms (17.134ms)
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)