tibrewalpratik17 commented on issue #11796: URL: https://github.com/apache/pinot/issues/11796#issuecomment-1765210093
> for my learning, could you please share some examples about this confusing behavior? thanks <img width="634" alt="Screenshot 2023-10-17 at 1 47 30 AM" src="https://github.com/apache/pinot/assets/23629228/732d1529-7051-4d89-a475-4b450271478d";> The 1st column here is `$segmentName` and the last column is the comparison column. The 5th record is an out-of-order event and it gets persisted with 3rd and 4th column as zeros though the user was expecting some non-null (non-zero) value given they have previously sent non-null values for the same columns. This is a partial-upsert table and the user is using `skipUpsert`. This leads to confusion as they are not able to identify out-of-order events via query. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
