Description
https://docs.databricks.com/delta/quick-start.html#query-an-earlier-version-of-the-table-time-travel
Delta Lake time travel allows user to query an older snapshot of a Delta table. To query an older version of a table, user needs to specify a version or timestamp in a SELECT statement using AS OF syntax as the follows
SELECT * FROM default.people10m VERSION AS OF 0;
SELECT * FROM default.people10m TIMESTAMP AS OF '2019-01-29 00:37:58';
This ticket is opened to add AS OF syntax in Spark
Attachments
Issue Links
- is duplicated by
-
SPARK-34978 Support time-travel SQL syntax
-
- Resolved
-
- links to
