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’ = ‘’)
iceberg建表与参数
最新推荐文章于 2024-07-12 06:59:03 发布