Hi team, I believe it is possible to apply inverte...
# general
p
Hi team, I believe it is possible to apply inverted index on multiple columns. Any idea on how it is stored? All the documentation I have seen so far give examples of inverted index on only 1 column. I would like to apply inverted index on multiple columns in an optimized way.
s
Pinot is a columnar store, so inverted index or any other index on the column is stored on a per-column basis. An inverted index of one column is independent of inverted index of another column.