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/incubator-paimon.git
The following commit(s) were added to refs/heads/master by this push:
new 0210f6431 [doc] Supplement Hive query examples (#2215)
0210f6431 is described below
commit 0210f64316e982a3b0fcb6b934e7e0d283e3c177
Author: monster <[email protected]>
AuthorDate: Tue Oct 31 15:06:09 2023 +0800
[doc] Supplement Hive query examples (#2215)
---
docs/content/how-to/querying-tables.md | 6 ++++++
1 file changed, 6 insertions(+)
diff --git a/docs/content/how-to/querying-tables.md
b/docs/content/how-to/querying-tables.md
index 286103d12..f45dfb46e 100644
--- a/docs/content/how-to/querying-tables.md
+++ b/docs/content/how-to/querying-tables.md
@@ -134,6 +134,12 @@ Hive requires adding the following configuration
parameters to the hive-site.xml
```
```sql
+-- read the snapshot with id 1L (use snapshot id as version)
+SET paimon.scan.snapshot-id=1
+SELECT * FROM t;
+SET paimon.scan.snapshot-id=null;
+
+-- read the snapshot from specified timestamp in unix seconds
SET paimon.scan.timestamp-millis=1679486589444;
SELECT * FROM t;
SET paimon.scan.timestamp-millis=null;
