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

MATERIALIZE a subquery hint

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: Impala 3.0, Impala 2.12.0
    • Fix Version/s: None
    • Component/s: Frontend
    • Labels:

      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

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                Tagar Ruslan Dautkhanov
              • Votes:
                2 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: