rdblue commented on pull request #3269: URL: https://github.com/apache/iceberg/pull/3269#issuecomment-961518873
For the branching and time travel discussion, I think it is valuable to be able to use `VERSION AS OF` to select a branch, like `SELECT * FROM db.table VERSION AS OF branch` in addition to `SELECT * FROM db.table VERSION AS OF 39874172309487` with a snapshot ID. Time travel by timestamp would then select from the main branch, as was suggested. To support both time travel by timestamp _and_ branches at the same time, I think it is natural to use another level of multi-part identifier, like `db.table.branch`. I think that putting the branch name in the identifier is a more natural way to manage branches in the first place, so it works well with `AS OF` like this: `db.table.branch TIMESTAMP AS OF 2021-11-04T10:00:00`. The reason why I think we should consider supporting a branch name in `VERSION AS OF` is so that we have something that may be portable across systems that don't support more than db and table in table identifiers, like Trino. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
