wuchunfu commented on issue #9876: URL: https://github.com/apache/seatunnel/issues/9876#issuecomment-3336590963
> Could you share the original timestamp value from Doris? [@wuchunfu](https://github.com/wuchunfu) ```sql CREATE TABLE `test_table` ( `name` VARCHAR(64) NOT NULL, `app_id` VARCHAR(255) NOT NULL, `partition_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `city_id` INT NOT NULL DEFAULT "1" COMMENT '城市编码' ) ENGINE=OLAP DUPLICATE KEY(`name`) COMMENT '测试表' PARTITION BY RANGE(`partition_time`) (PARTITION p_20250901 VALUES [('2025-09-01 00:00:00'), ('2025-09-02 00:00:00')), PARTITION p_20250902 VALUES [('2025-09-02 00:00:00'), ('2025-09-03 00:00:00')), PARTITION p_20250903 VALUES [('2025-09-03 00:00:00'), ('2025-09-04 00:00:00')), PARTITION p_20250904 VALUES [('2025-09-04 00:00:00'), ('2025-09-05 00:00:00')), PARTITION p_20250905 VALUES [('2025-09-05 00:00:00'), ('2025-09-06 00:00:00')), PARTITION p_20250906 VALUES [('2025-09-06 00:00:00'), ('2025-09-07 00:00:00')), PARTITION p_20250907 VALUES [('2025-09-07 00:00:00'), ('2025-09-08 00:00:00')), PARTITION p_20250908 VALUES [('2025-09-08 00:00:00'), ('2025-09-09 00:00:00')), PARTITION p_20250909 VALUES [('2025-09-09 00:00:00'), ('2025-09-10 00:00:00')), PARTITION p_20250910 VALUES [('2025-09-10 00:00:00'), ('2025-09-11 00:00:00')), PARTITION p_20250911 VALUES [('2025-09-11 00:00:00'), ('2025-09-12 00:00:00')), PARTITION p_20250912 VALUES [('2025-09-12 00:00:00'), ('2025-09-13 00:00:00')), PARTITION p_20250913 VALUES [('2025-09-13 00:00:00'), ('2025-09-14 00:00:00')), PARTITION p_20250914 VALUES [('2025-09-14 00:00:00'), ('2025-09-15 00:00:00')), PARTITION p_20250915 VALUES [('2025-09-15 00:00:00'), ('2025-09-16 00:00:00')), PARTITION p_20250916 VALUES [('2025-09-16 00:00:00'), ('2025-09-17 00:00:00')), PARTITION p_20250917 VALUES [('2025-09-17 00:00:00'), ('2025-09-18 00:00:00')), PARTITION p_20250918 VALUES [('2025-09-18 00:00:00'), ('2025-09-19 00:00:00')), PARTITION p_20250919 VALUES [('2025-09-19 00:00:00'), ('2025-09-20 00:00:00')), PARTITION p_20250920 VALUES [('2025-09-20 00:00:00'), ('2025-09-21 00:00:00')), PARTITION p_20250921 VALUES [('2025-09-21 00:00:00'), ('2025-09-22 00:00:00')), PARTITION p_20250922 VALUES [('2025-09-22 00:00:00'), ('2025-09-23 00:00:00')), PARTITION p_20250923 VALUES [('2025-09-23 00:00:00'), ('2025-09-24 00:00:00')), PARTITION p_20250924 VALUES [('2025-09-24 00:00:00'), ('2025-09-25 00:00:00')), PARTITION p_20250925 VALUES [('2025-09-25 00:00:00'), ('2025-09-26 00:00:00')), PARTITION p_20250926 VALUES [('2025-09-26 00:00:00'), ('2025-09-27 00:00:00')), PARTITION p_20250927 VALUES [('2025-09-27 00:00:00'), ('2025-09-28 00:00:00')), PARTITION p_20250928 VALUES [('2025-09-28 00:00:00'), ('2025-09-29 00:00:00')), PARTITION p_20250929 VALUES [('2025-09-29 00:00:00'), ('2025-09-30 00:00:00'))) DISTRIBUTED BY HASH(`name`) BUCKETS 1 PROPERTIES ( "replication_allocation" = "tag.location.default: 1", "min_load_replica_num" = "-1", "is_being_synced" = "false", "storage_medium" = "hdd", "storage_format" = "V2", "inverted_index_storage_format" = "V1", "light_schema_change" = "true", "disable_auto_compaction" = "false", "enable_single_replica_compaction" = "false", "group_commit_interval_ms" = "10000", "group_commit_data_bytes" = "134217728" ); ``` <img width="629" height="87" alt="Image" src="https://github.com/user-attachments/assets/5d8add87-adab-456a-8478-733822c9b2dd"; /> @dybyte -- 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]
