Updated on 2022-12-14 GMT+08:00

How Do I Enable the Map Type on ClickHouse?

  1. Log in to the active Master node as user root.
  2. Run the following command to modify the /opt/Bigdata/components/current/ClickHouse/configurations.xml configuration file to enable user parameter customization:

    vim /opt/Bigdata/components/current/ClickHouse/configurations.xml

    Change hidden to advanced, as shown in the following information in bold. Then save the configuration and exit.
    <property type="hidden" scope="all" classification="Customization" classdesc="RESID_CLICKHOUSE_CONF_0056">
            <name>_clickhouse.custom_content.key</name>
            <value>_user-xml-content</value>
    </property>
    <property type="advanced" scope="all" classification="Customization" classdesc="RESID_CLICKHOUSE_CONF_0056">
           <name>_user-xml-content</name>
           <value vType="text" checker="clickhouse.xmlformat">&lt;yandex&gt;&lt;/yandex&gt;</value>
           <description>RESID_CLICKHOUSE_CONF_0025</description>
    </property>

  3. Run the following commands to switch to user omm and restart the controller service:

    su - omm

    sh /opt/Bigdata/om-server/om/sbin/restart-controller.sh

  4. Log in to FusionInsight Manager, choose Cluster > Services > ClickHouse. On the page that is displayed, click the Configurations tab then the All Configurations sub-tab. Click ClickHouseServer(Role) > Customization, and add the following content to the _user-xml-content configuration item in the right pane:

    <yandex>
      <profiles>
        <default>
       <allow_experimental_map_type>1</allow_experimental_map_type>
        </default>
      </profiles>
    </yandex>

  5. Click Save.
  6. Choose Cluster > Services > ClickHouse. In the upper right corner, choose More > Restart Service to restart the ClickHouse service.