[Enhancement] Compatible with msql use 'truncate' to delete partitions (backport #9667)

[mergify[bot]]

This is an automatic backport of pull request #9667 done by Mergify. Cherry-pick of c99118789cc072eb3018a51c39745305c5818fb3 has failed:

On branch mergify/bp/branch-2.4/pr-9667
Your branch is up to date with 'origin/branch-2.4'.

You are currently cherry-picking commit c99118789.
  (fix conflicts and run "git cherry-pick --continue")
  (use "git cherry-pick --skip" to skip this patch)
  (use "git cherry-pick --abort" to cancel the cherry-pick operation)

Changes to be committed:
	modified:   fe/fe-core/src/main/java/com/starrocks/alter/Alter.java
	modified:   fe/fe-core/src/main/java/com/starrocks/alter/AlterOpType.java
	modified:   fe/fe-core/src/main/java/com/starrocks/alter/AlterOperations.java
	new file:   fe/fe-core/src/main/java/com/starrocks/analysis/TruncatePartitionClause.java
	modified:   fe/fe-core/src/main/java/com/starrocks/sql/ast/AstVisitor.java
	modified:   fe/fe-core/src/main/java/com/starrocks/sql/parser/AstBuilder.java
	modified:   fe/fe-core/src/main/java/com/starrocks/sql/parser/StarRocks.g4
	new file:   fe/fe-core/src/test/java/com/starrocks/analysis/TruncatePartitionClauseTest.java
	modified:   fe/fe-core/src/test/java/com/starrocks/sql/analyzer/AstBuilderTest.java

Unmerged paths:
  (use "git add <file>..." to mark resolution)
	both modified:   fe/fe-core/src/test/java/com/starrocks/alter/AlterTest.java

To fix up this pull request, you can check it out locally. See documentation: https://docs.github.com/en/github/collaborating-with-pull-requests/reviewing-changes-in-pull-requests/checking-out-pull-requests-locally

---

Mergify commands and options

More conditions and actions can be found in the documentation.

You can also trigger Mergify actions by commenting on this pull request:

• @Mergifyio refresh will re-evaluate the rules
• @Mergifyio rebase will rebase this PR on its base branch
• @Mergifyio update will merge the base branch into this PR
• @Mergifyio backport <destination> will backport this PR on <destination> branch

Additionally, on Mergify dashboard you can:

• look at your merge queues
• generate the Mergify configuration with the config editor.

Finally, you can contact us on https://mergify.com

[waittttting]

run starrocks_tscancode

[waittttting]

run all

[waittttting]

run all