Apache Calcite vs openLooKeng
Apache Calcite
calcite.apache.orgopenLooKeng
openlookeng.ioSide by side
| Figure | Apache Calcite | openLooKeng |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Linux | — | Yes |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 1 |
| Spec score · Data Federation Software | 8.1 (#6) | 8.3 (#5) |
| 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. | openLooKeng is an open-source data virtualization engine for querying data across disparate sources through a unified SQL interface. |
Plans
In their own words
Apache Calcite
Apache Calcite is a free, open-source data management framework for applications that need database-management components without built-in storage. It provides an industry-standard SQL parser, validator, and JDBC driver. Queries are represented as relational algebra, then transformed with planning rules and a cost model for optimization. Calcite can mediate between applications and several storage locations or processing engines, and can push computation to a source database. Listed adapters include Arrow, Cassandra, CSV, Druid, Elasticsearch, JDBC, MongoDB, Redis, Spark, and Splunk. Its JDBC driver supports local connections and remote connections using JSON over HTTP or Protobuf over HTTP. Calcite is available as source and through Maven, for API or self-hosted use. Build prerequisites include Git and Java JDK 8u220 or later, with Java 11 preferred. It does not store data; each source must be registered through a schema or adapter.
openLooKeng
openLooKeng is a free, open-source data virtualization engine that lets teams query disparate systems through one SQL interface. It analyzes data where it resides, adding sources through connectors without requiring migration. Listed examples span relational databases, NoSQL systems, Hive, MPP warehouses, MySQL, Oracle, HBase, Elasticsearch, and Kafka. Queries can involve data centers, hybrid clouds, and geographically remote clusters using hierarchical deployment and cross-region plan optimization. Huawei describes interactive, batch, and streaming workloads, while noting that the first version supported interactive queries. Features include front scheduling, cross-source indexing, dynamic filtering, cross-source collaboration, horizontal scaling, and Coordinator active-active availability. The project is based on the open-source Presto SQL engine and uses Apache License 2.0. It is self-hosted, with Linux scripts for single-node, multi-node, and offline installation. Windows clients can connect through an ODBC driver supporting Windows 10 64-bit and Windows Server 2016 64-bit.