Shivansh Mittal
11/17/2025, 1:17 PMSHOW CATALOGS; lists it.
• SHOW DATABASES FROM <catalog>; works and correctly lists all MySQL databases.
• SHOW TABLES FROM <catalog>.<db>; also works.
What doesn’t work:
Whenever I try to run a SELECT query on any table inside the catalog, I get:
ERROR 1064 (HY000): Could not resolve
Example:
SELECT id, title
FROM mysql_read_replica.<db_name>.<table_name>
LIMIT 5;
Other notes:
• I confirmed that the catalog uses jdbc_uri (not url) as required in the JDBC catalog documentation.
• Connection test shows the catalog is reachable from StarRocks.
• MySQL permissions for the user seem correct (we’re able to connect from outside using the same credentials).
• No additional warnings in SHOW WARNINGS.
Despite being able to browse the catalog metadata, StarRocks fails to resolve table paths during query execution.
Could you help me understand what might be going wrong or what additional diagnostics I should run?
Thanks!