Kyligence Robot (KyBot) GA 1.5 Release Note

10 - 16 - 2017

Kyligence Robot (KyBot) is an online service for Apache Kylin users to optimize usage and performance. Built on the foundation and experience of helping hundreds of companies from banking and telecom to e-commerce and manufacturing who use Apache Kylin with their Big Data operations, KyBot provides intelligent optimization and tuning suggestions for common issues, such as slow SQL, skew cube storage, and MapReduce/Spark job performance.

KyBot System Dashboard

Key Features:

System Dashboard
System Dashboard provides quick insight into Apache Kylin clusters to conduct health inspection. It provides an overview of cube, query, job, storage, and user activity that can help your team perform runtime status evaluation and resource planning.

Intelligent Advisor
Intelligent Advisor automatically generates optimization suggestions using Machine Learning. It provides modeling suggestions to help your team easily optimize data modeling, cube design and query performance with no Apache Kylin expertise needed. Applying these suggestions will allow your team to focus more time on business needs and less on technical details.

Cube Optimizer
Cube Optimizer provides a Data Model Score to expose any cube defects that may inhibit your data operations, such as poor query performance, slow job, wrong model design, insufficient cube usage, and skew storage. To fix such defects, Cube Optimizer recommends best practice cube design that includes ideal dimensions, aggregation group settings, measurement settings, encoding algorithms, and rowkeyorders.

Job Diagnostics
Users can quickly identify job bottleneck and receive suggested solution with the visualization of the entire lifecycle of cube-building jobs.

Slow SQL Analysis
Some SQL analysis are mission critical for users that cannot suffer from slow performance. KyBot can pinpoint these slow SQL bottlenecks and provide suggested optimization measures by visualizing the entire query execution plan.

Knowledge Base
Users can find answers to their technical questions by leveraging articles of best practices and Q&A about Apache Kylin, based on the experience of hundreds of real-life use cases from in different industries, from banking and telecom to e-commerce and manufacturing.

Client Support
Service-Level Agreement support for commercial users with ticket management, log analysis and access to Apache Kylin experts.

Other Features:

One-Click Diagnostic Package Upload
Users can easily upload diagnostic package with custom time to KyBot in one click in Kyligence Analytic Platform (KAP), the enterprise version of Apache Kylin.

Auto Diagnostic Package Upload
With auto-upload enabled, KAP will automatically upload diagnostic packages to KyBot periodically.

KyBot currently supports Apache Kylin 1.5 and above and all versions of KAP. For more information, please visit

Recent Post

Apache Kylin v2.5.0 Release Announcement

Apache Kylin v2.5.0 Release Announcement

Sep 20, 2018 • Shaofeng Shi The Apache Kylin community is pleased to announce the release of Apache Kylin v2.5.0. Apache Kylin is an open source Distributed Analytics Engine designed to provide SQL interface and multi-dimensional analysis (OLAP) on Big Data supporting extremely large datasets. This is a major release after 2.4.0. There are many […]
Read More

Quick Start Guide: Kyligence Enterprise on Microsoft Azure Marketplace

Quick Start Guide: Kyligence Enterprise on Microsoft Azure Marketplace

Chapter 1: Take the First Steps to Explore Kyligence Enterprise   In this section, you will learn to install Kyligence Enterprise on a new HDInsight cluster and play with the sample cube using Kyligence Enterprise, highlighting some of the most common tasks. In fact, you can either create a new cluster or use an existing […]
Read More

Scale Your OLAP to Petabytes on Google Cloud Platform

Scale Your OLAP to Petabytes on Google Cloud Platform

Kyligence – the company behind Apache Kylin – announces that its enterprise OLAP (online analytical processing) engine on Hadoop – Kyligence Enterprise – can now run on Google Cloud Platform. Highly integrated with Google Cloud Storage and DataProc, Kyligence scales your OLAP to petabytes of data, make your BI applications work on your data lakes. […]
Read More