paimon icon indicating copy to clipboard operation
paimon copied to clipboard

[Bug] The StarRocks query for the Paimon system table encounters an error

Open Steven-sxl opened this issue 2 months ago • 1 comments

Search before asking

  • [x] I searched in the issues and found nothing similar.

Paimon version

paimon version 0.8.2

Compute Engine

starrocks version 3.3.6

Minimal reproduce step

MySQL [(none)]> select * from paimon_catalog.paimon_db.test2$snapshots ;

What doesn't meet your expectations?

When I use Starrocks SQL to query Paimon's system tables,the error is as follows: MySQL [(none)]> select * from paimon_catalog.paimon_db.test2$snapshots ; ERROR 1064 (HY000): Invalid metadata table name (unknown type 'snapshots'): test2$snapshots

Anything else?

No response

Are you willing to submit a PR?

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

Steven-sxl avatar Nov 07 '25 06:11 Steven-sxl

I remember that there is a conflicts between starrocks sys table and paimon sys table in starrocks 3.3, you can try a newer version.

mxdzs0612 avatar Nov 12 '25 07:11 mxdzs0612