Insert into/overwrite partition feature
From Hive you can insert into, or overwrite data in, Iceberg tables that are statically or dynamically partitioned.
You can also insert data into a table using static and dynamic partitions. INSERT OVERWRITE queries do not work on tables that have undergone partition evolution.
Static partition syntax
INSERT INTO|OVERWRITE TABLE name PARTITION(col = val) VALUES (...)
INSERT INTO|OVERWRITE TABLE name PARTITION(col = val) SELECT <expression>Dynamic partition syntax
INSERT INTO|OVERWRITE TABLE name PARTITION(col) VALUES (...)
INSERT INTO|OVERWRITE TABLE name PARTITION(col) SELECT <expression>Static and dynamic partition syntax
Insertion into the static partition must precede the insertion into the dynamic partition.
INSERT INTO|OVERWRITE TABLE name PARTITION(col1 = val, col2) VALUES (...)
INSERT INTO|OVERWRITE TABLE name PARTITION(col1 = val, col2) SELECT <expression>