Re: Welcome Bret McGuire as Cassandra PMC Member!

2025-05-18 Thread Bret McGuire
Thank you everyone for the kind words! - Bret - On Sat, May 17, 2025 at 11:44 PM Patrick McFadin wrote: > Welcome Bret and congratulations! > > On Sat, May 17, 2025 at 10:46 AM Jaydeep Chovatia < > chovatia.jayd...@gmail.com> wrote: > >> Congratulations! >> >> Jaydeep >> >> On May 16, 2025

Re: [DISCUSS] CEP-48: First-Class Materialized View Support

2025-05-18 Thread Jeff Jirsa
Isn’t the reality here is that repairing a single partition in the base table is potentially a full cluster-wide scan of the MV if you also want to detect rows in the MV that don’t exist in the base table (eg resurrection or a missed delete)There’s no getting around that. Keeping an extra index doe

Re: [DISCUSS] CEP-48: First-Class Materialized View Support

2025-05-18 Thread Jaydeep Chovatia
>Isn’t the reality here is that repairing a single partition in the base table is potentially a full cluster-wide scan of the MV if you also want to detect rows in the MV that don’t exist in the base table (eg resurrection or a missed delete) Exactly. Since materialized views (MVs) are partitioned

Re: [DISCUSS] CEP-48: First-Class Materialized View Support

2025-05-18 Thread Runtian Liu
> If you had a custom SAI index or something, this isn’t something you’d need to worry about This is what I missed. I think this could be a potential solution, but comparing indexes alone isn’t sufficient—it only handles cases where the MV has extra or missing rows. It doesn’t catch data mismatche