[Feature] Add HTTP API to add physical partition for random distribution tables

[wxl24life]

Why I'm doing:

StarRocks supports automatic bucketing for random distribution tables, where multiple physical partitions (sub-partitions) can exist within a single logical partition.

For cross-cluster data replication scenarios, the target cluster needs the ability to create matching physical partition structures. Since this capability is only used by internal migration tools (not end users), we expose it via ADMIN EXECUTE ON FRONTEND script

What I'm doing:

Fixes #68502

Add a LocalMetastore.addPhysicalPartition(dbName, tableName, partitionName, bucketNum) method that can be invoked via admin execute script:

-- For partitioned tables:
ADMIN EXECUTE ON FRONTEND 'metastore.addPhysicalPartition("db_name", "table_name", "partition_name", 8)';

-- For non-partitioned tables (pass null as partition name):
ADMIN EXECUTE ON FRONTEND 'metastore.addPhysicalPartition("db_name", "table_name", null, 0)';

Parameters:

• dbName: database name
• tableName: table name
• partitionName: partition name (null for non-partitioned tables, required for partitioned tables)
• bucketNum: bucket number (0 to use system default)
  Validation:
• Only OLAP tables with random distribution are supported
• Bucket number must be non-negative and within max_bucket_number_per_partition
• For partitioned tables, partition name must be specified and must exist

What type of PR is this:

• BugFix
• Feature
• Enhancement
• Refactor
• UT
• Doc
• Tool

Does this PR entail a change in behavior?

• Yes, this PR will result in a change in behavior.
• No, this PR will not result in a change in behavior.

If yes, please specify the type of change:

• Interface/UI changes: syntax, type conversion, expression evaluation, display information
• Parameter changes: default values, similar parameters but with different default values
• Policy changes: use new policy to replace old one, functionality automatically enabled
• Feature removed
• Miscellaneous: upgrade & downgrade compatibility, etc.

Checklist:

• I have added test cases for my bug fix or my new feature
• This pr needs user documentation (for new or modified features or behaviors)
  • I have added documentation for my new feature or new function
  • This pr needs auto generate documentation
• This is a backport pr

Bugfix cherry-pick branch check:

• I have checked the version labels which the pr will be auto-backported to the target branch
  • 4.1
  • 4.0
  • 3.5
  • 3.4

[StarRocks-Reviewer]

@cursor review

[StarRocks-Reviewer]

@cursor review

[cursor]

✅ Bugbot reviewed your changes and found no new issues!

Comment @cursor review or bugbot run to trigger another review on this PR

[alvin-celerdata]

@codex review

[chatgpt-codex-connector]

💡 Codex Review

Here are some automated review suggestions for this pull request.

Reviewed commit: 198a753d89

ℹ️ About Codex in GitHub

Your team has set up Codex to review pull requests in this repo. Reviews are triggered when you

• Open a pull request for review
• Mark a draft as ready
• Comment "@codex review".

If Codex has suggestions, it will comment; otherwise it will react with 👍.

Codex can also answer questions or update the PR. Try commenting "@codex address that feedback".

[xiangguangyxg]

is it feasible to reuse addSubPartitions in LocalMetastore?

[wxl24life]

addPhysicalPartition is a wrapper function of addSubPartitions, we need some pre-valication work

[kevincai]

As discussed offline, this HTTP REST API is not necessary.

[wxl24life]

@kevincai Have refactored, please help to change this pr's title, thanks

[github-actions]

[Java-Extensions Incremental Coverage Report]

✅ pass : 0 / 0 (0%)

[github-actions]

[FE Incremental Coverage Report]

✅ pass : 39 / 43 (90.70%)

file detail

	path	covered_line	new_line	coverage	not_covered_line_detail
🔵	com/starrocks/server/LocalMetastore.java	39	43	90.70%	[1793, 1811, 1823, 1831]

[github-actions]

[BE Incremental Coverage Report]

✅ pass : 0 / 0 (0%)

[sonarqubecloud]

Quality Gate passed

Issues
3 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 SonarQube Cloud