This is an automated email from the ASF dual-hosted git repository. michaelsmith pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/impala.git
commit 1a74ee03f337e236d718b6672a1dd33191664d34 Author: Michael Smith <[email protected]> AuthorDate: Tue Oct 14 10:39:17 2025 -0700 IMPALA-14500: Clarify usage of SYSTEM_VERSION Clarifies that SYSTEM_VERSION in Iceberg queries refers to a snapshot id. Change-Id: I64c4dc9ce82af320602f8de7c435242aa2f90d77 Reviewed-on: http://gerrit.cloudera.org:8080/23543 Tested-by: Impala Public Jenkins <[email protected]> Reviewed-by: Quanlong Huang <[email protected]> --- docs/topics/impala_iceberg.xml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/docs/topics/impala_iceberg.xml b/docs/topics/impala_iceberg.xml index c9d4689e4..f8e180685 100644 --- a/docs/topics/impala_iceberg.xml +++ b/docs/topics/impala_iceberg.xml @@ -698,8 +698,8 @@ OPTIMIZE TABLE [<varname>db_name</varname>.]<varname>table_name</varname> [FILE_ </p> <p> - We can use the <codeph>FOR SYSTEM_TIME AS OF</codeph> and <codeph>FOR SYSTEM_VERSION AS OF</codeph> - clauses in <codeph>SELECT</codeph> queries, e.g.: + We can use the clauses <codeph>FOR SYSTEM_TIME AS OF</codeph> with a timestamp and + <codeph>FOR SYSTEM_VERSION AS OF</codeph> with a snapshot id in <codeph>SELECT</codeph> queries, e.g.: <codeblock> SELECT * FROM ice_t FOR SYSTEM_TIME AS OF '2022-01-04 10:00:00'; SELECT * FROM ice_t FOR SYSTEM_TIME AS OF now() - interval 5 days;
