openLooKeng
openLooKeng: A self-hosted choice for federated SQL across heterogeneous data systems. Ranked #23 of 24 in Data Federation Software by our editors (6.6/10); pricing: Open source; best for open-source cross-domain SQL clusters.
At a glance
- Editor score6.6 / 10
- PricingOpen source
- Best forOpen-source cross-domain SQL clusters
- Paid fromFree
- Facts checked20 Sep 2026
Where it wins
- Unified SQL 2003 interface across multiple data sources
- Federated queries across relational, NoSQL, Hive, and MPP databases
- Cross-domain execution with join optimization, indexes, and caching
Where it doesn't
- Linux and self-hosted deployment limits platform flexibility
- Cluster deployment requires single-node or multi-node administration
- Its scope centers on SQL federation rather than a hosted service
Our verdict on openLooKeng
openLooKeng is an open-source distributed query engine for in-situ analytics across heterogeneous and geographically remote data sources. It is designed for teams that need to query relational databases, NoSQL stores, Hive, and MPP databases through a unified SQL 2003 interface without first moving data into a central warehouse. Its use cases include data exploration, ad hoc queries, batch processing, cross-data-center execution, and virtual data-mart scenarios. The product fits organizations comfortable operating Linux-based, self-hosted data infrastructure.
Its strongest technical case is breadth across data locations and systems. openLooKeng supports federated querying across several database types, cross-domain and cross-data-center query execution, separated storage and compute, and virtual data-mart definitions using standard SQL. Distributed joins can use dynamic filtering, while external bitmap, Bloom, and min-max indexes support query work across distributed data. Metadata, execution-plan, and ORC row-data caching add further controls for repeated or distributed workloads. These capabilities make it a fit for cross-domain analytics where keeping data in place is important.
The deployment model is also central to the buying decision. The published model is open source, with single-node and multi-node cluster deployment documented for Linux and self-hosted environments. There are no plan tiers to compare; the practical commitment is operating and maintaining the cluster rather than selecting a hosted package. Teams should choose openLooKeng when they want open-source federated SQL and have the infrastructure capacity to manage deployment. Organizations seeking a managed cloud experience, broad platform choice, or a simpler operational path should consider a different category option.
Your product? Our editors can test openLooKeng in depth and publish a review, labelled as paid · from $149/mo →
openLooKeng pricing
openLooKeng fact sheet
| Free plan | Not verified |
|---|---|
| Paid from | Free |
| Cloud hosted | Not verified |
| Self-hosted | Yes |
| SQL querying | Yes |
| Query result cache | Not verified |
| Row-level security | Not verified |
| API access | Not verified |
| Scheduled queries | Not verified |
| Deployment | Self-hosted |
| Platforms | Linux |
| Support | Docs |
| Built for | Mid-market, Enterprise (editorial estimate) |
| Pricing | Open source |
| Website | openlookeng.io |
| Facts checked | 20 Sep 2026 |
Alternatives to openLooKeng
- Denodo PlatformA governed data federation layer with broad access methods, security controls, and enterprise scale.9.3
- Starburst GalaxyA cloud-native federation platform with a free tier and usage-based paid plans.9.1
- DremioA broad federation and lakehouse platform with free, managed-cloud, and self-managed options.8.8
See all openLooKeng alternatives →
Used openLooKeng? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used openLooKeng for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
openLooKeng is listed in our Data Federation Software directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/openlookeng/"><img src="https://www.itechguides.com/best/badge/openlookeng.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update