sharing-jdbc分片库与默认库可以jion吗

Question

sql = select count(*) from t_device_info d join t_energy_hourdata e on d.id=e.deviceId where e.prj in (1,2) and e.sharingFlag='2018-03' limit 100

### Cause: com.dangdang.ddframe.rdb.sharding.exception.ShardingJdbcException: com.dangdang.ddframe.rdb.sharding.exception.ShardingJdbcException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'energydata.t_device_info' doesn't exist] with root cause
 

其中t_device_info表在默认库，t_energy_hourdata在分片库。然后报错了

如果带上sql = select count(*) from energymgr.t_device_info d join energydata.t_energy_hourdata e on d.id=e.deviceId where e.prj in (1,2) and e.sharingFlag='2018-03' limit 100

报不支持energydata.table错

 

 

 

Answer 1

请问解决了吗？我也遇到同样的问题

Answer 2

回复
无解，不能跨库拼表

Answer 3

energymgr是默认库，energydata是分片库