Is update query is possible using pinot

If you mean SQL

update

statement, then no. What's your use case?

we are using some update statement , basically to update new column based on other column in offline table

you can use derived column feature for that

Hi All, what is the general approach preferred for retrofitting old data? I see that MS teams uses Pinot. Now if I sent a msg via teams and later updated that, how can such use case be handled in Pinot? Suggestions welcome.

You can use upsert feature