blob: 64d3d5b1f1a936c72175a06d132512e0f5217801 [file] [log] [blame]
-- 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"
);