Welcome to Apache Kylin™: Analytical Data Warehouse for Big Data

Apache Kylin™ is an open source Distributed Analytical Data Warehouse for big data; It was designed to provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop supporting extremely large datasets.

This is the document for v3.0. Document of other versions:
* v2.4 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
  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