Hi team, I'm facing an issue while querying a MyS...
# questions-and-troubleshooting
s
Hi team, I'm facing an issue while querying a MySQL JDBC catalog from StarRocks. What works: • The catalog is created successfully. •
SHOW 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:
Copy code
ERROR 1064 (HY000): Could not resolve
Example:
Copy code
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!