Hi All, Need we add index (like inverted index) for time column or time column already have index itself? thx

I think that if the entries in the time column are sorted, Pinot will figure that out and automatically add a sorted index.

yes, if a column is sorted Pinot will identify that and add the sorted column. Typically, you don't need to set inv index on time column, either because it is already sorted, or it is partitioned enough (naturally) that Pinot can prune out rows without the need of explicit index.

Thx @User @User 😀