Accelerate Multi-dimensional Analytics on Hadoop with Kylin

Kylin?is an open source analytics platform from the house of eBay, designed to run analytics on Hadoop using SQL compatible tools, thereby allowing developers and power users with prior knowledge of analytical services to run multi-dimensional analytics.

Kylin is an important bridge for power users who not only want to continue to use their favourite tool like Excel, Power BI, or Tableau?to create and execute predictive analytical models based on the principals of OLAP, but at the same time also want to leverage the performance of Hadoop in quickly processing large volumes of data at sub-second rates. The platform has since been transformed into an Apache Incubator project and various production houses within eBay are actually running it to perform analytics on large scale datasets. It is designed to provide better performance than Hive?queries for the same dataset and works seamlessly with well-known data visualization tools such as Tableau and Excel, as well as third-party applications. Most ANSI SQL queries are also supported.

Users can run multi-dimensional OLAP queries on 10+ billion rows of data in less than a second. From the perspective of security, Kylin supports integration with LDAP, allowing seamless access for your active directory users and also supports access control at a cube or project level.

The Kylin platform stack comprises of the Kylin Core, which is comprised of the fundamental framework components of Kylin to run the stack that includes the query engine, metadata engine, engine for running the jobs and storage. It also provides the RESTful services to interact with the platform. In addition to Core, Kylin has an integration layer that supports the ETL jobs and provides monitoring and alerting support, an extension layer that allows plugins for extending the security model for single sign-on, storage and other functions and a UI layer that allows developers to create custom interfaces on top of Kylin Core.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

The Latest

How to Manage Your Finances after Buying a Home

How to Manage Your Finances after Buying a Home

Buying a home is a milestone in the journey of life – it’s one way to invest your money and create lasting memories. Now you know everything about a home purchase, home mortgage, and what is a conventional 97 loan but do you know what’s next after you sign the

Windows Logging is one of the vital aspects of any Windows system administration. However, it is mostly overlooked until the system develops a problem. This is because logs contain important information needed to troubleshoot and resolve system issues.

The Fundamentals of Windows Logging

Windows Logging is one of the vital aspects of any Windows system administration. However, it is mostly overlooked until the system develops a problem. This is because logs contain important information needed to troubleshoot and resolve system issues. Without it, tech experts might find it difficult to track a computer’s

Interstitial Ads: Best Practices for Successful Campaigns

Interstitial Ads: Best Practices for Successful Campaigns

Interstitial Ads: Best Practices for Successful Campaigns Interstitial ads are full-screen advertisements that appear to grasp the attention of on-site prospects, creating opportunities for brands seeking effective ways to communicate their proposition of value. With such an attention-grabbing format and high-impact visuals, it’s no wonder why interstitial advertising is proving

positive contribution tech

Technology’s Positive Contributions to Society

Technology has and continues to improve our lives. From the business world to the world of medicine, and our day-to-day lives, you can’t go a day without interacting with at least one form of technology. While some fear technology may be going too far, there are many ways in which

How to Choose From The Best Big Data Platforms in 2023

How to Choose From The Best Big Data Platforms in 2023

As big data continues to become increasingly popular in the business world, companies are always looking for better ways to process and analyze complex data. The process critically depends on the platform that manages and analyzes the data. In this article, we will provide a guide to help you choose