i added a sorted inverted index on one field, and now i am not able to add inverted index on another fields. is that expected? i am using a derived field

event_ts_5_min

which represents start of a 5 minute time bucket. would it even make sense to add inverted index on

event_ts_5_min

?

test_id

is a filter in all queries. I did read

A sorted index performs much better than an inverted index, but it can only be applied to one column per table.

in the documentation but didn't think that i can't apply inverted index on other fields.

what do you mean by you cannot add inverted index on another field? what’s the error?

i was adding

event_ts_5_min

to the list of fields with inverted index, and i think that's why it wasn't working as it is already using raw value forward index. adding another field worked fine. sorry for false alert.