org.apache.calcite.rel.rules

Class SubQueryRemoveRule

java.lang.Object

org.apache.calcite.plan.RelOptRule

org.apache.calcite.rel.rules.SubQueryRemoveRule

Direct Known Subclasses:

SubQueryRemoveRule.SubQueryFilterRemoveRule, SubQueryRemoveRule.SubQueryJoinRemoveRule, SubQueryRemoveRule.SubQueryProjectRemoveRule

public abstract class SubQueryRemoveRule
extends RelOptRule

Transform that converts IN, EXISTS and scalar sub-queries into joins.

Sub-queries are represented by RexSubQuery expressions.

A sub-query may or may not be correlated. If a sub-query is correlated, the wrapped RelNode will contain a RexCorrelVariable before the rewrite, and the product of the rewrite will be a Correlate. The Correlate can be removed using RelDecorrelator.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	SubQueryRemoveRule.SubQueryFilterRemoveRule Rule that converts a sub-queries from filter expressions into Correlate instances.
static class	SubQueryRemoveRule.SubQueryJoinRemoveRule Rule that converts sub-queries from join expressions into Correlate instances.
static class	SubQueryRemoveRule.SubQueryProjectRemoveRule Rule that converts sub-queries from project expressions into Correlate instances.

Field Summary

Fields

Modifier and Type	Field and Description
static SubQueryRemoveRule	FILTER
static SubQueryRemoveRule	JOIN
static SubQueryRemoveRule	PROJECT

Fields inherited from class org.apache.calcite.plan.RelOptRule

description, operands, relBuilderFactory

Constructor Summary

Constructors

Constructor and Description
SubQueryRemoveRule(RelOptRuleOperand operand, RelBuilderFactory relBuilderFactory, java.lang.String description) Creates a SubQueryRemoveRule.

Method Summary

Modifier and Type	Method and Description
protected RexNode	apply(RexSubQuery e, java.util.Set<CorrelationId> variablesSet, RelOptUtil.Logic logic, RelBuilder builder, int inputCount, int offset)

Methods inherited from class org.apache.calcite.plan.RelOptRule

any, convert, convert, convertList, convertOperand, convertOperand, equals, equals, getOperand, getOperands, getOutConvention, getOutTrait, hashCode, matches, none, onMatch, operand, operand, operand, operand, operand, operandJ, operandJ, some, toString, unordered

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Field Detail

PROJECT

public static final SubQueryRemoveRule PROJECT

FILTER

public static final SubQueryRemoveRule FILTER

JOIN

public static final SubQueryRemoveRule JOIN

Constructor Detail

SubQueryRemoveRule

public SubQueryRemoveRule(RelOptRuleOperand operand,
                          RelBuilderFactory relBuilderFactory,
                          java.lang.String description)

Creates a SubQueryRemoveRule.

Parameters:

operand - root operand, must not be null

description - Description, or null to guess description

relBuilderFactory - Builder for relational expressions

Method Detail

apply

protected RexNode apply(RexSubQuery e,
                        java.util.Set<CorrelationId> variablesSet,
                        RelOptUtil.Logic logic,
                        RelBuilder builder,
                        int inputCount,
                        int offset)