javadocAggregate/org/apache/calcite/sql2rel/CorrelateProjectExtractor.html - calcite-site - Git at Google

 <!DOCTYPE HTML>
 <html lang="en">
 <head>
 <!-- Generated by javadoc (17) -->
 <title>CorrelateProjectExtractor (Apache Calcite API)</title>
 <meta name="viewport" content="width=device-width, initial-scale=1">
 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
 <meta name="description" content="declaration: package: org.apache.calcite.sql2rel, class: CorrelateProjectExtractor">
 <meta name="generator" content="javadoc/ClassWriterImpl">
 <link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">
 <link rel="stylesheet" type="text/css" href="../../../../script-dir/jquery-ui.min.css" title="Style">
 <link rel="stylesheet" type="text/css" href="../../../../jquery-ui.overrides.css" title="Style">
 <script type="text/javascript" src="../../../../script.js"></script>
 <script type="text/javascript" src="../../../../script-dir/jquery-3.5.1.min.js"></script>
 <script type="text/javascript" src="../../../../script-dir/jquery-ui.min.js"></script>
 </head>
 <body class="class-declaration-page">
 <script type="text/javascript">var evenRowColor = "even-row-color";
 var oddRowColor = "odd-row-color";
 var tableTab = "table-tab";
 var activeTableTab = "active-table-tab";
 var pathtoroot = "../../../../";
 loadScripts(document, 'script');</script>
 <noscript>
 <div>JavaScript is disabled on your browser.</div>
 </noscript>
 <div class="flex-box">
 <header role="banner" class="flex-header">
 <nav role="navigation">
 <!-- ========= START OF TOP NAVBAR ======= -->
 <div class="top-nav" id="navbar-top">
 <div class="skip-nav"><a href="#skip-navbar-top" title="Skip navigation links">Skip navigation links</a></div>
 <div class="about-language"><b>Apache Calcite</b></div>
 <ul id="navbar-top-firstrow" class="nav-list" title="Navigation">
 <li><a href="../../../../index.html">Overview</a></li>
 <li><a href="package-summary.html">Package</a></li>
 <li class="nav-bar-cell1-rev">Class</li>
 <li><a href="package-tree.html">Tree</a></li>
 <li><a href="../../../../deprecated-list.html">Deprecated</a></li>
 <li><a href="../../../../index-all.html">Index</a></li>
 <li><a href="../../../../help-doc.html#class">Help</a></li>
 </ul>
 </div>
 <div class="sub-nav">
 <div>
 <ul class="sub-nav-list">
 <li>Summary:&nbsp;</li>
 <li>Nested&nbsp;|&nbsp;</li>
 <li><a href="#field-summary">Field</a>&nbsp;|&nbsp;</li>
 <li><a href="#constructor-summary">Constr</a>&nbsp;|&nbsp;</li>
 <li><a href="#method-summary">Method</a></li>
 </ul>
 <ul class="sub-nav-list">
 <li>Detail:&nbsp;</li>
 <li>Field&nbsp;|&nbsp;</li>
 <li><a href="#constructor-detail">Constr</a>&nbsp;|&nbsp;</li>
 <li><a href="#method-detail">Method</a></li>
 </ul>
 </div>
 <div class="nav-list-search"><label for="search-input">SEARCH:</label>
 <input type="text" id="search-input" value="search" disabled="disabled">
 <input type="reset" id="reset-button" value="reset" disabled="disabled">
 </div>
 </div>
 <!-- ========= END OF TOP NAVBAR ========= -->
 <span class="skip-nav" id="skip-navbar-top"></span></nav>
 </header>
 <div class="flex-content">
 <main role="main">
 <!-- ======== START OF CLASS DATA ======== -->
 <div class="header">
 <div class="sub-title"><span class="package-label-in-type">Package</span>&nbsp;<a href="package-summary.html">org.apache.calcite.sql2rel</a></div>
 <h1 title="Class CorrelateProjectExtractor" class="title">Class CorrelateProjectExtractor</h1>
 </div>
 <div class="inheritance" title="Inheritance Tree"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" class="external-link">java.lang.Object</a>
 <div class="inheritance"><a href="../rel/RelShuttleImpl.html" title="class in org.apache.calcite.rel">org.apache.calcite.rel.RelShuttleImpl</a>
 <div class="inheritance"><a href="../rel/RelHomogeneousShuttle.html" title="class in org.apache.calcite.rel">org.apache.calcite.rel.RelHomogeneousShuttle</a>
 <div class="inheritance">org.apache.calcite.sql2rel.CorrelateProjectExtractor</div>
 </div>
 </div>
 </div>
 <section class="class-description" id="class-description">
 <dl class="notes">
 <dt>All Implemented Interfaces:</dt>
 <dd><code><a href="../rel/RelShuttle.html" title="interface in org.apache.calcite.rel">RelShuttle</a></code></dd>
 </dl>
 <hr>
 <div class="type-signature"><span class="annotations">@API(since="1.27",
      status=EXPERIMENTAL)
 </span><span class="modifiers">public final class </span><span class="element-name type-name-label">CorrelateProjectExtractor</span>
 <span class="extends-implements">extends <a href="../rel/RelHomogeneousShuttle.html" title="class in org.apache.calcite.rel">RelHomogeneousShuttle</a></span></div>
 <div class="block">A visitor for relational expressions that extracts a <a href="../rel/core/Project.html" title="class in org.apache.calcite.rel.core"><code>Project</code></a>, with a "simple"
  computation over the correlated variables, from the right side of a correlation
  (<a href="../rel/core/Correlate.html" title="class in org.apache.calcite.rel.core"><code>Correlate</code></a>) and places it on the left side.

  <p>Plan before</p>
  <pre>
  LogicalCorrelate(correlation=[$cor0], joinType=[left], requiredColumns=[{7}])
    LogicalTableScan(table=[[scott, EMP]])
    LogicalFilter(condition=[=($0, +(10, $cor0.DEPTNO))])
      LogicalTableScan(table=[[scott, DEPT]])
  </pre>

  <p>Plan after</p>
  <pre>
  LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3],... DNAME=[$10], LOC=[$11])
    LogicalCorrelate(correlation=[$cor0], joinType=[left], requiredColumns=[{8}])
      LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], ... COMM=[$6], DEPTNO=[$7], $f8=[+(10, $7)])
        LogicalTableScan(table=[[scott, EMP]])
      LogicalFilter(condition=[=($0, $cor0.$f8)])
        LogicalTableScan(table=[[scott, DEPT]])
  </pre>

  <p>Essentially this transformation moves the computation over a correlated expression from the
  inner loop to the outer loop. It materializes the computation on the left side and flattens
  expressions on correlated variables on the right side.</p></div>
 </section>
 <section class="summary">
 <ul class="summary-list">
 <!-- =========== FIELD SUMMARY =========== -->
 <li>
 <section class="field-summary" id="field-summary">
 <h2>Field Summary</h2>
 <div class="inherited-list">
 <h3 id="fields-inherited-from-class-org.apache.calcite.rel.RelShuttleImpl">Fields inherited from class&nbsp;org.apache.calcite.rel.<a href="../rel/RelShuttleImpl.html" title="class in org.apache.calcite.rel">RelShuttleImpl</a></h3>
 <code><a href="../rel/RelShuttleImpl.html#stack">stack</a></code></div>
 </section>
 </li>
 <!-- ======== CONSTRUCTOR SUMMARY ======== -->
 <li>
 <section class="constructor-summary" id="constructor-summary">
 <h2>Constructor Summary</h2>
 <div class="caption"><span>Constructors</span></div>
 <div class="summary-table two-column-summary">
 <div class="table-header col-first">Constructor</div>
 <div class="table-header col-last">Description</div>
 <div class="col-constructor-name even-row-color"><code><a href="#%3Cinit%3E(org.apache.calcite.tools.RelBuilderFactory)" class="member-name-link">CorrelateProjectExtractor</a><wbr>(<a href="../tools/RelBuilderFactory.html" title="interface in org.apache.calcite.tools">RelBuilderFactory</a>&nbsp;factory)</code></div>
 <div class="col-last even-row-color">&nbsp;</div>
 </div>
 </section>
 </li>
 <!-- ========== METHOD SUMMARY =========== -->
 <li>
 <section class="method-summary" id="method-summary">
 <h2>Method Summary</h2>
 <div id="method-summary-table">
 <div class="table-tabs" role="tablist" aria-orientation="horizontal"><button id="method-summary-table-tab0" role="tab" aria-selected="true" aria-controls="method-summary-table.tabpanel" tabindex="0" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table', 3)" class="active-table-tab">All Methods</button><button id="method-summary-table-tab2" role="tab" aria-selected="false" aria-controls="method-summary-table.tabpanel" tabindex="-1" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table-tab2', 3)" class="table-tab">Instance Methods</button><button id="method-summary-table-tab4" role="tab" aria-selected="false" aria-controls="method-summary-table.tabpanel" tabindex="-1" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table-tab4', 3)" class="table-tab">Concrete Methods</button></div>
 <div id="method-summary-table.tabpanel" role="tabpanel">
 <div class="summary-table three-column-summary" aria-labelledby="method-summary-table-tab0">
 <div class="table-header col-first">Modifier and Type</div>
 <div class="table-header col-second">Method</div>
 <div class="table-header col-last">Description</div>
 <div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="../rel/RelNode.html" title="interface in org.apache.calcite.rel">RelNode</a></code></div>
 <div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#visit(org.apache.calcite.rel.logical.LogicalCorrelate)" class="member-name-link">visit</a><wbr>(<a href="../rel/logical/LogicalCorrelate.html" title="class in org.apache.calcite.rel.logical">LogicalCorrelate</a>&nbsp;correlate)</code></div>
 <div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4">&nbsp;</div>
 </div>
 </div>
 </div>
 <div class="inherited-list">
 <h3 id="methods-inherited-from-class-org.apache.calcite.rel.RelHomogeneousShuttle">Methods inherited from class&nbsp;org.apache.calcite.rel.<a href="../rel/RelHomogeneousShuttle.html" title="class in org.apache.calcite.rel">RelHomogeneousShuttle</a></h3>
 <code><a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.core.TableFunctionScan)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.core.TableScan)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalAggregate)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalCalc)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalExchange)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalFilter)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalIntersect)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalJoin)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalMatch)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalMinus)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalProject)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalSort)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalTableModify)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalUnion)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalValues)">visit</a></code></div>
 <div class="inherited-list">
 <h3 id="methods-inherited-from-class-org.apache.calcite.rel.RelShuttleImpl">Methods inherited from class&nbsp;org.apache.calcite.rel.<a href="../rel/RelShuttleImpl.html" title="class in org.apache.calcite.rel">RelShuttleImpl</a></h3>
 <code><a href="../rel/RelShuttleImpl.html#visit(org.apache.calcite.rel.RelNode)">visit</a>, <a href="../rel/RelShuttleImpl.html#visitChild(org.apache.calcite.rel.RelNode,int,org.apache.calcite.rel.RelNode)">visitChild</a>, <a href="../rel/RelShuttleImpl.html#visitChildren(org.apache.calcite.rel.RelNode)">visitChildren</a></code></div>
 <div class="inherited-list">
 <h3 id="methods-inherited-from-class-java.lang.Object">Methods inherited from class&nbsp;java.lang.<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" class="external-link">Object</a></h3>
 <code><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#clone()" title="class or interface in java.lang" class="external-link">clone</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#equals(java.lang.Object)" title="class or interface in java.lang" class="external-link">equals</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#finalize()" title="class or interface in java.lang" class="external-link">finalize</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#getClass()" title="class or interface in java.lang" class="external-link">getClass</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#hashCode()" title="class or interface in java.lang" class="external-link">hashCode</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#notify()" title="class or interface in java.lang" class="external-link">notify</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#notifyAll()" title="class or interface in java.lang" class="external-link">notifyAll</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#toString()" title="class or interface in java.lang" class="external-link">toString</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#wait()" title="class or interface in java.lang" class="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#wait(long)" title="class or interface in java.lang" class="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#wait(long,int)" title="class or interface in java.lang" class="external-link">wait</a></code></div>
 </section>
 </li>
 </ul>
 </section>
 <section class="details">
 <ul class="details-list">
 <!-- ========= CONSTRUCTOR DETAIL ======== -->
 <li>
 <section class="constructor-details" id="constructor-detail">
 <h2>Constructor Details</h2>
 <ul class="member-list">
 <li>
 <section class="detail" id="&lt;init&gt;(org.apache.calcite.tools.RelBuilderFactory)">
 <h3>CorrelateProjectExtractor</h3>
 <div class="member-signature"><span class="modifiers">public</span>&nbsp;<span class="element-name">CorrelateProjectExtractor</span><wbr><span class="parameters">(<a href="../tools/RelBuilderFactory.html" title="interface in org.apache.calcite.tools">RelBuilderFactory</a>&nbsp;factory)</span></div>
 </section>
 </li>
 </ul>
 </section>
 </li>
 <!-- ============ METHOD DETAIL ========== -->
 <li>
 <section class="method-details" id="method-detail">
 <h2>Method Details</h2>
 <ul class="member-list">
 <li>
 <section class="detail" id="visit(org.apache.calcite.rel.logical.LogicalCorrelate)">
 <h3>visit</h3>
 <div class="member-signature"><span class="modifiers">public</span>&nbsp;<span class="return-type"><a href="../rel/RelNode.html" title="interface in org.apache.calcite.rel">RelNode</a></span>&nbsp;<span class="element-name">visit</span><wbr><span class="parameters">(<a href="../rel/logical/LogicalCorrelate.html" title="class in org.apache.calcite.rel.logical">LogicalCorrelate</a>&nbsp;correlate)</span></div>
 <dl class="notes">
 <dt>Specified by:</dt>
 <dd><code><a href="../rel/RelShuttle.html#visit(org.apache.calcite.rel.logical.LogicalCorrelate)">visit</a></code>&nbsp;in interface&nbsp;<code><a href="../rel/RelShuttle.html" title="interface in org.apache.calcite.rel">RelShuttle</a></code></dd>
 <dt>Overrides:</dt>
 <dd><code><a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalCorrelate)">visit</a></code>&nbsp;in class&nbsp;<code><a href="../rel/RelHomogeneousShuttle.html" title="class in org.apache.calcite.rel">RelHomogeneousShuttle</a></code></dd>
 </dl>
 </section>
 </li>
 </ul>
 </section>
 </li>
 </ul>
 </section>
 <!-- ========= END OF CLASS DATA ========= -->
 </main>
 <footer role="contentinfo">
 <hr>
 <p class="legal-copy"><small>Copyright &copy; 2012-2023 Apache Software Foundation. All Rights Reserved.</small></p>
 </footer>
 </div>
 </div>
 </body>
 </html>
	<!DOCTYPE HTML>
	<html lang="en">
	<head>
	<!-- Generated by javadoc (17) -->
	<title>CorrelateProjectExtractor (Apache Calcite API)</title>
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
	<meta name="description" content="declaration: package: org.apache.calcite.sql2rel, class: CorrelateProjectExtractor">
	<meta name="generator" content="javadoc/ClassWriterImpl">
	<link rel="stylesheet" type="text/css" href="../../../../stylesheet.css" title="Style">
	<link rel="stylesheet" type="text/css" href="../../../../script-dir/jquery-ui.min.css" title="Style">
	<link rel="stylesheet" type="text/css" href="../../../../jquery-ui.overrides.css" title="Style">
	<script type="text/javascript" src="../../../../script.js"></script>
	<script type="text/javascript" src="../../../../script-dir/jquery-3.5.1.min.js"></script>
	<script type="text/javascript" src="../../../../script-dir/jquery-ui.min.js"></script>
	</head>
	<body class="class-declaration-page">
	<script type="text/javascript">var evenRowColor = "even-row-color";
	var oddRowColor = "odd-row-color";
	var tableTab = "table-tab";
	var activeTableTab = "active-table-tab";
	var pathtoroot = "../../../../";
	loadScripts(document, 'script');</script>
	<noscript>
	<div>JavaScript is disabled on your browser.</div>
	</noscript>
	<div class="flex-box">
	<header role="banner" class="flex-header">
	<nav role="navigation">
	<!-- ========= START OF TOP NAVBAR ======= -->
	<div class="top-nav" id="navbar-top">
	<div class="skip-nav"><a href="#skip-navbar-top" title="Skip navigation links">Skip navigation links</a></div>
	<div class="about-language"><b>Apache Calcite</b></div>
	<ul id="navbar-top-firstrow" class="nav-list" title="Navigation">
	<li><a href="../../../../index.html">Overview</a></li>
	<li><a href="package-summary.html">Package</a></li>
	<li class="nav-bar-cell1-rev">Class</li>
	<li><a href="package-tree.html">Tree</a></li>
	<li><a href="../../../../deprecated-list.html">Deprecated</a></li>
	<li><a href="../../../../index-all.html">Index</a></li>
	<li><a href="../../../../help-doc.html#class">Help</a></li>
	</ul>
	</div>
	<div class="sub-nav">
	<div>
	<ul class="sub-nav-list">
	<li>Summary: </li>
	<li>Nested \| </li>
	<li><a href="#field-summary">Field</a> \| </li>
	<li><a href="#constructor-summary">Constr</a> \| </li>
	<li><a href="#method-summary">Method</a></li>
	</ul>
	<ul class="sub-nav-list">
	<li>Detail: </li>
	<li>Field \| </li>
	<li><a href="#constructor-detail">Constr</a> \| </li>
	<li><a href="#method-detail">Method</a></li>
	</ul>
	</div>
	<div class="nav-list-search"><label for="search-input">SEARCH:</label>
	<input type="text" id="search-input" value="search" disabled="disabled">
	<input type="reset" id="reset-button" value="reset" disabled="disabled">
	</div>
	</div>
	<!-- ========= END OF TOP NAVBAR ========= -->
	<span class="skip-nav" id="skip-navbar-top"></span></nav>
	</header>
	<div class="flex-content">
	<main role="main">
	<!-- ======== START OF CLASS DATA ======== -->
	<div class="header">
	<div class="sub-title"><span class="package-label-in-type">Package</span> <a href="package-summary.html">org.apache.calcite.sql2rel</a></div>
	<h1 title="Class CorrelateProjectExtractor" class="title">Class CorrelateProjectExtractor</h1>
	</div>
	<div class="inheritance" title="Inheritance Tree"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" class="external-link">java.lang.Object</a>
	<div class="inheritance"><a href="../rel/RelShuttleImpl.html" title="class in org.apache.calcite.rel">org.apache.calcite.rel.RelShuttleImpl</a>
	<div class="inheritance"><a href="../rel/RelHomogeneousShuttle.html" title="class in org.apache.calcite.rel">org.apache.calcite.rel.RelHomogeneousShuttle</a>
	<div class="inheritance">org.apache.calcite.sql2rel.CorrelateProjectExtractor</div>
	</div>
	</div>
	</div>
	<section class="class-description" id="class-description">
	<dl class="notes">
	<dt>All Implemented Interfaces:</dt>
	<dd><code><a href="../rel/RelShuttle.html" title="interface in org.apache.calcite.rel">RelShuttle</a></code></dd>
	</dl>
	<hr>
	<div class="type-signature"><span class="annotations">@API(since="1.27",
	status=EXPERIMENTAL)
	</span><span class="modifiers">public final class </span><span class="element-name type-name-label">CorrelateProjectExtractor</span>
	<span class="extends-implements">extends <a href="../rel/RelHomogeneousShuttle.html" title="class in org.apache.calcite.rel">RelHomogeneousShuttle</a></span></div>
	<div class="block">A visitor for relational expressions that extracts a <a href="../rel/core/Project.html" title="class in org.apache.calcite.rel.core"><code>Project</code></a>, with a "simple"
	computation over the correlated variables, from the right side of a correlation
	(<a href="../rel/core/Correlate.html" title="class in org.apache.calcite.rel.core"><code>Correlate</code></a>) and places it on the left side.

	<p>Plan before</p>
	<pre>
	LogicalCorrelate(correlation=[$cor0], joinType=[left], requiredColumns=[{7}])
	LogicalTableScan(table=[[scott, EMP]])
	LogicalFilter(condition=[=($0, +(10, $cor0.DEPTNO))])
	LogicalTableScan(table=[[scott, DEPT]])
	</pre>

	<p>Plan after</p>
	<pre>
	LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3],... DNAME=[$10], LOC=[$11])
	LogicalCorrelate(correlation=[$cor0], joinType=[left], requiredColumns=[{8}])
	LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], ... COMM=[$6], DEPTNO=[$7], $f8=[+(10, $7)])
	LogicalTableScan(table=[[scott, EMP]])
	LogicalFilter(condition=[=($0, $cor0.$f8)])
	LogicalTableScan(table=[[scott, DEPT]])
	</pre>

	<p>Essentially this transformation moves the computation over a correlated expression from the
	inner loop to the outer loop. It materializes the computation on the left side and flattens
	expressions on correlated variables on the right side.</p></div>
	</section>
	<section class="summary">
	<ul class="summary-list">
	<!-- =========== FIELD SUMMARY =========== -->
	<li>
	<section class="field-summary" id="field-summary">
	<h2>Field Summary</h2>
	<div class="inherited-list">
	<h3 id="fields-inherited-from-class-org.apache.calcite.rel.RelShuttleImpl">Fields inherited from class org.apache.calcite.rel.<a href="../rel/RelShuttleImpl.html" title="class in org.apache.calcite.rel">RelShuttleImpl</a></h3>
	<code><a href="../rel/RelShuttleImpl.html#stack">stack</a></code></div>
	</section>
	</li>
	<!-- ======== CONSTRUCTOR SUMMARY ======== -->
	<li>
	<section class="constructor-summary" id="constructor-summary">
	<h2>Constructor Summary</h2>
	<div class="caption"><span>Constructors</span></div>
	<div class="summary-table two-column-summary">
	<div class="table-header col-first">Constructor</div>
	<div class="table-header col-last">Description</div>
	<div class="col-constructor-name even-row-color"><code><a href="#%3Cinit%3E(org.apache.calcite.tools.RelBuilderFactory)" class="member-name-link">CorrelateProjectExtractor</a><wbr>(<a href="../tools/RelBuilderFactory.html" title="interface in org.apache.calcite.tools">RelBuilderFactory</a> factory)</code></div>
	<div class="col-last even-row-color"> </div>
	</div>
	</section>
	</li>
	<!-- ========== METHOD SUMMARY =========== -->
	<li>
	<section class="method-summary" id="method-summary">
	<h2>Method Summary</h2>
	<div id="method-summary-table">
	<div class="table-tabs" role="tablist" aria-orientation="horizontal"><button id="method-summary-table-tab0" role="tab" aria-selected="true" aria-controls="method-summary-table.tabpanel" tabindex="0" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table', 3)" class="active-table-tab">All Methods</button><button id="method-summary-table-tab2" role="tab" aria-selected="false" aria-controls="method-summary-table.tabpanel" tabindex="-1" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table-tab2', 3)" class="table-tab">Instance Methods</button><button id="method-summary-table-tab4" role="tab" aria-selected="false" aria-controls="method-summary-table.tabpanel" tabindex="-1" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table-tab4', 3)" class="table-tab">Concrete Methods</button></div>
	<div id="method-summary-table.tabpanel" role="tabpanel">
	<div class="summary-table three-column-summary" aria-labelledby="method-summary-table-tab0">
	<div class="table-header col-first">Modifier and Type</div>
	<div class="table-header col-second">Method</div>
	<div class="table-header col-last">Description</div>
	<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="../rel/RelNode.html" title="interface in org.apache.calcite.rel">RelNode</a></code></div>
	<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"><code><a href="#visit(org.apache.calcite.rel.logical.LogicalCorrelate)" class="member-name-link">visit</a><wbr>(<a href="../rel/logical/LogicalCorrelate.html" title="class in org.apache.calcite.rel.logical">LogicalCorrelate</a> correlate)</code></div>
	<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab4"> </div>
	</div>
	</div>
	</div>
	<div class="inherited-list">
	<h3 id="methods-inherited-from-class-org.apache.calcite.rel.RelHomogeneousShuttle">Methods inherited from class org.apache.calcite.rel.<a href="../rel/RelHomogeneousShuttle.html" title="class in org.apache.calcite.rel">RelHomogeneousShuttle</a></h3>
	<code><a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.core.TableFunctionScan)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.core.TableScan)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalAggregate)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalCalc)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalExchange)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalFilter)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalIntersect)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalJoin)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalMatch)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalMinus)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalProject)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalSort)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalTableModify)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalUnion)">visit</a>, <a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalValues)">visit</a></code></div>
	<div class="inherited-list">
	<h3 id="methods-inherited-from-class-org.apache.calcite.rel.RelShuttleImpl">Methods inherited from class org.apache.calcite.rel.<a href="../rel/RelShuttleImpl.html" title="class in org.apache.calcite.rel">RelShuttleImpl</a></h3>
	<code><a href="../rel/RelShuttleImpl.html#visit(org.apache.calcite.rel.RelNode)">visit</a>, <a href="../rel/RelShuttleImpl.html#visitChild(org.apache.calcite.rel.RelNode,int,org.apache.calcite.rel.RelNode)">visitChild</a>, <a href="../rel/RelShuttleImpl.html#visitChildren(org.apache.calcite.rel.RelNode)">visitChildren</a></code></div>
	<div class="inherited-list">
	<h3 id="methods-inherited-from-class-java.lang.Object">Methods inherited from class java.lang.<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html" title="class or interface in java.lang" class="external-link">Object</a></h3>
	<code><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#clone()" title="class or interface in java.lang" class="external-link">clone</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#equals(java.lang.Object)" title="class or interface in java.lang" class="external-link">equals</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#finalize()" title="class or interface in java.lang" class="external-link">finalize</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#getClass()" title="class or interface in java.lang" class="external-link">getClass</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#hashCode()" title="class or interface in java.lang" class="external-link">hashCode</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#notify()" title="class or interface in java.lang" class="external-link">notify</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#notifyAll()" title="class or interface in java.lang" class="external-link">notifyAll</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#toString()" title="class or interface in java.lang" class="external-link">toString</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#wait()" title="class or interface in java.lang" class="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#wait(long)" title="class or interface in java.lang" class="external-link">wait</a>, <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/Object.html#wait(long,int)" title="class or interface in java.lang" class="external-link">wait</a></code></div>
	</section>
	</li>
	</ul>
	</section>
	<section class="details">
	<ul class="details-list">
	<!-- ========= CONSTRUCTOR DETAIL ======== -->
	<li>
	<section class="constructor-details" id="constructor-detail">
	<h2>Constructor Details</h2>
	<ul class="member-list">
	<li>
	<section class="detail" id="<init>(org.apache.calcite.tools.RelBuilderFactory)">
	<h3>CorrelateProjectExtractor</h3>
	<div class="member-signature"><span class="modifiers">public</span> <span class="element-name">CorrelateProjectExtractor</span><wbr><span class="parameters">(<a href="../tools/RelBuilderFactory.html" title="interface in org.apache.calcite.tools">RelBuilderFactory</a> factory)</span></div>
	</section>
	</li>
	</ul>
	</section>
	</li>
	<!-- ============ METHOD DETAIL ========== -->
	<li>
	<section class="method-details" id="method-detail">
	<h2>Method Details</h2>
	<ul class="member-list">
	<li>
	<section class="detail" id="visit(org.apache.calcite.rel.logical.LogicalCorrelate)">
	<h3>visit</h3>
	<div class="member-signature"><span class="modifiers">public</span> <span class="return-type"><a href="../rel/RelNode.html" title="interface in org.apache.calcite.rel">RelNode</a></span> <span class="element-name">visit</span><wbr><span class="parameters">(<a href="../rel/logical/LogicalCorrelate.html" title="class in org.apache.calcite.rel.logical">LogicalCorrelate</a> correlate)</span></div>
	<dl class="notes">
	<dt>Specified by:</dt>
	<dd><code><a href="../rel/RelShuttle.html#visit(org.apache.calcite.rel.logical.LogicalCorrelate)">visit</a></code> in interface <code><a href="../rel/RelShuttle.html" title="interface in org.apache.calcite.rel">RelShuttle</a></code></dd>
	<dt>Overrides:</dt>
	<dd><code><a href="../rel/RelHomogeneousShuttle.html#visit(org.apache.calcite.rel.logical.LogicalCorrelate)">visit</a></code> in class <code><a href="../rel/RelHomogeneousShuttle.html" title="class in org.apache.calcite.rel">RelHomogeneousShuttle</a></code></dd>
	</dl>
	</section>
	</li>
	</ul>
	</section>
	</li>
	</ul>
	</section>
	<!-- ========= END OF CLASS DATA ========= -->
	</main>
	<footer role="contentinfo">
	<hr>
	<p class="legal-copy"><small>Copyright © 2012-2023 Apache Software Foundation. All Rights Reserved.</small></p>
	</footer>
	</div>
	</div>
	</body>
	</html>