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

MATERIALIZE a subquery hint

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Open
    • Major
    • Resolution: Unresolved
    • Impala 3.0, Impala 2.12.0
    • None
    • Frontend

    Description

      Would also be great to implement MATERIALIZE hint as in Oracle too.

      https://oracle-base.com/articles/misc/with-clause#materialize-hint

      Basically in Oracle we could run WITH subqueries that will be persisted for the duration of the query, so if that subquery is used multiple times in outer query, a heavy join or any other operation has to run only once. 

      Attachments

        Issue Links

          is blocked by

          Improvement - An improvement or enhancement to an existing feature or task. IMPALA-7112 Change from tree-execution to a dag-execution model

          • Major - Major loss of function.
          • Open
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. IMPALA-8083 Materialize sub parts of query that is used in multiple times in a query

          • Major - Major loss of function.
          • Open

          Activity

            People

              Unassigned Unassigned
              Tagar Ruslan Dautkhanov
              Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated: