w985341237 opened a new issue, #36973:
URL: https://github.com/apache/shardingsphere/issues/36973
## Shgarding Table does not exist
my sharding logic table keeps saying it doesn't exist，There are no problems
with other tables。I also looked at other issues,Many of them cannot be found in
a single table,So I added "*.*", but it doesn't work for me
this is my config：
```
mode:
type: Standalone
repository:
type: JDBC
dataSources:
ddi:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.cj.jdbc.Driver
jdbcUrl:
jdbc:mysql://rm-8.mysql.zhangbei.rds.aliyuncs.com:3306/ddi_data_server_v2?useUnicode=true&characterEncoding=UTF-8&ssl=false&allowMultiQueries=true&autoReconnect=true&failOverReadOnly=false
username: s_d_dba
password:
rules:
- !SHARDING
tables:
t_dimension_data:
actualDataNodes: ddi.t_dimension_data_$->{2023..2040}
tableStrategy:
standard:
shardingColumn: collect_at
shardingAlgorithmName: record-by-collect-year
shardingAlgorithms:
record-by-collect-year:
type: CLASS_BASED
props:
strategy: STANDARD
algorithmClassName:
com.weiming.ddi.infrastructure.sharding.YearTableShardingAlgorithm
# 可加自定义配置，比如自动扩表策略
auto-create: true
- !SINGLE
tables:
- "*.*"
props:
sql-show: true
```
console log:
```
Caused by:
org.apache.shardingsphere.infra.exception.kernel.metadata.TableNotFoundException:
Table or view 't_dimension_data' does not exist.
at
org.apache.shardingsphere.infra.binder.engine.segment.dml.from.type.SimpleTableSegmentBinder.lambda$checkTableExists$12(SimpleTableSegmentBinder.java:178)
~[shardingsphere-infra-binder-5.5.2.jar:5.5.2]
at
org.apache.shardingsphere.infra.exception.core.ShardingSpherePreconditions.checkState(ShardingSpherePreconditions.java:44)
~[shardingsphere-infra-exception-core-5.5.2.jar:5.5.2]
at
org.apache.shardingsphere.infra.binder.engine.segment.dml.from.type.SimpleTableSegmentBinder.checkTableExists(SimpleTableSegmentBinder.java:178)
~[shardingsphere-infra-binder-5.5.2.jar:5.5.2]
at
org.apache.shardingsphere.infra.binder.engine.segment.dml.from.type.SimpleTableSegmentBinder.bind(SimpleTableSegmentBinder.java:90)
~[shardingsphere-infra-binder-5.5.2.jar:5.5.2]
at
org.apache.shardingsphere.infra.binder.engine.segment.dml.from.TableSegmentBinder.bind(TableSegmentBinder.java:57)
~[shardingsphere-infra-binder-5.5.2.jar:5.5.2]
at
org.apache.shardingsphere.infra.binder.engine.statement.dml.SelectStatementBinder.lambda$bind$1(SelectStatementBinder.java:64)
~[shardingsphere-infra-binder-5.5.2.jar:5.5.2]
```
shardingsphere-jdbc version:5.5.2
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
