| -- Please note that the database here should be consistent with doris.database in the file where the connector is registered. | |
| CREATE TABLE string_msg.partial_update_tab ( | |
| id INT NULL, | |
| col1 VARCHAR(20) NULL, | |
| col2 varchar(20) NULL, | |
| col3 varchar(20) NUll | |
| ) ENGINE=OLAP | |
| UNIQUE KEY(`id`) | |
| COMMENT 'OLAP' | |
| DISTRIBUTED BY HASH(`id`) BUCKETS AUTO | |
| PROPERTIES ( | |
| "replication_allocation" = "tag.location.default: 1", | |
| "light_schema_change"="true", | |
| "enable_unique_key_merge_on_write" = "true" | |
| ); |