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.

  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 cloud account 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 Using a Client to Connect to a ClickHouse Security 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