Apache Calcite
Developer(s)Apache Software Foundation
Initial releaseJune 27, 2014; 9 years ago (2014-06-27)[1]
Stable release1.32.0 (September 10, 2022; 18 months ago (2022-09-10)[2]) [±]
RepositoryCalcite Repository
Written inJava
Operating systemCross-platform
TypeSQL database
LicenseApache License 2.0

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.


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