anuragrai16 opened a new issue, #17262: URL: https://github.com/apache/pinot/issues/17262
**Problem**: We have seen issue with a [recently introduced configuration](https://github.com/apache/pinot/pull/16432) of skip segment CRC check when load a segment during server start or pre-downloading. The issues with this flag and its edge cases are covered in [depth here.](https://github.com/apache/pinot/issues/17233) While the fix has the last premise, we need a long-term reliable way to generate a deterministic CRC from the segment, so we dont need to selectively enable flags at the table level to skip CRC checks. As mentioned in the last ticket, we started with the problem statement as : `As Pinot segment today include many variety of indexes and data, it becomes increasingly hard or infeasible to use CRC to verify segment consistency across replicas. Examples include Lucene text index which has by design non-deterministic behavior during indexing. There should be a revamp on how to use and create CRC when loading segments. This PR just creates option for users to opt out. It has been tested in our production env for a while for Pinot table with text index without issues.` To remove the indeterminism of CRC mismatch for future index types added in Pinot without needing to skip the CRC check to work around this. **Proposed Solution:** - We will compute a data-only CRC and persist to ZK for every new segment. The data-only CRC is computed using the forward index files, dictionary files inverted index files and the metadata.properties files. While forward indexes are enough to capture the column level data deterministically, Pinot also supports [disabling forward indexes for some columns.](https://docs.pinot.apache.org/basics/indexing/forward-index) So, to work around this, we include both the dictionary files and inverted indexes in the data-only CRC calculation. - This data-only CRC will be persisted in ZK in-addition to existing full segment CRC, allowing us to not undertake a migration from old CRC (that uses all segment files) to new CRC (data-only files) - During the segment CRC check performed at various places (like pre-download, deep-store download), we will use the data-crc to compare segments when data-crc is available. If the data-crc is not available, we will fallback to the full CRC. **Edge Cases:** - Even with data only CRC computed, data can be different in cases when we use [Ingestion transformation functions like NOW()](https://docs.pinot.apache.org/functions/supported-transformations), which causes the individual replica of segments to evaluate them locally and cause different data. This case is a valid case of re-downloading the segment on replicas, since the underlying data should be same for all replicas of the segment. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
