https://pinot.apache.org/ logo
#general
Title
# general
d

Deepak Kumar Mishra

03/16/2021, 4:07 AM
Is update query is possible using pinot
m

Mayank

03/16/2021, 4:23 AM
If you mean SQL
update
statement, then no. What's your use case?
d

Deepak Kumar Mishra

03/16/2021, 4:43 AM
we are using some update statement , basically to update new column based on other column in offline table
k

Kishore G

03/16/2021, 4:51 AM
you can use derived column feature for that
v

Vibhor Jain

03/16/2021, 8:37 AM
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.
k

Kishore G

03/16/2021, 2:33 PM
You can use upsert feature