timestamp(columnName) elects a
Creates a designated timestamp column in the result of a query.
The output query must be ordered by time.
TIMESTAMP() does not check for order
and using timestamp functions on unordered data may produce unexpected results.
Dynamic timestamp allows to perform time series operations such as
SAMPLE BY or
LATEST BY on tables which do not have a
The following creates a table with designated timestamp.
The following will query a table and assign a
designated timestamp to the output. Note
the use of brackets to ensure the timestamp clause is applied to the result of
the query instead of the whole
readings table does not have a designated timestamp, we are able
to create one on the fly. Now, we can use this into a subquery to perform
If the data is unordered, it is important to order it first.