解决ShardingJdbc多表join查询不支持or查询的问题(java.lang.UnsupportedOperationException)

1.问题描述
使用ShardingJdbc时，用联表查询不能使用or关键字，例如：

SELECT *
FROM t_tabale_a AS a
JOIN t_table_b AS b ON a.id=b.id
WHERE a.`name` LIKE '%aa%' OR b.`name` LIKE '%aa%'

报错情况：

java.lang.UnsupportedOperationException: Cannot support SQL for `schema.table`
	at io.shardingjdbc.core.parsing.parser.clause.TableReferencesClauseParser.parseTableFactor(TableReferencesClauseParser.java:67)
	at io.shardingjdbc.core.parsing.parser.dialect.mysql.clause.MySQLTableReferencesClauseParser.parseTableReference(MySQLTableReferencesClauseParser.java:24)
	at io.shardingjdbc.core.parsing.parser.clause.TableReferencesClauseParser.parse(TableReferencesClauseParser.java:54)
	at io.shardingjdbc.core.parsing.parser.sql.dql.select.AbstractSelectParser.parseTable(AbstractSelectParser.java:109)
	at io.shardingjdbc.core.parsing.parser.sql.dql.select.AbstractSelectParser.parseFrom(AbstractSelectParser.java:98)
	at io.shardingjdbc.core.parsing.parser.dialect.mysql.sql.MySQLSelectParser.parseInternal(MySQLSelectParser.java:50)
	at io.shardingjdbc.core.parsing.parser.sql.dql.select.AbstractSelectParser.parseInternal(AbstractSelectParser.java:81)
	at io.shardingjdbc.core.parsing.parser.sql.dql.select.AbstractSelectParser.parse(AbstractSelectParser.java:68)
	at io.shardingjdbc.core.parsing.parser.sql.dql.select.AbstractSelectParser.parse(AbstractSelectParser.java:46)
	at io.shardingjdbc.core.parsing.SQLParsingEngine.parse(SQLParsingEngine.java:50)
	at io.shardingjdbc.core.routing.router.ParsingSQLRouter.parse(ParsingSQLRouter.java:74)
	at io.shardingjdbc.core.routing.PreparedStatementRoutingEngine.route(PreparedStatementRoutingEngine.java:55)
	at io.shardingjdbc.core.jdbc.core.statement.ShardingPreparedStatement.route(ShardingPreparedStatement.java:150)

2.问题原因
因为使用ShardingJdbc时，不支持联表的or、union等操作

3.问题解决
方法一：
将联表的操作sql做成视图，视为一个单表

方法二：
利用CONCAT字段将关联字段连接在一起，例如

SELECT *
FROM t_tabale_a AS a
JOIN t_table_b AS b ON a.id=b.id
WHERE CONCAT(a.`name`,b.`name) LIKE '%aa%'

4.文章参考链接
a. https://shardingsphere.apache.org/document/current/cn/user-manual/shardingsphere-jdbc/usage/sharding/hint/