- Home
- Data Federation Software
- Apache Calcite
Apache Calcite
What it is
Apache Calcite is a free, dynamic data management framework that supplies database-management components without providing data storage, data-processing algorithms, or metadata storage. It includes an industry-standard SQL parser, validator, and JDBC driver. Calcite represents queries as relational algebra, applies planning rules, and uses a cost model to optimize them. It can connect applications with multiple storage locations and processing engines, including by pushing computation to a source database.
Listed adapters include Arrow, Cassandra, CSV, Druid, Elasticsearch, JDBC, MongoDB, Redis, Spark, and Splunk. The JDBC driver supports local connections and remote connections using JSON over HTTP or Protobuf over HTTP. Calcite is available as source and through Maven, and can be used through an API or self-hosted. It does not own or store data, so a data source must be registered through a schema or adapter. Build prerequisites include Git and Java JDK 8u220 or later, with Java 11 preferred. The project directs users to its developers mailing list, Jira, Stack Overflow, and source code for help.
For and against
For
- Provides a SQL parser, validator, and JDBC driver
- Uses relational algebra and a cost model for optimization
- Includes adapters for varied data sources and engines
- Available as source and through Maven
Against
- Does not provide data storage or metadata storage
- Data sources must be registered through a schema or adapter
- Build prerequisites include Git and Java JDK 8u220 or later
The verdict
Calcite provides SQL and query-planning components for applications that connect to external data sources. It is a framework, not a data store, and requires source registration through a schema or adapter.
Who it suits
Calcite suits developers building applications that need SQL parsing, query planning, or mediation across data sources and processing engines. It requires users to register data sources rather than storing data itself.
Plans and prices
Apache Calcite
Open source database framework · source release and Maven artifacts
Read 4 Oct 2026 · calcite.apache.org
On the record
- Adapters
- Listed adapters include Arrow, Cassandra, CSV, Druid, Elasticsearch, JDBC, MongoDB, Redis, Spark, and Splunk.calcite.apache.org · read 4 Oct 2026
- Contribution
- The project welcomes contributions and recommends discussing large contributions through a Jira case or the developers mailing list.calcite.apache.org · read 4 Oct 2026
- Downloads
- Calcite is released as source and through Maven; the downloads page lists version 1.42.0 dated 31 May 2026.calcite.apache.org · read 4 Oct 2026
- Federation
- Calcite can mediate between applications and multiple data storage locations and processing engines, and can push computation to a source database.calcite.apache.org · read 4 Oct 2026
- JDBC connectivity
- The JDBC driver supports local connections and remote connections using JSON over HTTP or Protobuf over HTTP.calcite.apache.org · read 4 Oct 2026
- Limit
- Calcite does not store or own data; a data source must be registered through a schema or adapter.calcite.apache.org · read 4 Oct 2026
- Purpose
- Apache Calcite is a dynamic data management framework that provides components of a database management system while omitting data storage, data processing algorithms, and metadata storage.calcite.apache.org · read 4 Oct 2026
- Query optimization
- Calcite represents queries in relational algebra, applies planning rules, and optimizes using a cost model.calcite.apache.org · read 4 Oct 2026
- Release integrity
- The downloads page instructs users to verify downloaded artifacts with a PGP signature or hash.calcite.apache.org · read 4 Oct 2026
- Runtime requirements
- The development page lists Git and Java JDK 8u220 or later, with Java 11 preferred, as build prerequisites.calcite.apache.org · read 4 Oct 2026
- Security
- Apache's Security Team coordinates vulnerability handling for Apache projects, and the project releases fixes through affected package releases.apache.org · read 4 Oct 2026
- SQL
- Calcite provides an industry-standard SQL parser, validator, and JDBC driver.calcite.apache.org · read 4 Oct 2026
- Support
- The project directs users to its developers mailing list, Calcite Jira, Stack Overflow, and source code for help.calcite.apache.org · read 4 Oct 2026
