[stable31] fix: allow hinting the shard keys for joined tables

[stable31] fix: allow hinting the shard keys for joined tables #46094