You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@iceberg.apache.org by "djcelis (via GitHub)" <gi...@apache.org> on 2023/03/03 18:56:06 UTC
[GitHub] [iceberg] djcelis opened a new issue, #7000: Documentation improvements in regards to time travel
djcelis opened a new issue, #7000:
URL: https://github.com/apache/iceberg/issues/7000
Hello,
In https://iceberg.apache.org/docs/latest/spark-queries/#time-travel the documentation states that the keywords `TIMESTAMP AS OF`, `VERSION AS OF`, `FOR SYSTEM_TIME AS OF` and `FOR SYSTEM_VERSION AS OF` are supported for Spark 3.3 and later.
However, after checking the tests, we also learnt the following "undocumented" SQL syntax works in Spark 3.1 and 3.2:
```
String prefix = "snapshot_id_";
// read the table at the snapshot
List<Object[]> actual = sql("SELECT * FROM %s.%s", tableName, prefix + snapshotId);
```
https://github.com/apache/iceberg/blob/ce0d075e4014743cb80dac774c3804ff8051070a/spark/v3.1/spark/src/test/java/org/apache/iceberg/spark/sql/TestSelect.java#L153
https://github.com/apache/iceberg/blob/ce0d075e4014743cb80dac774c3804ff8051070a/spark/v3.2/spark/src/test/java/org/apache/iceberg/spark/sql/TestSelect.java#L155
We tested the syntax and it works fine as `SELECT * FROM <your-db>.<your-table>.snapshot_id.<desired-snapshot-id> ` and it would be great to have it documented as a supported way/alternative for those using SQL in Spark 3.1 and 3.2
--
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: issues-unsubscribe@iceberg.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
Re: [I] Documentation improvements in regards to time travel [iceberg]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #7000:
URL: https://github.com/apache/iceberg/issues/7000#issuecomment-1876137932
This issue has been closed because it has not received any activity in the last 14 days since being marked as 'stale'
--
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: issues-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
Re: [I] Documentation improvements in regards to time travel [iceberg]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #7000: Documentation improvements in regards to time travel
URL: https://github.com/apache/iceberg/issues/7000
--
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: issues-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
Re: [I] Documentation improvements in regards to time travel [iceberg]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #7000:
URL: https://github.com/apache/iceberg/issues/7000#issuecomment-1865301197
This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.
--
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: issues-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org