layout: page title: “Apache Kylin Interpreter for Apache Zeppelin” description: “Apache Kylin™ is an open source Distributed Analytics Engine designed to provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop supporting extremely large datasets, original contributed from eBay Inc. .” group: interpreter

{% include JB/setup %}

Apache Kylin Interpreter for Apache Zeppelin

Overview

Apache Kylin is an open source Distributed Analytics Engine designed to provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop supporting extremely large datasets, original contributed from eBay Inc. The interpreter assumes that Apache Kylin has been installed and you can connect to Apache Kylin from the machine Apache Zeppelin is installed.
To get start with Apache Kylin, please see Apache Kylin Quickstart.

Configuration

Using the Apache Kylin Interpreter

In a paragraph, use %kylin(project_name) to select the kylin interpreter, project name and then input sql. If no project name defined, will use the default project name from the above configuration.

%kylin(learn_project)
select count(*) from kylin_sales group by part_dt