timeshift¶
Type of operation: Metadata, Metrics
Description¶
Shifts the timestamps of rows ahead in time by the specified
interval. If the interval is negative, the intervals are shifted back
in time. If used with non-temporal verbs (exists
, follow
, etc.), timeshift
will return incomplete data.
Usage¶
timeshift interval
Argument |
Type |
Optional |
Repeatable |
Restrictions |
---|---|---|---|---|
interval |
duration |
no |
no |
none |
Accelerable¶
timeshift is always accelerable if the input is accelerable. A dataset that only uses accelerable verbs can be accelerated, making queries on the dataset respond faster.
Examples¶
timeshift 1h
Shifts the timestamps of all rows ahead by 1 hour, e.g. a row whose timestmap is 12pm will now be 1pm.
timeshift -1h
Shifts the timestamps of all rows back by 1 hour, e.g. a row whose timestmap is 12pm will now be 11am.