[Feature] support bucket join when the table has same bucket function type

### Search before asking

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

### Motivation

we disable the bucket join when bucket function type is not `paimon` now. We should enable it after introduced other bucket function types.

### 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 bucket join implementation and the check that currently permits only the `paimon` bucket function type. Read the surrounding bucket-function handling and existing tests, if present, to determine how matching types are represented. Done means bucket joins are enabled when both tables use the same bucket function type, with coverage for the supported types.

Written by the indexing model from the issue text.