The Timestamp index accelerates time-based queries by pre-computing and indexing multiple time granularities to optimize filtering and grouping operations.
dateTrunc()
or dateTimeConvert()
$${ts_column_name}$${ts_granularity}
.dateTrunc('DAY', timestamp_col)
are automatically rewritten to use the pre-computed columns, dramatically reducing computation overhead.event_time
with configured granularities DAY, MONTH, and YEAR:
$event_time$DAY
- containing day-level timestamps$event_time$MONTH
- containing month-level timestamps$event_time$YEAR
- containing year-level timestampsdateTrunc('MONTH', event_time)
, it’s automatically rewritten to use the $event_time$MONTH
column instead of computing this transformation during query execution.dateTrunc('YEAR', event_time) = '2022'
would use the $event_time$YEAR
column’s range index for efficient filtering.MILLISECOND
SECOND
MINUTE
HOUR
DAY
WEEK
MONTH
QUARTER
YEAR
TIMESTAMP
data type.