Sharding JDBC supports composite sharding strategies？

[lfengsh]

In our current setup, we have 20 sharded tables based on the mod(userId, 20) sharding strategy, where user_id is also a table column. However, we also need to perform sharding based on a business parameter, let's call it scene, which is not a table column.

For example:

When scene = 'Normal', we want to shard based on user_mod(userId, 20).
When scene = 'Special', we want to route directly to a specific table : user_special.
How can we achieve this in our setup? We are currently using version 5.1.1.

[RaigorJiang]

Maybe you can refer to SQL Hint
Note that older versions may not support this feature, and it is recommended to use the latest version.