This is an automated email from the ASF dual-hosted git repository.
lzljs3620320 pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/paimon.git
The following commit(s) were added to refs/heads/master by this push:
new feb5be7a4e [docs] Add documentation for file key ranges table (#7502)
feb5be7a4e is described below
commit feb5be7a4e93c4e51dc3aafb0ef423b00e379028
Author: sanshi <[email protected]>
AuthorDate: Sun Mar 22 21:30:05 2026 +0800
[docs] Add documentation for file key ranges table (#7502)
---
docs/content/concepts/system-tables.md | 20 ++++++++++++++++++++
1 file changed, 20 insertions(+)
diff --git a/docs/content/concepts/system-tables.md
b/docs/content/concepts/system-tables.md
index 0b8feed61c..5d90b590d4 100644
--- a/docs/content/concepts/system-tables.md
+++ b/docs/content/concepts/system-tables.md
@@ -278,6 +278,26 @@ SELECT * FROM my_table$files /*+
OPTIONS('scan.snapshot-id'='1') */;
*/
```
+### File Key Ranges Table
+
+You can query the key ranges and file location of each data file through the
file key ranges table.
+This is useful for diagnosing data distribution and Global Index coverage.
+
+```sql
+SELECT * FROM my_table$file_key_ranges;
+
+/*
++-----------+--------+--------------------------------+-------------+-----------+-------+--------------+--------------------+---------+---------+--------------+
+| partition | bucket | file_path | file_format |
schema_id | level | record_count | file_size_in_bytes | min_key | max_key |
first_row_id |
++-----------+--------+--------------------------------+-------------+-----------+-------+--------------+--------------------+---------+---------+--------------+
+| {3} | 0 | data-8f64af95-29cc-4342-adc... | orc |
0 | 0 | 1 | 593 | [c] | [c] |
1 |
+| {2} | 0 | data-8b369068-0d37-4011-aa5... | orc |
0 | 0 | 1 | 593 | [b] | [b] |
2 |
+| {1} | 0 | data-10abb5bc-0170-43ae-b6a... | orc |
0 | 0 | 1 | 595 | [a] | [a] |
3 |
++-----------+--------+--------------------------------+-------------+-----------+-------+--------------+--------------------+---------+---------+--------------+
+3 rows in set
+*/
+```
+
### Tags Table
You can query the tag history information of the table through tags table,
including which snapshots are the tags based on
