Revisit all indexes to account for DELETE_PARTITION

[hudi-bot]

Not all indexes are strictly consistent after DELETE_PARTITION. Files is consistent and we made partition stats consistent in HUDI-8345. However, column_stats is only eventually consistent. Basically, the stats for replaced filegroups get deleted when those file groups are cleaned. This is ok because we don't use column_stats in partition pruning. But, we should consider making this check general and make other index types also consider the {{DELETE_PARTITION}} write operation in a distinct way? 
#12953 (comment)

JIRA info

• Link: https://issues.apache.org/jira/browse/HUDI-9171
• Type: Sub-task
• Parent: https://issues.apache.org/jira/browse/HUDI-9096
• Fix version(s):
  • 1.1.0