SHARDJOIN_FALLBACK session environment option
Use SHARDJOIN_FALLBACK session environment option to create a local temporary table to pull the data from the shard participants.
The SET ENVIRONMENT SHARDJOIN_FALLBACK statement of SQL supports the following syntax:
Usage
When you enable the SHARDJOIN_FALLBACK, IDS execute the sharded table joins by creating temporary tables locally and pull the data from the respective participants. This solution is sub-optimal but the query can be executed to its completion with out raising an error. The intention of this support is only to have a migration comfort and not an optimal scaling solution. The application might have to change their sharding scheme to match with the join criteria to achieve an optimal performance. Any other cases that can not be done even by the fallback mechanism are rejected.