Apache Calcite
Apache Calcite: A flexible foundation for developers building federated query and database systems. Ranked #11 of 24 in Data Federation Software by our editors (6.2/10); pricing: Free plan; best for developers building a federation engine.
At a glance
- Editor score6.2 / 10
- PricingFree plan
- Best forDevelopers building a federation engine
- Free planYes
- Paid fromNone
- Cloud hostedNo
- Founded2014
- Facts checked20 Sep 2026
Where it wins
- Free, open-source framework with SQL parsing, validation, and optimization
- Adapters connect JDBC, Cassandra, MongoDB, Elasticsearch, Kafka, and more
- Pushdown and materialized-view rewriting can optimize federated queries
Where it doesn't
- Embedded framework rather than a turnkey hosted product
- Cloud-hosted deployment is not part of the published platform model
- No verified row-level security capability
Our verdict on Apache Calcite
Apache Calcite is an embeddable, open-source framework for developers building database, query-engine, and data-virtualization systems. It handles SQL parsing, validation, relational algebra, cost-based query optimization, JDBC connectivity, and adapters for multiple data sources. Rather than owning the underlying data, Calcite mediates between applications and storage or processing engines, presenting sources as schemas and tables. It is best suited to teams creating a federation engine or integrating query capabilities into another system.
The pricing model is straightforward: Apache Calcite is free and open source, with no paid plan structure described. Its main technical value is the planner. Cost-based relational optimization, query pushdown, and materialized-view registration and rewriting give developers mechanisms to improve how federated queries are executed. Local and remote JDBC drivers are available, while Avatica supports JSON or Protocol Buffers over HTTP. The optional calcite-server component adds DDL, views, foreign schemas, and materialized views. These capabilities provide building blocks rather than a finished interface for business users.
Calcite fits ecosystems that need broad connectivity, including JDBC, Apache Cassandra, Apache Kafka, Apache Druid, Elasticsearch, MongoDB, Redis, Apache Spark, Apache Solr, Apache Splunk, Apache Geode, and Apache Arrow. Its published platform coverage centers on API access and self-hosting, so deployment, operations, and product-level experiences remain the implementer's responsibility. Teams seeking control over query planning and source integration should consider it; organizations looking for a hosted federation service, built-in cloud deployment, or a turnkey user experience should choose a different type of product.
Apache Calcite pricing
Apache Calcite fact sheet
| Free plan | Yes |
|---|---|
| Paid from | None |
| Cloud hosted | No |
| Self-hosted | Yes |
| SQL querying | Yes |
| Query result cache | Not verified |
| Row-level security | No |
| API access | Yes |
| Scheduled queries | Not verified |
| Deployment | Self-hosted |
| Support | Community, Docs |
| Built for | Solo, Small business, Mid-market, Enterprise (editorial estimate) |
| Integrations | 12 integrations: JDBC, Apache Cassandra, Apache Kafka, Apache Druid, Elasticsearch, MongoDB … See all → |
| Pricing | Free plan |
| Website | calcite.apache.org |
| Facts checked | 20 Sep 2026 |
Apache Calcite integrations
Apache Calcite lists 12 integrations on its own site.
- JDBC
- Apache Cassandra
- Apache Kafka
- Apache Druid
- Elasticsearch
- MongoDB
- Redis
- Apache Spark
- Apache Solr
- Apache Splunk
- Apache Geode
- Apache Arrow
See all Apache Calcite integrations →
Alternatives to Apache Calcite
- Denodo PlatformA governed data federation layer with broad access methods, security controls, and enterprise scale.9.4
- Starburst GalaxyA cloud-native federation platform with a free tier and usage-based paid plans.8.4
- DremioA broad federation and lakehouse platform with free, managed-cloud, and self-managed options.7.7
See all Apache Calcite alternatives →
Used Apache Calcite? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used Apache Calcite for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
Apache Calcite is listed in our Data Federation Software directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/apache-calcite/"><img src="https://www.itechguides.com/best/badge/apache-calcite.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Sep 2026
Advertiser disclosure: iTechGuides is reader-supported. We may earn a commission when you click some links. How we rank.
Last updated · How we research and update