Package org.apache.calcite.rel.rules

Class IntersectToDistinctRule

java.lang.Object

org.apache.calcite.plan.RelOptRule

org.apache.calcite.plan.RelRule<IntersectToDistinctRule.Config>

org.apache.calcite.rel.rules.IntersectToDistinctRule

All Implemented Interfaces:

TransformationRule

@Enclosing
public class IntersectToDistinctRule
extends RelRule<IntersectToDistinctRule.Config>
implements TransformationRule

Planner rule that translates a distinct Intersect (all = false) into a group of operators composed of Union, Aggregate, etc.

The rule has a configuration option to control whether it should also perform a (partial) aggregation pushdown in the union branches (default behavior).

See Also:

• UnionToDistinctRule
• CoreRules.INTERSECT_TO_DISTINCT
• CoreRules.INTERSECT_TO_DISTINCT_NO_AGGREGATE_PUSHDOWN

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static interface	IntersectToDistinctRule.Config	Rule configuration.

Nested classes/interfaces inherited from class org.apache.calcite.plan.RelRule

RelRule.Done, RelRule.MatchHandler<R extends RelOptRule>, RelRule.OperandBuilder, RelRule.OperandDetailBuilder<R extends RelNode>, RelRule.OperandTransform

Nested classes/interfaces inherited from class org.apache.calcite.plan.RelOptRule

RelOptRule.ConverterRelOptRuleOperand

Field Summary

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

config

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

description, operands, relBuilderFactory

Constructor Summary

Constructors

Modifier	Constructor	Description
	IntersectToDistinctRule(Class<? extends Intersect> intersectClass, RelBuilderFactory relBuilderFactory)	Deprecated.
protected	IntersectToDistinctRule(IntersectToDistinctRule.Config config)	Creates an IntersectToDistinctRule.

Method Summary

Modifier and Type	Method	Description
void	onMatch(RelOptRuleCall call)	Receives notification about a rule match.
void	onMatchAggregateOnUnion(RelOptRuleCall call)	Variant not performing a partial aggregation pushdown.
void	onMatchAggregatePushdown(RelOptRuleCall call)	Variant performing a partial aggregation pushdown.

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

any, convert, convert, convert, convert, convertList, convertOperand, convertOperand, equals, equals, getOperand, getOperands, getOutConvention, getOutTrait, hashCode, matches, none, 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

Constructor Details

IntersectToDistinctRule

protected IntersectToDistinctRule(IntersectToDistinctRule.Config config)

Creates an IntersectToDistinctRule.

IntersectToDistinctRule

@Deprecated
public IntersectToDistinctRule(Class<? extends Intersect> intersectClass,
 RelBuilderFactory relBuilderFactory)

Deprecated.

Method Details

onMatch

public void onMatch(RelOptRuleCall call)

Description copied from class: RelOptRule

Receives notification about a rule match. At the time that this method is called, call.rels holds the set of relational expressions which match the operands to the rule; call.rels[0] is the root expression.

Typically a rule would check that the nodes are valid matches, creates a new expression, then calls back RelOptRuleCall.transformTo(org.apache.calcite.rel.RelNode, java.util.Map<org.apache.calcite.rel.RelNode, org.apache.calcite.rel.RelNode>, org.apache.calcite.plan.RelHintsPropagator) to register the expression.

Specified by:

onMatch in class RelOptRule

Parameters:

call - Rule call

See Also:

• RelOptRule.matches(RelOptRuleCall)

onMatchAggregateOnUnion

public void onMatchAggregateOnUnion(RelOptRuleCall call)

Variant not performing a partial aggregation pushdown.

Original query:

 SELECT job FROM "scott".emp WHERE deptno = 10
 INTERSECT
 SELECT job FROM "scott".emp WHERE deptno = 20
 

Query after conversion:

 SELECT job
 FROM (
   SELECT job, 0 AS i FROM "scott".emp WHERE deptno = 10
   UNION ALL
   SELECT job, 1 AS i FROM "scott".emp WHERE deptno = 20
 )
 GROUP BY job
 HAVING COUNT(*) FILTER (WHERE i = 0) > 0
    AND COUNT(*) FILTER (WHERE i = 1) > 0
 

onMatchAggregatePushdown

public void onMatchAggregatePushdown(RelOptRuleCall call)

Variant performing a partial aggregation pushdown.

Original query:

 SELECT job FROM "scott".emp WHERE deptno = 10
 INTERSECT
 SELECT job FROM "scott".emp WHERE deptno = 20
 

Query after conversion:

 SELECT job
 FROM (
   SELECT job, COUNT(*) AS c
   FROM (
     SELECT job, COUNT(*) FROM "scott".emp
     WHERE deptno = 10 GROUP BY job
     UNION ALL
     SELECT job, COUNT(*) FROM "scott".emp
     WHERE deptno = 20 GROUP BY job)
   GROUP BY job)
 WHERE c = 2