Hey Pinot I have few questions regarding how Pinot handles 2 concurrency cases
• CASE 1: If I have a batch of transaction and in that batch I have two transactions modifying my single record how pinot handle it.
• CASE 2: If my multithreaded application trying to change a single record at a same time what will happen.
m
Mayank
08/26/2023, 2:52 PM
First to clarify, Pinot is not a transactional database. Having said that, it supports upsert, which resolves based on time column configured