How to use TIMESTAMP / VERSION to time travel #18461
Unanswered
jestingthomas
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
As per the iceberg docs, I see that time travel is possible using below two methods:-
SELECT * FROM db.table TIMESTAMP AS OF '1986-10-26 01:21:00';
SELECT * FROM db.table VERSION AS OF 10963874102873;
Does presto support both, and if yes, can anybody share the query ?
Below is the error I get when using


TIMESTAMP AS OF
VERSION AS OF
Beta Was this translation helpful? Give feedback.
All reactions