[CASSANDRA-16076] Batch schema statements to create multiple SASI and MV at once to reduce disk IO

• Type: New Feature
• Status: Open
• Priority: Normal
• Resolution: Unresolved
• Fix Version/s: 5.x
• Component/s: Feature/Materialized Views, Feature/SASI
• Change Category: Operability
• Complexity: Normal
• Platform: All
• Assignee: Unassigned
• Reporter: Zhao Yang
• Created: 27/Aug/20 06:54
• Updated: 07/Mar/23 10:53

Description

Currently, operator has to create SASI/MV one by one on the same table and every index/view build will need to read all data on disk.

In order to speed up multiple SASI/MV creation, I propose to add a new batch schema statement to create multiple SASI/MV at once, so that C* only needs to read on-disk data once.

Issue Links

• relates to: CASSANDRA-15921 4.0 quality testing: Materialized View