Apache Kylin

Apache Kylin is an open-source distributed OLAP engine for high-concurrency analytics on large datasets. It lets data teams define multidimensional data models, build precomputed indexes and aggregations, and serve SQL queries to downstream business intelligence tools and applications.

Kylin projects organize source tables, models, indexes, and query analysis. Users define fact tables, dimension tables, relationships, measures, and calculated fields in a visual modeling interface. The platform uses those models to create aggregate and table indexes for the combinations of dimensions and metrics that users need to query. Data can be loaded incrementally into partitioned models while existing indexed data remains available for analysis.

Kylin supports standard SQL and can route queries to precomputed model data or push queries down to a connected data source when needed. It includes query history, job monitoring, index management, and model recommendations based on query patterns. Apache Kylin 5 also includes internal tables, Apache Gluten integration for native compute, and streaming-batch fusion capabilities.

The platform can connect to BI and spreadsheet tools such as Tableau, Microsoft Power BI, and Excel. It is intended for data engineers, analytics engineers, and organizations that need to accelerate multidimensional SQL analysis on data held in systems such as Hive. Apache Kylin is distributed under the Apache License 2.0.