timestamp(columnName) elects a
Checking if tables contain a designated timestamp column can be done via the
table_columns() functions which are described in the
meta functions documentation page.
Creates a designated timestamp column in
the result of a query. Assigning a timestamp in a
dynamic timestamp) allows for 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.