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

["Xianqing He (Jira)" <ji...@apache.org>]

Xianqing He created IMPALA-10806:
------------------------------------

             Summary: 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 4.0, Impala 3.2.0
            Reporter: Xianqing He
            Assignee: Xianqing He
             Fix For: Impala 4.1


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.3.4#803005)

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