HIVE-28341: Iceberg: Change Major QB Full Table Compaction to compact…

[difin]

… partition by partition

What changes were proposed in this pull request?

Change Major QB Full Table Compaction to compact partition by partition

Why are the changes needed?

Currently, Iceberg Major compaction compacts a whole table in one step. If a table is partitioned and has a lot of data this operation can take a lot of time and it risks getting write conflicts at the commit stage. This PR proposes to improve it to work partition by partition. Also, for each partition it will create one snapshot instead of 2 snapshots (truncate+IOW) created now when compacting the whole table in one step.

Does this PR introduce any user-facing change?

No

Is the change a dependency upgrade?

No

How was this patch tested?

New query test added and updated existing iceberg compaction query tests with the new correct expected results.

[sonarqubecloud[bot]]

Quality Gate passed

Issues
10 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarCloud