All imported data is automatically partitioned into hourly buckets, based on the ‘time’ field within each data record.
By specifying the time range in your query, you can avoid reading unnecessary data and can thus speed up your query significantly.
Specify Time as an Integer
When the ‘time’ field is specified within a WHERE clause, the query parser automatically detects which partitions should be processed. This auto-detection does not work if you specify the time with
float instead of
You can use TD_TIME_RANGE to partition data.
However, if you use division in TD_TIME_RANGE, the time partition optimization doesn’t work. For instance, the following conditions disable optimization.
The TD_INTERVAL user defined function is also available for partitioning. TD_INTERVAL provides an intuitive way to specify the time range. For example, to select the last 7 days: