Calcite support overview
Apache Calcite is a widespread SQL dialect used in big data processing with some streaming enhancements. Calcite provides the basic dialect underlying Beam SQL.
We have added additional extensions to make it easy to leverage Beam’s unified batch/streaming model and support for complex data types.
Query statements scan one or more tables or expressions and return the computed result rows. The Query syntax page describes Beam SQL’s syntax for queries when using Apache Calcite.
A Beam SQL statement comprises a series of tokens. The Lexical structure page documents Beam SQL’s lexical structure when using Apache Calcite.
Beam SQL supports standard SQL scalar data types as well as extensions including arrays, maps, and nested rows. Read about supported data types in Beam SQL when using Apache Calcite.
Functions and operators
The following table summarizes Apache Calcite operators and functions supported by Beam SQL.