Creating Report in Apache Kylin with SSB Sample Data

In this article, we will guide you through the process of creating a report in Apache Kylin using the SSB (Star Schema Benchmark) sample data. This tutorial is designed for entry-level users, so no prior experience with Apache Kylin is required.

What is Apache Kylin?

Apache Kylin is an open-source Online Analytical Processing (OLAP) engine designed for large data sets, which allows users to perform complex queries on massive datasets with low latency. It is built on top of Apache Hadoop and is part of the Apache Software Foundation.

What is the SSB Sample Data?

The SSB (Star Schema Benchmark) is a benchmark used for evaluating the performance of OLAP engines. It consists of a set of data files that are used to generate a star schema database. The data files include a fact table and several dimension tables. In this tutorial, we will use the SSB sample data to create a report in Apache Kylin.

Prerequisites

Before we begin, make sure you have the following prerequisites:

• Apache Kylin installed and configured on a Hadoop cluster.
• SSB sample data downloaded and extracted.

Step 1: Import the SSB Sample Data

The first step is to import the SSB sample data into Apache Kylin. To do this, follow these steps:

1. Log in to the Apache Kylin web interface.
2. Click on the "Data Model" tab and then click on the "Create Model" button.
3. Select "Load Data" from the list of available options.
4. Select "Hive" from the list of available data sources.
5. Enter the Hive database name and table name for the SSB sample data.
6. Click on the "Load Data" button to import the data.

Step 2: Create a Data Model

The next step is to create a data model for the SSB sample data. To do this, follow these steps:

1. Click on the "Data Model" tab and then click on the "Create Model" button.
2. Select "Create Model from Hive" from the list of available options.
3. Select the Hive database and table that you imported in Step 1.
4. Click on the "Next" button to proceed to the next step.
5. Select the fact table and the dimension tables for the data model.
6. Click on the "Next" button to proceed to the next step.
7. Configure the data model settings, such as the granularity, measures, and filters.
8. Click on the "Next" button to proceed to the next step.
9. Review the data model and click on the "Save" button to create the data model.

Step 3: Create a Cube

The next step is to create a cube for the data model. To do this, follow these steps:

1. Click on the "Cube" tab and then click on the "Create Cube" button.
2. Select the data model that you created in Step 2.
3. Configure the cube settings, such as the cube name, segments, and partitioning.
4. Click on the "Next" button to proceed to the next step.
5. Review the cube settings and click on the "Save" button to create the cube.

Step 4: Create a Report

The final step is to create a report using the cube. To do this, follow these steps:

1. Click on the "Report" tab and then click on the "Create Report" button.
2. Select the cube that you created in Step 3.
3. Configure the report settings, such as the report name, dimensions, and measures.
4. Click on the "Save" button to create the report.

Congratulations! You have successfully created a report in Apache Kylin using the SSB sample data.

In this article, we have provided a step-by-step guide to creating a report in Apache Kylin using the SSB sample data. This tutorial is designed for entry-level users, so no prior experience with Apache Kylin is required. By following these steps, you can create a report in Apache Kylin and start analyzing your data.

References