openLooKeng vs Presto

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.

Presto is an open-source distributed SQL query engine for working with large datasets across different data sources. Its ANSI SQL interface can query information where it is stored and combine data from multiple sources in one query, for both interactive and batch workloads. The project lists ad hoc queries, reporting and dashboards, and open lakehouse workloads among its uses. Documented connectors include BigQuery, Cassandra, Delta Lake, Elasticsearch, Hive, Iceberg, Kafka, MongoDB, MySQL, PostgreSQL, and Redis. Presto can be installed from a server tarball or deployed with Homebrew, Docker, or Helm. Security options include Kerberos, LDAP, password-file authentication, access controls, secure internal communication, and OAuth 2.0. Users can work through its CLI or Console, connect with DBeaver or Tableau, use Java, Python, Go, or JavaScript clients, or access the REST API. The project is free and open source, overseen by the Presto Foundation, which describes it as independent of any single company. The documentation identifies release 0.299, while the getting-started page still refers to version 0 from June 2022.