Hi Folks, We have a field of LONG data type which was earlier mentioned as "dimensionField" in our schema. This field stored the time in epoch milliseconds. Using this schema the data was loaded. However, we now want to make this field "metricField" so that we can apply range indexing to it. When we tried to update the schema it resulted in the error

Backward incompatible schema <schemaName>.Only allow adding new columns

What can be the way to proceed ?

Should this not be a datetimefield? Think we can have multiple although not sure how pinot deals with multiple time indexes. Think to update you need to drop table, schema and recreate.

Yeah, backward incompatible changes to schema are not allowed.

btw you dont need to move the field just to apply range index. Range index can be applied to dimensionField