Apache Drill
6.7#3 in data federation softwareFree planFree planAPILinuxmacOSSelf-hosted
Visit| Fact | Apache Drill | openLooKeng |
|---|---|---|
| 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. |
It suits users who want to query raw data across Hadoop, NoSQL, cloud, or local sources, and developers building applications with its REST API. BI users can connect through the listed JDBC and ODBC drivers.
It suits big-data developers and teams that need SQL queries across varied data sources or data centers while keeping data in place. Linux teams prepared to deploy and operate self-hosted software are the clearest fit.