...
Page properties | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Document the state by adding a label to the FLIP page with one of "discussion", "accepted", "released", "rejected".
|
Table of Contents |
---|
Motivation
...
Code Block | ||
---|---|---|
| ||
-- By default, if no time is specified, the system will query data from the latest timestamp. SELECT [column_name(s)] FROM [table_name] -- For example: SELECT * FROM paimon_tb; -- Specify a current-time expression SELECT [column_name(s)] FROM [table_name] FOR SYSTEM_TIME AS OF [current_time expression]; -- For example: SELECT * FROM paimon_tb FOR SYSTEM_TIME AS OF CURRENT_TIMESTAMP; |
Supported Syntax and Types of Timestamp Expression
...
1. Supported Timestamp type
As shown in the above syntax, when querying with time travel, we support specifying a constant expression of time. Therefore, the type corresponding to this expression may be TIMESTAMP or TIMESTAMP_LTZ.
...
By default, it is natural to convert data of type TIMESTAMP_LTZ to Long value. However, if it is a TIMESTAMP type, we will implicitly convert it to TIMESTAMP_LTZ and then convert it to a Long value.
...
2. Supported Expression Syntax
<TIMESTAMP EXPRESSION> must be a valid and executable expression.
...