curious, does pinot inherently handle duplicate ro...
# general
k
curious, does pinot inherently handle duplicate rows based on some column? ā€¢ Not as of now.
k
@Pradeep In many cases, de-duplication can be done at query time by using DISTINCT. Let me know if this is not an option for you. Maybe we can find a solution.
p
yeah I was aware of that, was just curious if we were to do upload of data from from multiple places and was wondering if there is a way to handle overlaps. not very important at the moment, something that just came to my mind, so thought would ask, thanks.
šŸ‘ 1
k
This is part of the upsert solution
we dont have it yet.
@Kenny Bastani fyi, kafka producers can generate duplicate messages
dedupe during ingestion will make sure that the data is accurate
šŸ‘ 1
p
nice
k
@Pradeep Thanks for asking. I really appreciate you putting together these questions. šŸ‘
šŸ‘ 1