[Feature] Integrate the partition expire with the chain table

### Search before asking

- [x] I searched in the [issues](https://github.com/apache/paimon/issues) and found nothing similar.

### Motivation

The chain table's partition expire strategy should be adjusted to the chain semantic

### Solution

_No response_

### Anything else?

_No response_

### Are you willing to submit a PR?

- [ ] I'm willing to submit a PR!

Start by locating the chain table implementation and its partition-expire strategy, then read the surrounding chain-table semantics. Done means the expiration behavior follows those semantics and is covered by relevant tests; the issue names no files or tests, so further project research is required.

Written by the indexing model from the issue text.