Puffin statistics feature

Impala supports writing Puffin statistics files for Iceberg V3 tables. Puffin statistics files store deletion vectors as sidecar files and provide a standardized container for column statistics metadata.

Puffin is a lightweight container format for arbitrary binary blobs. Iceberg Puffin statistics support is a prerequisite for Iceberg V3 capabilities in Impala.

To use Puffin statistics from Impala, create an Iceberg V3 table by setting 'format-version'='3'. When Impala performs supported V3 write operations, Impala writes Puffin files as required by the Iceberg V3 specification; you need not run a new SQL syntax to enable Puffin statistics writes.

For deletion vectors on V3 tables, see Delete data feature.

CREATE TABLE ice_3 (i INT, s STRING) STORED BY ICEBERG TBLPROPERTIES
  ('format-version'='3');

INSERT INTO ice_3 VALUES (1, 'one'), (2, 'two');

DELETE FROM ice_3 WHERE i = 2;