Support materialized views and secondary indexes with tablets

[bhalevy]

This epic tracks issues preventing full support of MV and SI for tablets-enabled tables.

Tasks

Preview Give feedback

1. Explicitly forbid to create MV on a Tablets based keyspace #21832
   P2 area/tablets backport/2025.1-done +3
   
2. Lowered view consistency during tablet merge (unless replica order is preserved) #17265
   P1 area/elastic cloud area/materialized views area/tablets +4
   
3. [dtest, tablets] test_create_lots_of_indexes_concurrently fails with tablets: Expected a row count of 1 in query "select * from base_X where c2 = Y", but got 0 #17603
   P2 area/materialized views area/tablets +3
   

   
4. [tablets] test_remove_node_during_index_build: AssertionError: Expected a row count of 100000 in query "SELECT * FROM b_index_index", but got 99639 #18826
   P1 area/elastic cloud area/materialized views area/tablets symptom/ci stability tests/dtest +6
   

   
5. Tablet migration and view update from staging don't interact well #19149
   P1 area/elastic cloud area/materialized views area/tablets symptom/data consistency +5
   
6. Repair of a table that has views must wait until view update generation completes #19727
   P2 area/materialized views area/repair area/tablets backport/none +5
   
7. Lowered consistency of materialized views in tablet-enabled keyspaces during node replace #19767
   area/materialized views area/tablets +2
   
8. Potential node crash when doing base-view pairing after decreasing RF #21492
   P1 area/materialized views area/tablets backport/6.1 backport/6.2 bug +6
   

   
9. Tablet migration during view creation can cause base view inconsistencies #21564
   area/materialized views area/tablets symptom/data consistency +3