BaoHuaWang opened a new issue, #11141:
URL: https://github.com/apache/paimon/issues/11141

   ### Search before asking
   
   - [x] I searched in the [issues](https://github.com/apache/paimon/issues) 
and found nothing similar.
   
   
   ### Paimon version
   
   
   CREATE TABLE IF NOT EXISTS paimon_catalog.soc.fw_error_log (
       dt                  DATE          COMMENT '日期分区',
       deviceSn           STRING        COMMENT '设备SN',
       logType           STRING        COMMENT '日志类型',
       msg STRING        COMMENT '原始数据',
       insertTime             TIMESTAMP  COMMENT '插入时间'
   )
   PARTITIONED BY (dt)
   WITH (
         -- 表类型:追加表,只新增无更新
       'table-type' = 'append-table',
   
       -- Parquet 文件配置
       'file.format' = 'parquet',
       'file.compression' = 'zstd',
       'file.compression.zstd-level' = '3',
       'target-file-size' = '256mb',
       -- 分桶:租户ID + 设备SN(驼峰字段对齐)
       'bucket' = '12',
       'bucket-key' = 'deviceSn',
   
       -- 分区TTL:365天自动清理过期分区
       'partition.legacy-name' = 'false',
       'partition.expiration-strategy' = 'values-time',
       'partition.expiration-time' = '90d',
       'partition.expiration-check-interval' = '4h',
       'partition.timestamp-formatter' = 'yyyy-MM-dd',
       'partition.timestamp-pattern' = '$dt',
   
       -- 快照保留策略
       'snapshot.time-retained' = '7d',
       'snapshot.num-retained.min' = '50',
       'snapshot.num-retained.max' = '60',
       'snapshot.clean-empty-directories' = 'true',
       'snapshot.expire.execution-mode'='async',
   
   
   );
   
   
   ### Compute Engine
   
   flink
   
   ### Minimal reproduce step
   
   flink-sql
   
   ### What doesn't meet your expectations?
   
   not 
   
   ### Anything else?
   
   not
   
   ### Are you willing to submit a PR?
   
   - [x] I'm willing to submit a PR!


-- 
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]

Reply via email to