wypoon edited a comment on pull request #3269: URL: https://github.com/apache/iceberg/pull/3269#issuecomment-959782628
@huaxingao please confirm the SQL syntax that is agreed to in Spark (I'm looking at some Databricks blog for Delta Lake time travel): ``` SELECT * FROM t TIMESTAMP AS OF <timestamp>; SELECT * FROM t VERSION AS OF <version>; ``` where `timestamp` is something like "2019-01-01 01:30:00.000" and `version` for us would be the snapshot id. Is that correct? @pvary unfortunately that will not match the syntax supported by Hive and Impala, but it will be similar. @rdblue given that support for AS OF in Spark will only be in a future Spark release, what do you think we can do to support identifying the snapshot (or timestamp) for loading a table in Iceberg now? We need this to support reading the snapshot using the correct schema (as is now done for Spark 2.4). -- 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]
