What are the methods for installing and using the Kylin system?

2 years ago
Olivia Parker
3 minutes

Kylin is an open-source distributed analytics engine designed for querying and analyzing large-scale datasets. Here are the installation and usage instructions for the Kylin system:

  1. Ensuring the system meets Kylin requirements.
  1. Operating system: Linux or Windows Server
  2. Java edition: JDK 1.8 or above
  3. Memory: It is recommended to have a minimum of 16GB.
  4. Storage: It is recommended to have at least 1TB of hard drive space.
  1. Download and install Kylin:
  1. Download the latest stable version from the official Kylin website (https://kylin.apache.org).
  2. Unzip the downloaded files to the specified directory.
  1. Set up Kylin
  1. Navigate to the installation directory of Kylin, edit the kylin.properties file in the conf folder, and configure parameters such as Hadoop, Hive, Zookeeper, etc.
  2. Edit the conf/kylin_job_conf.xml file to configure parameters for scheduling tasks, such as Job Engine and Job CPU.
  1. Start Kylin.
  1. Use the command “bin/kylin.sh start” on Linux or “bin/kylin.bat start” on Windows to start the Kylin service.
  1. Access the Kylin Web interface:
  1. Open the web browser and enter the URL for the Kylin Web interface, which is http://localhost:7070/kylin by default.
  2. Log in using the default username and password (admin/admin).
  1. Create and import data sources:
  1. Click on the “Data Source” tab in the Kylin Web interface, and then click on the “Create Data Source” button.
  2. Provide relevant information for configuring a data source, including name, description, database type, connection URL, username, and password.
  3. Click on the “Test Connection” button, then click on the “Save” button after confirming the successful connection.
  4. On the “Data Source” tab, click on the created data source, click the “Import Data” button, select the table and columns to import, and then click the “Import” button.
  1. Designing and building a Cube:
  1. Click on the “Cube” tab in the Kylin Web interface, then click on the “Create Cube” button.
  2. Configure the Cube with relevant information, including name, description, data model, data source, dimensions, and measures.
  3. Click on the “Save and Build” button and wait for Cube to finish building.
  1. Data research and analysis:
  1. In the Kylin Web interface, click on the “Query” tab, enter the query statement, and click on the “Query” button to retrieve data.
  2. Kylin also offers OLAP analysis function, which allows for multidimensional analysis and data mining in the “Insight” tab.

This is a simple overview of the installation and usage methods for the Kylin system, actual steps may vary based on individual circumstances. It is recommended to refer to the official Kylin documentation for detailed understanding and operation.

bannerAds