You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@impala.apache.org by "Ruslan Dautkhanov (JIRA)" <ji...@apache.org> on 2018/06/01 20:39:00 UTC

[jira] [Created] (IMPALA-7114) MATERIALIZE a subquery hint

Ruslan Dautkhanov created IMPALA-7114:
-----------------------------------------

             Summary: MATERIALIZE a subquery hint
                 Key: IMPALA-7114
                 URL: https://issues.apache.org/jira/browse/IMPALA-7114
             Project: IMPALA
          Issue Type: New Feature
    Affects Versions: Impala 2.12.0, Impala 3.0
            Reporter: Ruslan Dautkhanov


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. 




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)