/*
* Licensed to CRATE Technology GmbH ("Crate") under one or more contributor
* license agreements. See the NOTICE file distributed with this work for
* additional information regarding copyright ownership. Crate licenses
* this file to you under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License. You may
* obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
* WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
* License for the specific language governing permissions and limitations
* under the License.
*
* However, if you have executed another commercial license agreement
* with Crate these terms will supersede the license and you may use the
* software solely pursuant to the terms of the relevant commercial agreement.
*/
package io.crate.planner.node.dql.join;
import io.crate.planner.Plan;
import io.crate.planner.PlanVisitor;
import io.crate.planner.PositionalOrderBy;
import io.crate.planner.ResultDescription;
import io.crate.planner.distribution.DistributionInfo;
import io.crate.planner.projection.Projection;
import io.crate.types.DataType;
import javax.annotation.Nullable;
import java.util.Collection;
import java.util.List;
import java.util.UUID;
/**
* Plan that will be executed with the awesome nested loop algorithm
* performing CROSS JOINs
* <p>
* This Plan makes a lot of assumptions:
* <p>
* <ul>
* <li> limit and offset are already pushed down to left and right plan nodes
* <li> where clause is already splitted to left and right plan nodes
* <li> order by symbols are already splitted, too
* <li> if the first order by symbol in the whole statement is from the left node,
* set <code>leftOuterLoop</code> to true, otherwise to false
* <p>
* </ul>
* <p>
* Properties:
* <p>
* <ul>
* <li> the resulting outputs from the join operations are the same, no matter if
* <code>leftOuterLoop</code> is true or not - so the projections added,
* can assume the same order of symbols, first symbols from left, then from right.
* If sth. else is selected a projection has to reorder those.
*/
public class NestedLoop implements Plan, ResultDescription {
private final Plan left;
private final Plan right;
private final NestedLoopPhase nestedLoopPhase;
private int limit;
private int offset;
private int numOutputs;
private final int maxRowsPerNode;
@Nullable
private PositionalOrderBy orderBy;
private final UUID jobId;
/**
* create a new NestedLoop
* <p>
* side in the outer loop, the right in the inner.
* Resulting in rows like:
* <p>
* a | 1
* a | 2
* a | 3
* b | 1
* b | 2
* b | 3
* <p>
* This is the case if the left relation is referenced
* by the first order by symbol references. E.g.
* for <code>ORDER BY left.a, right.b</code>
* If false, the nested loop is executed the other way around.
* With the following results:
* <p>
* a | 1
* b | 1
* a | 2
* b | 2
* a | 3
* b | 3
*/
public NestedLoop(NestedLoopPhase nestedLoopPhase,
Plan left,
Plan right,
int limit,
int offset,
int maxRowsPerNode,
int numOutputs,
@Nullable PositionalOrderBy orderBy) {
this.jobId = nestedLoopPhase.jobId();
this.left = left;
this.right = right;
this.nestedLoopPhase = nestedLoopPhase;
this.limit = limit;
this.offset = offset;
this.maxRowsPerNode = maxRowsPerNode;
this.orderBy = orderBy;
this.numOutputs = numOutputs;
}
public Plan left() {
return left;
}
public Plan right() {
return right;
}
public NestedLoopPhase nestedLoopPhase() {
return nestedLoopPhase;
}
@Override
public ResultDescription resultDescription() {
return this;
}
@Override
public void setDistributionInfo(DistributionInfo distributionInfo) {
nestedLoopPhase.distributionInfo(distributionInfo);
}
@Override
public <C, R> R accept(PlanVisitor<C, R> visitor, C context) {
return visitor.visitNestedLoop(this, context);
}
@Override
public UUID jobId() {
return jobId;
}
@Override
public void addProjection(Projection projection,
@Nullable Integer newLimit,
@Nullable Integer newOffset,
@Nullable PositionalOrderBy newOrderBy) {
nestedLoopPhase.addProjection(projection);
if (newLimit != null) {
limit = newLimit;
}
if (newOffset != null) {
offset = newOffset;
}
if (newOrderBy != null) {
orderBy = newOrderBy;
}
numOutputs = projection.outputs().size();
}
@Override
public Collection<String> nodeIds() {
return nestedLoopPhase.nodeIds();
}
@Nullable
@Override
public PositionalOrderBy orderBy() {
return orderBy;
}
@Override
public int limit() {
return limit;
}
@Override
public int maxRowsPerNode() {
return maxRowsPerNode;
}
@Override
public int offset() {
return offset;
}
@Override
public int numOutputs() {
return numOutputs;
}
@Override
public List<DataType> streamOutputs() {
return nestedLoopPhase.outputTypes();
}
}