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.

Example

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
 

See Also:

• UnionToDistinctRule
• CoreRules.INTERSECT_TO_DISTINCT

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.

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)