Vertical Sharding Example.

[venkatesh82]

Hi,

I have a Employee Table in Database1 and Department Table in Database 2.

How can we write join query to list all the employees of a specific department using vertical sharding with jdbc

[sandynz]

Hi @venkatesh82 , I don't know how you use ShardingSpere-JDBC, could you supply the ShardingSphere configuration (include dataSources and rules)?

Currently, since it's vertical sharding, I guess Database1 and Database2 are used in different systems but not in one system.
If you know the exact departmentId, and there's departmentId in Employee table, example SQL: SELECT * FROM Employee WHERE departmentId=?. If departmentId is unknown, maybe query it firstly by departmentName etc via micro-service for example.