Calcite - Dialect (SqlDialect)

Card Puncher Data Processing

Calcite - Dialect (SqlDialect)

About

A dialect in calcite represents a language of a database.

It determines how the SQL tree (SqlNodes) are transformed SQL (e.g. generate “LIMIT 5” or “FETCH 5 ROWS”)

They are all in the dialect package

Example: Print a sql tree with a dialect

System.out.println(sqlNode.toSqlString(OracleSqlDialect.DEFAULT));





Discover More
Card Puncher Data Processing
Calcite - Syntax Tree (SqlNode)

SQL tree in Calcite. The tree is build by the parser and each node (Tokens) is represented by SqlNode SqlNode can be converted back to SQL via the unparse...



Share this page:
Follow us:
Task Runner