Article · Wikipedia archive · Last revised May 28, 2026

Apache Calcite

Apache Calcite is an open source framework for building databases and data management systems. It includes a SQL parser, an API for building expressions in relational algebra, and a query planning engine. As a framework, Calcite does not store its own data or metadata, but instead allows external data and metadata to be accessed by means of plug-ins.

Last revised
May 28, 2026
Read time
≈ 1 min
Length
161 w
Citations
4
Source
Apache Calcite
DeveloperApache Software Foundation
Initial releaseJune 27, 2014 (2014-06-27)1
Stable release1.37.0 (May 6, 2024 (2024-05-06)2) [±]
Written inJava
Operating systemCross-platform
PlatformJava
TypeSQL database framework
LicenseApache License 2.0
Websitecalcite.apache.org
RepositoryCalcite Repository

Apache Calcite is an open source framework for building databases and data management systems. It includes a SQL parser, an API for building expressions in relational algebra, and a query planning engine. As a framework, Calcite does not store its own data or metadata, but instead allows external data and metadata to be accessed by means of plug-ins.

Several other Apache projects use Calcite.3 Hive uses Calcite for cost-based query optimization;4 Drill and Kylin use Calcite for SQL parsing and optimization; Samza and Storm use Calcite for streaming SQL. As of August 2016, Apex, Phoenix and Flink have projects under development that use Calcite.

References

References

  1. Julian Hyde. "Optiq-0.8 release announcement". Apache Software Foundation.
  2. "Downloads". calcite.apache.org. Apache Software Foundation. Retrieved 2024-05-14.
  3. "Powered by Calcite". Apache Software Foundation.
  4. Julian Hyde. "Cost-based query optimization in Apache Hive 0.14", Hortonworks, 24 September 2014.