Hi folks! The documentation about Sorted Inverted Index doesn't tell how to configure that; How can that be done?

I'm already creating inverted indexes and I understood that if a column is sorted Pinot will create a sorted index for it, but what about "sorted inverted" ones? I just have to define a column that is sorted before ingestion that it should have an inverted index then? There's no specific configuration for "sorted inverted", at least I didn't find it there

That is just saying that sorted forward index also duals as inverted index. There isn’t and additional sorted inverted index. It is a bit confusing, could we make it more readable @Mark Needham

Ah, ok then. So if the column is already sorted I don't need to do anything, just ingest it, right?

For real-time I recommend specifying it as sorted in table config

It's for offline ingestion

Ok, then if data is already sorted, that is enough

Ah, cool. Thanks man!

will edit the docs

I'll take a look, thanks man. I'll use for offline tables though.

haha, I explored that too 😄 https://www.markhneedham.com/blog/2022/01/19/apache-pinot-sorted-indexes-offline-tables/

I'll take a look, thanks for the heads up 🙂