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


Flutter Forked As Flock
05/11/2024

One of developers who worked on the Flutter team at Google has created an open-source form of the framework. Matt Carroll says Flock will be "Flutter+", will remain constantly up to date with Flutter, [ ... ]



Apache Fury Adds Optimized Serializers For Scala
31/10/2024

Apache Fury has been updated to add GraalVM native images and with optimized serializers for Scala collection. The update also reduces Scala collection serialization cost via the use of  encoding [ ... ]


More News

 

espbook

 

Comments




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

Last Updated ( Tuesday, 21 November 2017 )