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)
