Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-10806

Create single node plan is slow when hundreds of inline views are joined

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: Impala 3.2.0, Impala 4.0.0
    • Fix Version/s: Impala 4.1.0
    • Component/s: Frontend
    • Labels:
      None
    • Epic Color:
      ghx-label-14

      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)

       

        Attachments

          Activity

            People

            • Assignee:
              xqhe Xianqing He
              Reporter:
              xqhe Xianqing He
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: