This is an automated email from the ASF dual-hosted git repository.
zjureel pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-paimon.git
The following commit(s) were added to refs/heads/master by this push:
new c6fd8f2f0 [docs] Unify the files table doc format with other system
tables (#1670)
c6fd8f2f0 is described below
commit c6fd8f2f00bbbf7d4eeebcf17da31cb6529ff273
Author: GuojunLi <[email protected]>
AuthorDate: Thu Jul 27 14:30:04 2023 +0800
[docs] Unify the files table doc format with other system tables (#1670)
---
docs/content/how-to/system-tables.md | 8 +++++++-
1 file changed, 7 insertions(+), 1 deletion(-)
diff --git a/docs/content/how-to/system-tables.md
b/docs/content/how-to/system-tables.md
index 65e5612f9..f82d8d10e 100644
--- a/docs/content/how-to/system-tables.md
+++ b/docs/content/how-to/system-tables.md
@@ -131,9 +131,11 @@ SELECT * FROM MyTable$audit_log;
## Files Table
You can query the files of the table with specific snapshot.
-```
+```sql
-- Query the files of latest snapshot
SELECT * FROM MyTable$files;
+
+/*
+-----------+--------+--------------------------------+-------------+-----------+-------+--------------+--------------------+---------+---------+------------------------+-------------------------+-------------------------+-----------------------+
| partition | bucket | file_path | file_format |
schema_id | level | record_count | file_size_in_bytes | min_key | max_key |
null_value_counts | min_value_stats | max_value_stats |
creation_time |
+-----------+--------+--------------------------------+-------------+-----------+-------+--------------+--------------------+---------+---------+------------------------+-------------------------+-------------------------+-----------------------+
@@ -145,9 +147,12 @@ SELECT * FROM MyTable$files;
| [4] | 0 | data-2c9b7095-65b7-4013-a7a... | orc |
0 | 0 | 1 | 593 | [a] | [a] | {cnt=0,
val=0, word=0} | {cnt=4, val=12, word=a} | {cnt=4, val=12, word=a}
|2023-02-24T16:06:21.166|
+-----------+--------+--------------------------------+-------------+-----------+-------+--------------+--------------------+---------+---------+------------------------+-------------------------+-------------------------+-----------------------+
6 rows in set
+*/
-- You can also query the files with specific snapshot
SELECT * FROM MyTable$files /*+ OPTIONS('scan.snapshot-id'='1') */;
+
+/*
+-----------+--------+--------------------------------+-------------+-----------+-------+--------------+--------------------+---------+---------+------------------------+-------------------------+-------------------------+-----------------------+
| partition | bucket | file_path | file_format |
schema_id | level | record_count | file_size_in_bytes | min_key | max_key |
null_value_counts | min_value_stats | max_value_stats |
creation_time |
+-----------+--------+--------------------------------+-------------+-----------+-------+--------------+--------------------+---------+---------+------------------------+-------------------------+-------------------------+-----------------------+
@@ -156,6 +161,7 @@ SELECT * FROM MyTable$files /*+
OPTIONS('scan.snapshot-id'='1') */;
| [1] | 0 | data-10abb5bc-0170-43ae-b6a... | orc |
0 | 0 | 1 | 595 | [a] | [a] | {cnt=0,
val=0, word=0} | {cnt=1, val=11, word=a} | {cnt=1, val=11, word=a}
|2023-02-24T16:06:21.166|
+-----------+--------+--------------------------------+-------------+-----------+-------+--------------+--------------------+---------+---------+------------------------+-------------------------+-------------------------+-----------------------+
3 rows in set
+*/
```
## Tags Table
