Support pk index major compaction in cloud native table

[TszKitLo40]

• [Feature] Support pk index major compaction in cloud native table (backport #41737) #46002
• [Feature] Support pk index major compaction in cloud native table #41737

Feature request

Is your feature request related to a problem? Please describe.

Local table has supported pk index major compaction which will decrease publish timeout. But cloud native table doesn't not support yet.
Describe the solution you'd like

Support pk index major compaction in cloud native table.
Describe alternatives you've considered

Additional context