openLooKeng
openLooKeng is an open-source data virtualization engine that lets teams query information across different systems through a unified SQL interface.
What openLooKeng is
openLooKeng is an open-source data virtualization engine that lets teams query information across different systems through a unified SQL interface. It runs analytics where data is stored, adding sources through connectors rather than requiring migration. The project describes joint queries across relational databases, NoSQL systems, Hive, and MPP data warehouses, including examples such as MySQL, Oracle, HBase, Elasticsearch, and Kafka. Geographically separated clusters can also take part in a query through hierarchical deployment and cross-region query-plan optimization.
Huawei describes interactive, batch, and streaming query scenarios, while noting that the first version supported interactive queries. Listed capabilities include front scheduling, cross-source indexing, dynamic filtering, cross-source collaboration, and horizontal scaling; coordinator active-active support provides high availability. The engine is based on the open-source Presto SQL engine for interactive analysis and is licensed under Apache License 2.0. It is free, self-hosted software for Linux. Installation instructions cover single-node and multi-node deployments, with Java newer than 1.8.0_151 required by the multi-node script. Code is hosted on Gitee and GitHub.
Good
- Unified SQL access across multiple data sources
- Analytics can run without migrating data
- Supports queries across geographically remote clusters
- Apache License 2.0 and free to use
- Offers coordinator active-active high availability
Watch out
- Self-hosted deployment requires operating the software
- Multi-node script requires Java newer than 1.8.0_151
- First version supported interactive queries
Who it suits
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.
Verdict
openLooKeng is a free option for querying diverse data sources in place through SQL, including across remote clusters. Its fit depends on a Linux self-hosted deployment and the query scenarios your team needs.
Plans and prices
From openLooKeng's own pricing page, checked 9 Oct 2026.
| Plan | Price | What it gives you |
|---|---|---|
| openLooKeng | Free | Apache License 2.0; self-hosted deployment |
The facts
Each one read from openLooKeng's own pages, with the date it was checked.
What it does
- Client integration
- The project provides an ODBC driver for Windows and documents support for Windows 10 64-bit and Windows Server 2016 64-bit.checked 9 Oct 2026
- Connector framework
- The project provides an extensible data-source connector framework.checked 4 Oct 2026
- Cross data center
- It supports data analysis across data centers and hybrid clouds.checked 4 Oct 2026
- Data sources
- The project README describes joint queries across RDBMS, NoSQL, Hive, and MPP data warehouses, with MySQL, Oracle, HBase, Elasticsearch, and Kafka as examples.checked 9 Oct 2026
- Deployment
- The installation guide provides scripts for single-node and multi-node Linux deployments, including an offline installation option.checked 9 Oct 2026
- Deployment requirement
- The installation guide says Java must be newer than 1.8.0_151 for its multi-node installation script.checked 9 Oct 2026
- Distributed queries
- Geographically remote openLooKeng clusters can participate in the same query using hierarchical deployment and cross-region query plan optimization.checked 9 Oct 2026
- Foundation
- Huawei says openLooKeng uses the open-source Presto SQL engine as its basis for interactive query analysis.checked 4 Oct 2026
- High availability
- The launch announcement describes coordinator active-active support and a scalable data-source connector framework.checked 9 Oct 2026
- In-place analytics
- It supports analytics on data where it resides, without requiring data migration.checked 9 Oct 2026
- Intended users
- The launch announcement invites big-data developers to join the open-source community and describes analytics across data sources and data centers.checked 9 Oct 2026
- License
- Huawei’s launch announcement states that openLooKeng is distributed under Apache License 2.0 for free use, modification, and redistribution.checked 9 Oct 2026
- No data migration
- The maker says new data sources can be added through connectors without data migration.checked 4 Oct 2026
- ODBC security options
- The ODBC guide describes connection configuration options for SSL and Kerberos.checked 9 Oct 2026
- Performance features
- The project README describes dynamic filtering, bitmap, Bloom and min-max indexes, and metadata, execution-plan, and ORC row-data caches.checked 9 Oct 2026
- Product
- openLooKeng is described as a high-performance data virtualization engine.checked 4 Oct 2026
- Purpose
- openLooKeng is an open-source data virtualization engine for querying data across disparate sources through a unified SQL interface.checked 9 Oct 2026
- Query workloads
- The launch announcement describes interactive, batch, and stream query scenarios, while noting that the first version supported interactive queries.checked 9 Oct 2026
- Reliability
- The project provides Coordinator AA high availability.checked 4 Oct 2026
- Source code
- The project lists Gitee and GitHub as code hosting locations.checked 4 Oct 2026
- SQL access
- It provides a unified SQL interface for accessing multiple data sources.checked 4 Oct 2026
Where it runs
- Query scenarios
- Huawei describes support for interactive, batch, and streaming query scenarios, with the first version supporting interactive queries.checked 4 Oct 2026
Alternatives to openLooKeng
- 1
Stardog
Free planAndroidiOSWebAPI7.7Free plan - 2
Starburst Galaxy
Free planWebAPILinux7.1Free plan - 3
Apache Drill
Free planAPILinuxmacOSSelf-hosted6.7Free plan - 4
Denodo Platform
Free planWebAPILinuxSelf-hosted6.7Free plan - 5
Enterprise Enabler
WebAPILinuxmacOS6.7From $2.17 a month - 6
QoreDB
Free planLinuxmacOSWindows6.7From €99 a year