Calcite - Query Planning Process (Sql Processing)

Card Puncher Data Processing

About

SQL Engine - SQL processing (Sql Compiler) in Calcite

The query planning process is the entire process that takes a SQL to a result.

Process

The process can be resumed as follow:

Planner

Calcite has a tool called the planner to perform this process.

Not the same than the planner optimizer

Example

See Calcite - Getting Started (from Sql to Resultset)





Discover More
Card Puncher Data Processing
Calcite - Getting Started (from Sql to Resultset)

A getting started page that shows a query planning process (ie from sql to resultset process) gerardnico/calcite/blob/master/src/test/java/com/gerardnico/calcite/CalciteFrameworksTest.javaCalciteFrameworksTest.java...
Card Puncher Data Processing
Calcite - Logical Plan (Logical algebra)

in Calcite A logical plan is a relational expression with only logical operator. Logical algebra has no implementation of the relational operator and therefore can't run. The logical plan is the first...
Card Puncher Data Processing
Calcite - Planner (RelOptPlanner)

org/apache/calcite/plan/package-infoPlan provides an optimizer interface (ie Defines interfaces for constructing rule-based optimizers of relational expressions) Frameworks...
Card Puncher Data Processing
Calcite - Sql Parser

The ''calcite SQL Parser is a LL(k) parser that build a Sql tree (SqlNode) The org/apache/calcite/sql/parser/SqlParserparserConfig parameters control the parse process. For example: identifiers...
Card Puncher Data Processing
Calcite - Sql Validation

Validation of a sql tree (SqlNode) With the query planning utility as shown in the getting started With a org/apache/calcite/sql/validate/SqlValidatorUtilSqlValidatorUtil. In the example below,...



Share this page:
Follow us:
Task Runner