You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@iceberg.apache.org by GitBox <gi...@apache.org> on 2022/08/19 04:18:35 UTC
[GitHub] [iceberg] hililiwei opened a new pull request, #5581: Spark 3.3: Spark SQL Extensions for query snapshot ref metadata
hililiwei opened a new pull request, #5581:
URL: https://github.com/apache/iceberg/pull/5581
Co-authored-by: chidayong <cd...@163.com>
## What is the purpose of the change
Displaying Branches and Tags
Branches and tags should be able to be queried via Iceberg Metadata Tables. For querying information about refs, syntax like the following could be used:
```sql
SELECT * FROM prod.db.table.refs;
```
The output would look like the following:
Assume the following exist: branch1 at 100, branch2 at 200,
historical_snapshot at 300
```sql
SELECT * FROM prod.db.table.refs;
```
Reference | Type | Snapshot ID | Max Ref Age MS | Min Snapshots To Keep | Max Snapshot Age
-- | -- | -- | -- | -- | --
branch1 | BRANCH | 100 | 9.223e+18 | 10 | 604800000
branch2 | BRANCH | 200 | 9.223e+18 | 15 | 604800000
historical_snapshot | TAG | 300 | 9.223e+18 | NULL | NULL
--
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
[GitHub] [iceberg] hililiwei closed pull request #5581: Spark 3.3: Spark SQL Extensions for query snapshot ref metadata
Posted by GitBox <gi...@apache.org>.
hililiwei closed pull request #5581: Spark 3.3: Spark SQL Extensions for query snapshot ref metadata
URL: https://github.com/apache/iceberg/pull/5581
--
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
[GitHub] [iceberg] hililiwei commented on pull request #5581: Spark 3.3: Spark SQL Extensions for query snapshot ref metadata
Posted by GitBox <gi...@apache.org>.
hililiwei commented on PR #5581:
URL: https://github.com/apache/iceberg/pull/5581#issuecomment-1220281706
@rajarshisarkar Ok, i will close it. Thank you.
--
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
[GitHub] [iceberg] rajarshisarkar commented on pull request #5581: Spark 3.3: Spark SQL Extensions for query snapshot ref metadata
Posted by GitBox <gi...@apache.org>.
rajarshisarkar commented on PR #5581:
URL: https://github.com/apache/iceberg/pull/5581#issuecomment-1220262202
Hi @hililiwei,
We already have an approved PR regarding this feature, please refer: https://github.com/apache/iceberg/pull/4807 ([referenced in proposal doc](https://docs.google.com/document/d/1tbATFPrKF3vNlzkgZQdaW8CAJmbjvryfrlg6C2Ci_aA/edit?disco=AAAAZHOO0mw) as well). The PR should be merged soon and I believe we can close this one.
cc: @rdblue @jackye1995 @amogh-jahagirdar @singhpk234
--
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