${ts_column_name}${ts_granularity}
, e.g. Timestamp column ts
with granularities DAY
, MONTH
will have two extra columns generated: $ts$DAY
and $ts$MONTH
.dateTrunc('DAY', ts)
will be translated to use the underly column $ts$DAY
to fetch data.
2.2 PREDICATE: range index is auto-built for all granularity columns.TIMESTAMP
as part of the indexTypes
. Then in the field timestampConfig, specify the granularities that you want to index.