Side by side
Apache Calcite vs Apache Drill
Both stand on data federation software. Which one you can start free with, which one lets you read the code, and what each costs once you pay.
Free plan APISelf-hosted
Apache Calcite provides SQL and query-planning components for applications working across data sources. It is not a storage system, so plan to supply and register the sources and processing components it will use.
Visit Apache Calcite Free plan APILinuxMac+2
Apache Drill offers in-place SQL queries across varied data sources, with options for BI tools and custom applications. Check its compatibility requirements first, particularly if you rely on Hadoop 2 or Java 8.
Visit Apache DrillThe facts
| Apache Calcite | Apache Drill | |
|---|---|---|
| Free plan | Yes | Yes |
| Open source | Not published | Not published |
| Runs on | API, Self-hosted | API, Linux, Mac, Self-hosted, Windows |
| Lowest paid plan | Free or on request | Free or on request |
| Plans published | 1 | 1 |
| Maker | Not published | Not published |
| Website | calcite.apache.org | drill.apache.org |
| On data federation software | #5 of 24 | #1 of 24 |
Apache Calcite: what it does well
- Free and available as source and Maven artifacts.
- Includes a SQL parser, validator, and JDBC driver.
- Can connect multiple data sources and engines.
- Adapters cover a range of sources and engines.
What to know first
- It does not store data.
- A source must be registered through a schema or adapter.
- Build prerequisites include Git and Java JDK 8u220 or later.
Apache Drill: what it does well
- Queries raw data in place without schema setup
- Supports nested JSON and cross-source joins
- JDBC and ODBC drivers connect listed BI tools
- Runs embedded or across a server cluster
- Free under Apache License 2.0
What to know first
- Official Hadoop 2 and Java 8 support was dropped with Drill 1.22.0
- No free trial is listed
Alternatives to Apache Calcite Alternatives to Apache Drill The whole list