matianhe3 commented on issue #5610: URL: https://github.com/apache/seatunnel/issues/5610#issuecomment-1759055049
> Can you give us more details? Examples include the StarRocks version and Mysql & StarRocks DDl `starrocks 3.1` maybe this problem , now for me, i import by sql `where dt between '' and '' ` to limit once data lower than 1 million, and run many times.  ``` CREATE TABLE `mkt_record` ( `server_time` datetime NOT NULL COMMENT "", `dt` date NOT NULL COMMENT "", `id` bigint(20) NULL COMMENT "", `keyword` varchar(65533) NULL COMMENT "", `city` varchar(65533) NULL COMMENT "", `realcity` varchar(65533) NULL COMMENT "", `ver` varchar(65533) NULL COMMENT "", `imei` varchar(65533) NULL COMMENT "", `channel` varchar(65533) NULL COMMENT "", `uid` int(11) NULL COMMENT "", `os` varchar(65533) NULL COMMENT "", `lands` int(11) NULL COMMENT "", `m_usercode` varchar(65533) NULL COMMENT "", `m_username` varchar(65533) NULL COMMENT "", `m_roomid` int(11) NULL COMMENT "", `m_channel` varchar(65533) NULL COMMENT "", `m_addtime` datetime NULL COMMENT "", `m_updatetime` datetime NULL COMMENT "", `m_searchcode` varchar(65533) NULL COMMENT "", `m_type` int(11) NULL COMMENT "" ) ENGINE=OLAP DUPLICATE KEY(`server_time`) PARTITION BY date_trunc('day', dt) DISTRIBUTED BY HASH(`dt`) PROPERTIES ( "replication_num" = "3", "in_memory" = "false", "enable_persistent_index" = "false", "replicated_storage" = "true", "partition_live_number" = "100", "compression" = "LZ4" ); ``` -- 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]
