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

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 3.2.0, Impala 4.0.0
• Fix Version/s: Impala 4.1.0
• Component/s: Frontend
• Epic Color: ghx-label-14
• Assignee: Xianqing He
• Reporter: Xianqing He
• Created: 19/Jul/21 11:46
• Updated: 29/Jul/22 09:09
• Resolved: 29/Jul/22 09:09

Description

The sql form like

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 ...

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 (3s242ms)
• Runtime filters computed: 3s625ms (106.697ms)
• Distributed plan created: 3s625ms (424.022us)
• Planning finished: 3s642ms (17.134ms)