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.

Document of prior versions:

Installation & Setup

  1. Hadoop Env
  2. Installation Guide
  3. Advanced settings
  4. Deploy in cluster mode
  5. Run Kylin with Docker


  1. Quick Start with Sample Cube
  2. Cube Creation
  3. Cube Build and Job Monitoring
  4. Web Interface
  5. SQL reference: by Apache Calcite
  6. Build Cube with Streaming Data
  7. Build Cube with Spark Engine (beta)
  8. Cube Build Tuning Step by Step

Connectivity and APIs

  1. ODBC driver
  2. JDBC driver
  3. RESTful API list
  4. Build cube with RESTful API
  5. Call RESTful API in Javascript
  6. Connect from MS Excel and PowerBI
  7. Connect from Tableau 8
  8. Connect from Tableau 9
  9. Connect from SQuirreL
  10. Connect from Apache Flink
  11. Connect from Hue


  1. Backup/restore Kylin metadata
  2. Cleanup storage (HDFS & HBase)
  3. Upgrade from old version