Load or replace partition data feature

There is no difference in the way you load or replace data into a partitioned or unpartitioned Iceberg table.

Working with partitions is easy because you write the query in the same way for the following operations:

  • Insert into, or replace, an unpartitioned table
  • Insert into, or replace, an identity partitioned table
  • Insert into, or replace, a transform-partitioned table
INSERT INTO ice_t VALUES (42, 'impala', now(), to_date(now()));

INSERT OVERWRITE ice_t VALUES (42, 'impala', now(), to_date(now()));

Do not use INSERT OVERWRITE on tables that went through partition evolution. Truncate such tables first, and then INSERT the tables.