Configuring the Connection Between ClickHouse and Open-Source ClickHouse

Scenario

For clusters in normal mode (Kerberos authentication disabled), you need to configure CLICKHOUSE_OPENSOURCE_COMMUNITY to connect to 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.

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