[CASSANDRA-12245] initial view build can be parallel

• Type: Improvement
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 4.0-alpha1, 4.0
• Component/s: Feature/Materialized Views
• Assignee: Andres de la Peña
• Reporter: Tom van der Woerdt

Authors

Andres de la Peña

Reviewers

Paulo Motta

• Created: 20/Jul/16 09:59
• Updated: 15/May/20 08:06
• Resolved: 01/Dec/17 14:06

Description

On a node with lots of data (~3TB) building a materialized view takes several weeks, which is not ideal. It's doing this in a single thread.

There are several potential ways this can be optimized :

• do vnodes in parallel, instead of going through the entire range in one thread
• just iterate through sstables, not worrying about duplicates, and include the timestamp of the original write in the MV mutation. since this doesn't exclude duplicates it does increase the amount of work and could temporarily surface ghost rows (yikes) but I guess that's why they call it eventual consistency. doing it this way can avoid holding references to all tables on disk, allows parallelization, and removes the need to check other sstables for existing data. this is essentially the 'do a full repair' path

Issue Links

• relates to: CASSANDRA-13762 Ensure views created during (or just before) range movements are properly built
• relates to: CASSANDRA-10654 Make MV streaming rebuild parallel