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.

kylin
 

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.

 

Banner


nginx Core Developer Announces New Fork
23/02/2024

One of the core developers of nginx has said he is no longer working on the development of the popular and widely used nginx web server, and is instead working on a new fork. Maxim Dounin release [ ... ]



Running PostgreSQL Inside Your Browser With PGLite
18/03/2024

Thanks to WebAssembly we can now enjoy PostgreSQL inside the browser so that we can build reactive, realtime, local-first apps directly on Postgres. PGLite is about to make this even easier.


More News

 

raspberry pi books

 

Comments




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

Last Updated ( Tuesday, 21 November 2017 )