xtay573269555 commented on issue #60713:
URL: https://github.com/apache/doris/issues/60713#issuecomment-3956369557
This is the target table structure, and it has an AUTO_INCREMENT column
`__sys_aid`. @zclllyybb
```
CREATE TABLE `table_mask` (
`fct_bid` varchar(64) NOT NULL COMMENT 'xxxxxx',
`exec_time` datetime NOT NULL COMMENT 'xxxxxx',
`testcase_result_id` varchar(64) NULL COMMENT 'xxxxxx',
`data_area` varchar(64) NOT NULL COMMENT 'xxxxxx',
`project_sk` bigint NULL COMMENT 'xxxxxx',
`product_id` bigint NULL COMMENT 'xxxxxx',
`testplan_id` bigint NULL COMMENT 'xxxxxx',
`testcase_id` bigint NULL COMMENT 'xxxxxx',
`operator_user_sk` bigint NULL COMMENT 'xxxxxx',
`exec_type` varchar(64) NULL COMMENT 'xxxxxx',
`result` varchar(64) NULL COMMENT 'xxxxxx',
`external_id` varchar(256) NULL COMMENT 'xxxxxx',
`__sys_env` tinyint NULL COMMENT 'xxxxxx',
`__sys_seq` datetime NULL COMMENT 'xxxxxx',
`__sys_ctime` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'xxxxxx',
`__sys_utime` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'xxxxxx',
`__sys_aid` bigint NOT NULL AUTO_INCREMENT(1) COMMENT 'xxxxxx',
`__sys_phdel` tinyint NULL
) ENGINE=OLAP
UNIQUE KEY(`fct_bid`, `exec_time`)
COMMENT 'xxxxxx',
AUTO PARTITION BY RANGE (date_trunc(`exec_time`, 'year'))
(PARTITION p_before_2020 VALUES [('0000-01-01 00:00:00'), ('2020-01-01
00:00:00')),
PARTITION p20220101000000 VALUES [('2022-01-01 00:00:00'), ('2023-01-01
00:00:00')),
PARTITION p20230101000000 VALUES [('2023-01-01 00:00:00'), ('2024-01-01
00:00:00')),
PARTITION p20240101000000 VALUES [('2024-01-01 00:00:00'), ('2025-01-01
00:00:00')),
PARTITION p20250101000000 VALUES [('2025-01-01 00:00:00'), ('2026-01-01
00:00:00')),
PARTITION p_after_2050 VALUES [('2050-01-01 00:00:00'), (MAXVALUE)))
DISTRIBUTED BY HASH(`fct_bid`) BUCKETS 12
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"min_load_replica_num" = "-1",
"is_being_synced" = "false",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V1",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"function_column.sequence_col" = "__sys_seq",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "67108864",
"enable_mow_light_delete" = "false"
);
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
