Apache Kylin (EN)

Apache Kylin

Apache Kylin is an open-source OLAP system specifically developed for processing large data volumes in Hadoop environments. It enables the creation of OLAP cubes from relational data sources and supports fast queries on large datasets. Kylin provides a SQL interface for querying the OLAP cubes and can be integrated with BI tools like Tableau or Power BI. The system is particularly powerful for companies that need to perform complex analyses on large data volumes. Apache Kylin was originally developed at eBay and is now an Apache Top-Level Project.

Architecture

flowchart TD     A[Data Source] --> B(Kylin Build)     B --> C[OLAP Cube]     C --> D[REST API]     D --> E[BI Tools/Tableau/Power BI]     D --> F[Web UI]     D --> G[Java API]          subgraph Kylin Build Process         H[Metadata Model] --> I[Cube Design]         I --> J[Cube Build]         J --> K[Segmentation]         K --> L[Cube]     end          A --> H 

In Context

• Typically used together with Hadoop ecosystems, Hive and Spark
• Related to: Apache Druid, Apache Superset, Presto
• Example use case: Real-time analysis of e-commerce transaction data