Syntax

HTAP supports the native ClickHouse syntax (case sensitive). For details, see Official documents of ClickHouse.

Pay attention to the following:

When creating a data synchronization task, you can set Table Synchronization to Enabled and perform column operations on the management console. The column operations for table synchronization are implemented through TABLE OVERRIDE. The database synchronization syntax is as follows:

CREATE DATABASE db_name ENGINE = MaterializedMySQL('host:port', 'db_name', 'user', 'password') [SETTINGS ] TABLE OVERRIDE t1 (ORDER BY col1), TABLE OVERRIDE t2 (ORDER BY col2)

TABLE OVERRIDE syntax:

TABLE OVERRIDE table_name ( function_name (col), another_function_name(col2))

Replace function_name with ORDER BY, PARTITION BY, SAMPLE BY, PRIMARY KEY, or TTL.

For details about data synchronization, see Data Synchronization.