Connection with ClickHouse Command-Line Tool

UClickhouse supports various methods for connecting to instances, including third-party client tools. You can choose the appropriate connection method by considering factors such as maintenance personnel, specific scenarios, and required operations. Below are the steps and operational examples for connecting to a cluster using the ClickHouse command-line tool.

Steps

1. Log in to your XXXCloud account and go to the User Console . In “All Products”, search for or select “Data Warehouse UDW Clickhouse” under data warehouse to enter the UClickhouse Control Panel .

2. On the Cluster List page, click Details to view the list of cluster nodes, where the node addresses are listed.

3. Download the corresponding version of clickhouse-client based on your operating system type and cluster kernel version. Official old version download link: Download Clickhouse-client . Official new version download link: Download Clickhouse-client . For installation, please refer to [Quick Start]

4. Connect to the UClickhouse Cloud Data Warehouse by executing the following command on a cloud host in the same region.

   clickhouse-client --host=<host> --port=<port> --user=<user> --password=<password>; 

Parameter description:

Cluster Operations via HTTP

Steps

1. Log in to your XXXCloud account and go to the User Console . In “All Products”, search for or select “Data Warehouse UDW Clickhouse” under data warehouse to enter the UClickhouse Control Panel .

2. On the Cluster List page, click Details to view the list of cluster nodes, where the node addresses are listed.

3. Connect to the UClickhouse Cloud Data Warehouse by executing the following command on a cloud host in the same region.

   echo "select * from ck_test.lineorder"  |  curl  'http://username:password@any_node_ip_address:8123/' --data-binary @-

JDBC Connection to Database

Steps

1. Use Maven to manage the project and download dependencies:

<dependencies>
    <dependency>
        <groupId>ru.yandex.clickhouse</groupId>
        <artifactId>clickhouse-jdbc</artifactId>
        <version>0.1.40</version>
    </dependency>
</dependencies>

2. Code example:

import java.sql.*;
 
public class JDBC_Clickhouse {
 
    private static Connection connection = null;
 
    static {
            try {
                Class.forName("ru.yandex.clickhouse.ClickHouseDriver");   // Load driver package
                String url = "jdbc:clickhouse://node_ip:8123/system";   // Access URL path, node_ip is the IP of the access node
                String user = "admin";   // Username to log in to the cluster
                String password = "password";  // Password to log in to the cluster
                connection = DriverManager.getConnection(url, user, password);
            } catch (Exception e) {
                e.printStackTrace();
            }
 
    }
    public static void main(String[] args) throws SQLException{
        Statement statement = connection.createStatement();
        ResultSet resultSet = statement.executeQuery("select * from system.clusters");
        ResultSetMetaData metaData = resultSet.getMetaData();
        int columnCount = metaData.getColumnCount();
        while (resultSet.next()) {
            for (int i = 1; i <= columnCount; ++i) {
                System.out.println(metaData.getColumnName(i) + ":" + resultSet.getString(i));
            }
        }
    }
}