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

Query slowdown with inline views and hundreds of columns

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • Impala 3.2.0
    • Impala 3.4.0
    • Frontend
    • None
    • ghx-label-1

    Description

      IMPALA-8386 introduced an expensive precondition check using the function ExprSubstitutionMap.checkComposedFrom(). This check has significant performance impact on statements that contain inline views with hundreds of columns. This check needs to be made more efficient to avoid exponential slowdowns with many columns.

      Attachments

        Issue Links

          is caused by

          Bug - A problem which impairs or prevents the functions of the product. IMPALA-8386 Incorrect predicate in a left outer join query

          • Critical - Crashes, loss of data, severe memory leak.
          • Resolved
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. IMPALA-10799 Analysis slowdown with inline views and thousands of column

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              kdeschle Kurt Deschler
              kdeschle Kurt Deschler
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: