Hi, I was exploring indexing in pinot and was wondering if it is possible to have columns without any indexing at all. From the doc, had an impression that a column would have atleast one type of indexing. I am currently using Release v0.11.0.

you can have a column with no index

Can you please share how? The configs would help

there is no need to add any config.. by default pinot does not create any index..

isn't the forward indexing enabled by default?

oh.. forward index is always needed.. thats minimal and is the only copy of data

oh okay, we were thinking if it was possible to remove that too as it takes a lot of space and we only needed 2 columns indexed as they are frequently used in WHERE clause

the name index in there is just a way of saying that there is data stored for that column. If you don’t want data for a particular column you’d need to delete the column from the schema and then no data will be ingested. But presumably you do want the non indexed columns to be stored?

Got it. Yes, we want them to be stored.