[Bug] [hive] insert hive table select from paimon oom

### Search before asking

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

### Paimon version

0.8

### Compute Engine

hive

### Minimal reproduce step

insert into hive table select * from paimon table limit 10

### What doesn't meet your expectations?

it seems limit push down is invalid

### Anything else?

_No response_

### Are you willing to submit a PR?

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

Start by reproducing the query in the issue with Paimon 0.8 and the Hive compute engine: insert into a Hive table by selecting from a Paimon table with LIMIT 10. Trace the Hive insert and limit-pushdown path while capturing the out-of-memory failure. Done means the query completes without OOM and the limit is correctly respected.

Written by the indexing model from the issue text.