Apache Kylin Gets Table Level ACL Management
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, FacebookGoogle+ or Linkedin.

 

Banner


Seeing Around Corners
12/11/2017

A team from CSAIL has come up with an innovative algorithm for eliminating blind spots. The idea is that you use corners as a camera. Sound mad, but it is just another example of an inverse problem th [ ... ]



Programmers Against Slaughterbots
20/11/2017

Autonomous weapons might sound like a good idea at first, why send soldiers to die, but the potential for misuse is obvious. You might not have thought of such as the slaughterbot - you need to see th [ ... ]


More News

 

 
 

 

blog comments powered by Disqus

Last Updated ( Tuesday, 21 November 2017 )
 
 

   
Banner
Banner
RSS feed of news items only
I Programmer News
Copyright © 2017 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.