Table of Contents

Calcite - (Planner) Rule (RelOptRule)

About

A rule is used to modified a relational expression (ie query plan)

They are used by the planner to:

relational algebra expressions (ie query plan).

Every rule extends RelOptRule (and are used by the planner (RelOptPlanner)).

Type

Two types of rules:

Converter

A ConverterRule converts between calling conventions.

Example:

Calcite Converter Rule

Transformer

A rule that match a subtree of a relational algebra expression and replace it with a different subtree. ie it is a rule to transform an relational expression to another.

Example: exchange the order of Filter and a Project nodes.

Match: Transformer Rules are matched to elements of a query plan using pattern matching. onMatch is called for matched rules

Calcite Transpose Rule

Example: RelOptRulesTest.java

List

Documentation / Reference