[HUDI-8530] Error out secondary index update for write operations such as insert overwrite where it is not supported

[lokeshj1703]

Change Logs

For overwrite related write operations like insert overwrite, insert overwrite table and delete partition operations we need to throw an error indicating that secondary index update is not supported with these operations. We would be adding the support of such operations in a separate jira. Currently the user would need to drop and recreate the index after the operation.

Impact

INSERT_OVERWRITE, INSERT_OVERWRITE_TABLE and DELETE_PARTITION would throw error if secondary index is enabled

Risk level (write none, low medium or high below)

low

Documentation Update

INSERT_OVERWRITE, INSERT_OVERWRITE_TABLE and DELETE_PARTITION would throw error if secondary index is enabled. Index needs to be dropped and recreated after the operation

Contributor's checklist

• [ ] Read through contributor's guide
• [ ] Change Logs and Impact were stated clearly
• [ ] Adequate tests were added if applicable
• [ ] CI passed

[nsivabalan]

there are some test failures. can you check it out. @lokeshj1703

[codope]

I've fixed the test failures. Should be good to land after they pass.

[hudi-bot]

CI report:

• 18af42ffaec1ae1032b71219e89947ae2d0c0e92 UNKNOWN
• 9661618b7d8c4d2521b80b37d798773276f2e403 Azure: SUCCESS

Bot commands

@hudi-bot supports the following commands: - `@hudi-bot run azure` re-run the last Azure build