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 other 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 (deprecated)
  7. Build Cube with Streaming Data (new scalable solution)

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


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