[
https://issues.apache.org/jira/browse/IMPALA-7114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Greg Rahn updated IMPALA-7114:
------------------------------
Labels: hints optimizer (was: hints materializedviews optimizer)
> 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 3.0, Impala 2.12.0
> Reporter: Ruslan Dautkhanov
> Priority: Major
> Labels: hints, optimizer
>
> 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)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org
