hililiwei commented on code in PR #6222:
URL: https://github.com/apache/iceberg/pull/6222#discussion_r1040606681
##########
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:
done
--
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
