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
-
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
![image](https://user-images.githubusercontent.com/53165049/194366107-0e66c1e2-0c2b-42cf-bbda-c441b7fdc056.png)
![image](https://user-images.githubusercontent.com/53165049/194366426-c6e21128-2ce5-4f5d-b175-3d13cbb6f6f4.png)
TIMESTAMP AS OF
VERSION AS OF
Beta Was this translation helpful? Give feedback.
All reactions