iceberg建表与参数

最新推荐文章于 2025-09-20 10:28:10 发布

原创最新推荐文章于 2025-09-20 10:28:10 发布 · 591 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#数据仓库

Iceberg 专栏收录该内容

5 篇文章

订阅专栏

CREATE TABLE catlog.database.table1(
date INT COMMENT ‘’,
id STRING COMMENT ‘’,
status INT COMMENT ‘’,
status_duration BIGINT COMMENT ‘’)
USING iceberg
PARTITIONED BY (date)
COMMENT ‘’
LOCATION ‘’
TBLPROPERTIES(
‘current-snapshot-id’ = ‘none’,
‘format’ = ‘iceberg/parquet’,
‘format.version’ = ‘1’,
‘metacat.reserved.comment’ = ‘’,
‘metacat.reserved.lifecycle.day’ = ‘-1’,
‘metacat.reserved.security.level.l1’ = ‘’,
‘metacat.reserved.security.level.l2’ = ‘’,
‘metacat.reserved.security.level.l3’ = ‘’,
‘metacat.reserved.security.level.l4’ = ‘’,
‘read.parquet.vectorization.enabled’ = ‘true’,
‘read.split.target-size’ = ‘134217728’,
‘snapshot.lifecycle.minutes’ = ‘2880’,
‘table-optimize-priority’ = ‘balanced-priority’,
‘write.avro.compression-codec’ = ‘zstd’,
‘write.avro.compression-level’ = ‘-5’,
‘write.distribution-mode’ = ‘hash’,
‘write.parquet.compression-codec’ = ‘zstd’,
‘write.parquet.compression-level’ = ‘1’,
‘write.parquet.row-group-size-bytes’ = ‘134217728’,
‘write.target-file-size-bytes’ = ‘536870912’,
‘write.watermark.field’ = ‘’)