[Feature]: Support `SHOW PARTITIONS` and `DROP PARTITIONS ` for MIXED-ICEBERG format table

[baiyangtx]

Description

Support partition management sql for mixed-iceberg table in Spark.

SHOW PARTITIONS;                        #list all partitions in this table

ALTER TABLE {table_name} DROP PARTITION (truncates(cols,10) == 1100 ) ;

Use case/motivation

No response

Describe the solution

The show partitios could reuse the spark command.

The alter table ... drop partition ... maybe need to extend spark sql grammar.

Subtasks

No response

Related issues

No response

Are you willing to submit a PR?

• [ ] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[github-actions[bot]]

This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.

[zhoujinsong]

Any process for this issue? @baiyangtx

[github-actions[bot]]

This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.

[github-actions[bot]]

This issue has been closed because it has not received any activity in the last 14 days since being marked as 'stale'