Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using ClickHouse/ Enterprise-Class Enhancements of ClickHouse/ Configuring the Connection Between ClickHouse and Open-Source ClickHouse
Updated on 2024-12-13 GMT+08:00

Configuring the Connection Between ClickHouse and Open-Source ClickHouse

This section applies to MRS 3.3.0-LTS.1 or later.

Scenario

For clusters in normal mode (Kerberos authentication disabled), you need to configure CLICKHOUSE_OPENSOURCE_COMMUNITY to connect to the open-source or other vendors' ClickHouse. For clusters in security mode (Kerberos authentication enabled), the connection is not supported.

Parameter Configuration

  1. Log in to FusionInsight Manager and choose Cluster > Services > ClickHouse. Click Configurations then All Configurations, click ClickHouseServer(Role) > Security, and search for and modify the following parameters.

    Parameter

    Description

    CLICKHOUSE_OPENSOURCE_COMMUNITY

    Whether to support the connection to the open-source ClickHouse. The default value is false, indicating that ClickHouse cannot be connected to an open-source ClickHouse. Value true indicates that ClickHouse can be connected to an open-source ClickHouse.

  1. Click Save. In the displayed dialog box, click OK to save the configuration. Choose Instances, select ClickHouseServer, and click More > Instance Rolling Restart.