Apache Drill vs openLooKeng
Apache Drill
drill.apache.orgopenLooKeng
openlookeng.ioSide by side
| Figure | Apache Drill | openLooKeng |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Windows | Yes | — |
| macOS | Yes | — |
| Linux | Yes | Yes |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 1 |
| Spec score · Data Federation Software | 9.0 (#1) | 8.3 (#5) |
| Data sources | The site lists support for sources including HBase, MongoDB, HDFS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS, and local files. | The project README describes joint queries across RDBMS, NoSQL, Hive, and MPP data warehouses, with MySQL, Oracle, HBase, Elasticsearch, and Kafka as examples. |
| Deployment | Drill can run embedded on a laptop or in distributed mode on a cluster of servers. | The installation guide provides scripts for single-node and multi-node Linux deployments, including an offline installation option. |
| License | The Apache Drill site identifies the project as licensed under the Apache License, Version 2.0. | Huawei’s launch announcement states that openLooKeng is distributed under Apache License 2.0 for free use, modification, and redistribution. |
| Purpose | Apache Drill is a schema-free SQL query engine for Hadoop, NoSQL and cloud 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 Drill
Apache Drill is a schema-free SQL query engine for Hadoop, NoSQL databases, and cloud storage. It can query raw data where it resides without first loading it, defining schemas, or transforming it. Its JSON data model supports complex and nested structures, and a single query can join data across multiple datastores. Listed sources include HBase, MongoDB, HDFS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS, and local files. JDBC and ODBC drivers connect Drill to tools including Tableau, Qlik, MicroStrategy, Spotfire, SAS, and Excel; developers can also use its REST API in custom applications. Drill can run embedded on a laptop or in distributed mode on a server cluster, and the homepage lists Mac, Windows, and Linux. Documented security options include Kerberos, username and password authentication, Digest, authorization, and impersonation. The software is free under Apache License 2.0. A compatibility limit: official support for Hadoop 2 and Java 8 was dropped with Drill 1.22.0.
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.