[jira] [Updated] (IMPALA-10806) Create single node plan is slow when hundreds of inline views are joined

["Zoltán Borók-Nagy (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-10806?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Zoltán Borók-Nagy updated IMPALA-10806:
---------------------------------------
    Fix Version/s: Impala 4.2.0
                       (was: Impala 4.1.0)

> 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.2.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.7#820007)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org