Package org.apache.calcite.rel.rules

Class AggregateFilterToFilteredAggregateRule

java.lang.Object

org.apache.calcite.plan.RelOptRule

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

org.apache.calcite.rel.rules.AggregateFilterToFilteredAggregateRule

@Enclosing
public class AggregateFilterToFilteredAggregateRule
extends RelRule<AggregateFilterToFilteredAggregateRule.Config>

Rule that converts an aggregate on top of a filter into a filtered aggregate.

Before

   SELECT SUM(salary)
   FROM Emp
   WHERE deptno = 10
  

After

   SELECT SUM(salary) FILTER (WHERE deptno = 10)
   FROM Emp
  

The transformation is particularly useful in view-based rewriting. The removal of the Filter operators lifts some restrictions when using the MaterializedViewRules.

Filtered aggregates can be transformed to other equivalent forms via other transformation rules (e.g., AggregateFilterToCaseRule).

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static interface	AggregateFilterToFilteredAggregateRule.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

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

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)