article thumbnail

Materialized Views in Hive for Iceberg Table Format

Cloudera

Subsequently, these snapshot IDs are used to determine the delta changes that should be applied to the materialized view rows. Hive does this by asking the Iceberg library to return only the rows inserted since that table’s last snapshot when the materialized view was last rebuilt/created.

article thumbnail

How to Use Apache Iceberg in CDP’s Open Lakehouse

Cloudera

Time Travel: Reproduce a query as of a given time or snapshot ID, which can be used for historical audits and rollback of erroneous operations, as an example. 6 2003 6488540. We see that as of the first snapshot ( 7445571238522489274) we had data from the years 1995 to 2005 in the table. 1 2008 7009728. 2 2007 7453215.