Apache Kylin v3.1.1 released, Open source distributed analytics engine
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, originally contributed from eBay Inc.
Apache Kylin lets you query massive datasets at sub-second latency in 3 steps.
- Identify a Star Schema on Hadoop.
- Build Cube from the identified tables.
- Query with ANSI-SQL and get results in sub-second, via ODBC, JDBC or RESTful API.
WHAT IS KYLIN?
– Extremely Fast OLAP Engine at Scale:
Kylin is designed to reduce query latency on Hadoop for 10+ billions of rows of data
– ANSI SQL Interface on Hadoop:
Kylin offers ANSI SQL on Hadoop and supports most ANSI SQL query functions
– Interactive Query Capability:
Users can interact with Hadoop data via Kylin at sub-second latency, better than Hive queries for the same dataset
– MOLAP Cube:
User can define a data model and pre-build in Kylin with more than 10+ billions of raw data records
– Seamless Integration with BI Tools:
Kylin currently offers integration capability with BI Tools like Tableau, PowerBI, and Excel. Integration with Microstrategy is coming soon
– Other Highlights:
– Job Management and Monitoring
– Compression and Encoding Support
– Incremental Refresh of Cubes
– Leverage HBase Coprocessor for query latency
– Both approximate and precise Query Capabilities for Distinct Count
– Approximate Top-N Query Capability
– Easy Web interface to manage, build, monitor and query cubes
– Security capability to set ACL at Cube/Project Level
– Support LDAP and SAML Integration
– Compression and Encoding Support
– Incremental Refresh of Cubes
– Leverage HBase Coprocessor for query latency
– Both approximate and precise Query Capabilities for Distinct Count
– Approximate Top-N Query Capability
– Easy Web interface to manage, build, monitor and query cubes
– Security capability to set ACL at Cube/Project Level
– Support LDAP and SAML Integration
Apache Kylin v3.1.1 was released.
Changelog
- This is a bug-fix release after 3.1.0, with 58 bug fixes and enhancement. Check the release notes.
- Release notes, installation guide and upgrade guide
- Source download: apache-kylin-3.1.1-source-release.zip [asc] [sha256]
- Binary for Hadoop 2 download:
- for HBase 1.x (includes HDP 2.3+, AWS EMR 5.0+, Azure HDInsight 3.4 – 3.6) – apache-kylin-3.1.1-bin-hbase1x.tar.gz [asc] [sha256]
- for Cloudera CDH 5.7+ – apache-kylin-3.1.1-bin-cdh57.tar.gz [asc] [sha256]
- Binary for Hadoop 3 download:
- for Hadoop 3.1 + HBase 2.0 (includes Hortonworks HDP 3.0) – apache-kylin-3.1.1-bin-hadoop3.tar.gz [asc] [sha256]
- for Cloudera CDH 6.0/6.1 (check KYLIN-3564 first) – apache-kylin-3.1.1-bin-cdh60.tar.gz [asc] [sha256]
