stevenzwu commented on code in PR #6222:
URL: https://github.com/apache/iceberg/pull/6222#discussion_r1039841272
##########
docs/flink-getting-started.md:
##########
@@ -712,9 +712,188 @@ INSERT INTO tableName /*+
OPTIONS('upsert-enabled'='true') */
| compression-strategy | Table write.orc.compression-strategy |
Overrides this table's compression strategy for ORC tables for this write
|
-## Inspecting tables.
+## Inspecting tables
-Iceberg does not support inspecting table in flink sql now, we need to use
[iceberg's Java API](../api) to read iceberg's meta data to get those table
information.
+To inspect a table's history, snapshots, and other metadata, Iceberg supports
metadata tables.
+
+Metadata tables are identified by adding the metadata table name after the
original table name. For example, history for `db.table` is read using
`db.table$history`.
+
+### History
+
+To show table history:
+
+```sql
+SELECT * FROM prod.db.table$history;
+```
+
+| made_current_at | snapshot_id | parent_id |
is_current_ancestor |
+| ----------------------- | ------------------- | ------------------- |
------------------- |
+| 2019-02-08 03:29:51.215 | 5781947118336215154 | NULL | true
|
+| 2019-02-08 03:47:55.948 | 5179299526185056830 | 5781947118336215154 | true
|
+| 2019-02-09 16:24:30.13 | 296410040247533544 | 5179299526185056830 | false
|
+| 2019-02-09 16:32:47.336 | 2999875608062437330 | 5179299526185056830 | true
|
+| 2019-02-09 19:42:03.919 | 8924558786060583479 | 2999875608062437330 | true
|
+| 2019-02-09 19:49:16.343 | 6536733823181975045 | 8924558786060583479 | true
|
+
+{{< hint info >}}
+**This shows a commit that was rolled back.** The example has two snapshots
with the same parent, and one is *not* an ancestor of the current table state.
Review Comment:
maybe more explicit?
In this example, snapshot 296410040247533544 and 2999875608062437330 have
the same parent snapshot 5179299526185056830. Snapshot 296410040247533544 was
rolled back and is *not* an ancestor of the current table state.
--
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-unsubscr...@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@iceberg.apache.org
For additional commands, e-mail: issues-h...@iceberg.apache.org
