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.
Parent topic: Big Data Service Development