Apache Kylin Gets Table Level ACL Management
Written by Kay Ewbank   
Tuesday, 21 November 2017

There's an updated version of Apache Kylin, the "Extreme OLAP Engine for Big Data" with improvements including table-level ACL management.

Kylin is an open source distributed analytics engine designed to provide a SQL interface and multi-dimensional analysis (OLAP) on Apache. It was originally developed at eBay before becoming an Apache project.

The Kylin OLAP Engine is made up of a metadata engine, a query engine, a job engine and a storage engine. It also includes a REST Server to service client requests. The query engine is based on Apache Calcite.

Apache Kylin lets you query massive data sets in three steps:

  1. Identify a Star Schema on Hadoop.
  2. Build a Cube from the identified tables.
  3. Query with ANSI-SQL and get results in sub-second, via ODBC, JDBC or RESTful API.

Kylin currently offers integration capability with BI Tools inlcuding Tableau, PowerBI and Excel.

The main improvements to the new release are to ACL. You can now manage ACL through Apache Ranger, a framework to enable, monitor and manage data security across the Hadoop platform. It provides centralized security administration to manage all security related tasks in a central UI or using REST APIs, and supports fine grained authorization. 

The ability to manage Kylin ACL through Ranger brings it into line with other elements of the Hadoop ecosystem, where Ranger can be used to manage HDFS, Yarn, Hive, and HBase.

Ranger can now control access rights for Kylin projects and cubes, and Kylin provides an abstract class and authorization interfaces for use by the Ranger plugin.

Table level ACL has also been added to control whether a user can query data from a table.  The table level ACL is set at the project level. When an instance starts for the first time or upgrades from lower version, every user by default has access to all tables that have been loaded to the project, but it's now possible to modify the table level ACL.

A new Streaming Cube sample has also been added. This will generate the sample tables, model and cube for a Hive-based data source. It has been added because until now there has been no easy way to generate such a sample for a Kafka-based streaming cube.


More Information

Kylin 2.2 Release Notes

Related Articles

Apache Kylin Adds RDBMS Support 

Spark BI Gets Fine Grain Security 

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.



At What Age Do Programmers Write Languages?

This is just one of many question that can be answered by reference to PLDB, the programming language database devised and maintained by Breck Yunits, himself the author of Scroll, an o [ ... ]

GitHub Announces 2024 Accelerator Cohort Winners

GitHub has announced the companies chosen to form the next cohort for GitHub Accelerator. Find out about this year's participating projects, all of which focus on AI.

More News


C book



or email your comment to: comments@i-programmer.info

Last Updated ( Tuesday, 21 November 2017 )