Updated on 2025-07-24 GMT+08:00

ClickHouse Usage Process

ClickHouse is a columnar database oriented to online analysis and processing. It is independent of the Hadoop big data system and features compression rate and fast query performance. In addition, ClickHouse supports SQL query and provides good query performance, especially the aggregation analysis and query performance based on large and wide tables. The query speed is one order of magnitude faster than that of other analytical databases. CloudTable ClickHouse cluster management also provides the following functions:

In ClickHouse cluster management, you need to create a dedicated cluster and can use it on demand. Dedicated clusters are physically isolated and are not affected by other services, facilitating user management.

After the ClickHouse cluster is created, use the client to access the cluster. For details, see the following sections.

  • Using a Client to Access a ClickHouse Cluster.
  • Getting Started with ClickHouse.
    Figure 1 ClickHouse Usage Process
    Table 1 ClickHouse usage process

    Step

    Substep

    Description

    Detailed Instructions

    Preparations

    Creating a user and granting permissions to use CloudTable

    • Before using CloudTable ClickHouse, you need to register a Huawei Cloud account, complete real-name authentication, and grant the necessary permissions to your account.
    • Grant the necessary service permissions to a user group, and then add users to this group to enable their access.

    Creating a User and Granting Permissions

    Creating a cluster

    Creating a ClickHouse cluster

    Before using ClickHouse to execute tasks, you need to create a ClickHouse cluster.

    Creating a ClickHouse Cluster

    Downloading the client

    Downloading the ClickHouse client

    After creating a cluster, download and install the client. After the client is installed, you can use the SSH tool to connect to the cluster.

    Installing the ClickHouse Client

    Preparing an ECS

    -

    If the client tool runs on Linux, you need to prepare a Linux ECS that is in the VPC as a ClickHouse cluster and the Linux ECS serves as a client host.

    If the client tool runs on Windows, you need to prepare a Windows ECS that is in the VPC as a ClickHouse cluster and the Windows ECS serves as a client host.

    Preparing an ECS

    Installing the client

    -

    Place the downloaded client on the ECS, decompress the package, and install the client.

    Using a Client to Connect to a ClickHouse Normal Cluster

    Connecting to the cluster

    -

    After installing the MySQL client on the ECS, you can run commands to connect to the cluster and perform service operations.

    Installing the ClickHouse Client