Mycat2
Mycat2 copied to clipboard
单库分表,查询日志报错
单库分表,错误日志
INFO | jvm 1 | 2022/04/18 19:20:28 | 2022-04-18 19:20:28,495[ERROR]io.mycat.sqlhandler.ShardingSQLHandler.onExecute:61SELECT * INFO | jvm 1 | 2022/04/18 19:20:28 | FROM db_name.table_1 INFO | jvm 1 | 2022/04/18 19:20:28 | LIMIT 10 INFO | jvm 1 | 2022/04/18 19:20:28 | org.apache.calcite.runtime.CalciteContextException: At line 0, column 0: Object 'table_1' not found within 'db_name';
table表已在物理库中删除,table_1在屋里库中存在,且已查出10条数据,但是日志中报table_1不存在,逻辑库中有table逻辑表
是我哪里配置有问题吗?
table_1要配置成逻辑表(单表)才可以被mycat访问