Presto, an open-source distributed SQL query engine, excels at querying large data sets distributed across diverse data sources. It has maintained its

Time Travel for Iceberg Tables in Presto

submited by

Style Pass

2024-05-09 16:30:07

Presto, an open-source distributed SQL query engine, excels at querying large data sets distributed across diverse data sources. It has maintained its position as a high-performance data analytics tool for over a decade.

As data collection capabilities expand, businesses increasingly recognize the importance of historical data alongside current data. With the recent release of Presto version 0.286, a powerful capability has emerged: time travel queries on iceberg tables.

Time Travel queries, utilizing constructs like “AS OF” predicates, allow you to delve into historical data, analyze trends, retrieve specific information, reconstruct datasets, and even audit the evolution of data — all without requiring any modifications to table definitions.

With the introduction of Presto release 0.286, users now can execute time travel queries on Iceberg tables using either the snapshot ID or timestamp of the records. This release specifically supports time travel queries based on SYSTEM_VERSION and SYSTEM_TIME.