Use `broadcastTables` please.
Configuration like this:
shardingRule:
tables:
....other sharding table configuration
broadcastTables:
- your table
Detail see
https://shardingsphere.apache.org/document/current/en/manual/sharding-jdbc/configuration/config-yaml/
--
Yi Yang(Sion)
Apache ShardingSphere
At 2019-07-02 03:04:15, "Eric" <[email protected]> wrote:
>Hi,
>
>Seems select statement without sharding key in the where clause will return
>all records from the tables from all sharded databases. Please have your
>help.
>
>For example, if two sharded database has the same table and records,
>selecting from that table without sharding key in the where clause, all
>records from the two databases are returned which are duplicated.
>
>Is there some settings I need to put into the configuration?
>
>If it's a boardcast route because not hitting sharding key, the table is
>not sharded or any reason, is there some way I can return unique records
>without using "unique" in the original source query?
>
>Regards,
>Eric Poon
