Welcome to Apache Kylin™: Extreme OLAP Engine for Big Data

Apache Kylin™ is an open source Distributed Analytics Engine designed to provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop supporting extremely large datasets.

This is the document for the latest released version (v2.4). Document of prior versions:
* v2.3.x document
* Archived

Installation & Setup

  1. Installation Guide
  2. Configurations
  3. Deploy in cluster mode
  4. Advanced settings
  5. Run Kylin with Docker
  6. Install Kylin on AWS EMR


  1. Quick Start with Sample Cube
  2. Web Interface
  3. Cube Wizard
  4. Cube Build and Job Monitoring
  5. SQL reference: by Apache Calcite
  6. Build Cube with Streaming Data
  7. Build Cube with Spark Engine
  8. Cube Build Tuning
  9. Enable Query Pushdown
  10. Setup System Cube
  11. Optimize with Cube Planner
  12. Use System Dashboard
  13. Setup JDBC Data Source

Connectivity and APIs

  1. ODBC driver
  2. JDBC driver
  3. RESTful API list
  4. Build cube with RESTful API
  5. Connect from MS Excel and PowerBI
  6. Connect from Tableau 8
  7. Connect from Tableau 9
  8. Connect from MicroStrategy
  9. Connect from SQuirreL
  10. Connect from Apache Flink
  11. Connect from Apache Spark
  12. Connect from Hue
  13. Connect from Qlik Sense
  14. Connect from Apache Superset
  15. Connect from Redash


  1. Backup/restore Kylin metadata
  2. Cleanup storage
  3. Upgrade from old version