xylaaaaa commented on issue #69884: URL: https://github.com/apache/doris/issues/69884#issuecomment-6597444084
Compared PR head `338108051b` with a local build that reverses only [the shared statistics-consumption change](https://github.com/apache/doris/pull/69904/commits/598756e03ef6c0786fcd87b2c99891799512fea0). Delta's versioned asynchronous row count, DV subtraction and same-version CRC fallback were present in both builds. With the stock FE table-level row-count cache, the filesystem, HMS and Hive gateway catalogs all showed the same results on retained data. For the 3-row basic table and the 35-row checkpoint table with deletion vectors, `EXPLAIN` estimated 74 and 1, respectively, both initially and after 65 seconds. SQL `COUNT(*)` returned 3 and 35 throughout. The effective default refresh interval was 10 minutes. In a separate run with a **local-only** 1-minute refresh interval, all three catalogs reported the precise estimates by 72 seconds. The FE refreshes on access asynchronously. The existing shared change controls when ordinary CBO plans see completed statistics. Restoring master's policy for every connector would also restore that delay for Delta and would not meet the current 60-second statistics-readiness test. The comparison build and all 81 focused FE tests passed. The published PR head is unchanged while the freshness requirement is being discussed. -- 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]
