linzhicong1996 commented on issue #29664:
URL: https://github.com/apache/doris/issues/29664#issuecomment-1880704270
> Please give me the table structure and test data @linzhicong1996
-- 该表结构只有关键字段，全表49个字段
CREATE TABLE `ods_test_table` (
`id` varchar(200) NOT NULL,
`total_volume` varchar(200) NULL,
`check_total_volume` varchar(200) NULL,
`last_updated_on` datetime NOT NULL,
`cases` text NULL,
`is_deleted` boolean NOT NULL DEFAULT "0"',
`update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=OLAP
UNIQUE KEY(`id`)
COMMENT 'OLAP'
DISTRIBUTED BY HASH(`id`) BUCKETS 10
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"is_being_synced" = "false",
"storage_format" = "V2",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "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]
