/*
* Licensed 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.
*/
package com.facebook.presto.sql.planner.optimizations;
import com.facebook.presto.Session;
import com.facebook.presto.spi.type.Type;
import com.facebook.presto.sql.planner.PlanNodeIdAllocator;
import com.facebook.presto.sql.planner.Symbol;
import com.facebook.presto.sql.planner.SymbolAllocator;
import com.facebook.presto.sql.planner.plan.ApplyNode;
import com.facebook.presto.sql.planner.plan.PlanNode;
import com.facebook.presto.sql.planner.plan.SemiJoinNode;
import com.facebook.presto.sql.planner.plan.SimplePlanRewriter;
import com.facebook.presto.sql.tree.Expression;
import com.facebook.presto.sql.tree.InPredicate;
import java.util.Map;
import java.util.Optional;
import static com.facebook.presto.sql.planner.plan.SimplePlanRewriter.rewriteWith;
import static com.google.common.collect.Iterables.getOnlyElement;
import static java.util.Objects.requireNonNull;
/**
* This optimizers looks for InPredicate expressions in ApplyNodes and replaces the nodes with SemiJoin nodes.
* <p/>
* Plan before optimizer:
* <pre>
* Filter(a IN b):
* Apply
* - correlation: [] // empty
* - input: some plan A producing symbol a
* - subquery: some plan B producing symbol b
* </pre>
* <p/>
* Plan after optimizer:
* <pre>
* Filter(semijoinresult):
* SemiJoin
* - source: plan A
* - filteringSource: symbol a
* - sourceJoinSymbol: plan B
* - filteringSourceJoinSymbol: symbol b
* - semiJoinOutput: semijoinresult
* </pre>
*/
public class TransformUncorrelatedInPredicateSubqueryToSemiJoin
implements PlanOptimizer
{
@Override
public PlanNode optimize(PlanNode plan, Session session, Map<Symbol, Type> types, SymbolAllocator symbolAllocator, PlanNodeIdAllocator idAllocator)
{
return rewriteWith(new InPredicateRewriter(idAllocator), plan, null);
}
/**
* Each ApplyNode which contains InPredicate is replaced by semi join node.
*/
private static class InPredicateRewriter
extends SimplePlanRewriter<Void>
{
private final PlanNodeIdAllocator idAllocator;
public InPredicateRewriter(PlanNodeIdAllocator idAllocator)
{
this.idAllocator = requireNonNull(idAllocator, "idAllocator is null");
}
@Override
public PlanNode visitApply(ApplyNode node, RewriteContext<Void> context)
{
if (!node.getCorrelation().isEmpty()) {
return context.defaultRewrite(node);
}
if (node.getSubqueryAssignments().size() != 1) {
return context.defaultRewrite(node);
}
Expression expression = getOnlyElement(node.getSubqueryAssignments().getExpressions());
if (!(expression instanceof InPredicate)) {
return context.defaultRewrite(node);
}
PlanNode input = context.rewrite(node.getInput());
PlanNode subquery = context.rewrite(node.getSubquery());
InPredicate inPredicate = (InPredicate) expression;
Symbol semiJoinSymbol = getOnlyElement(node.getSubqueryAssignments().getSymbols());
return new SemiJoinNode(idAllocator.getNextId(),
input,
subquery,
Symbol.from(inPredicate.getValue()),
Symbol.from(inPredicate.getValueList()),
semiJoinSymbol,
Optional.empty(),
Optional.empty(),
Optional.empty()
);
}
}
}