首先确保已经设置了分布式查询模式:query.setDistributedJoins(true);
如果仍然出现错误,可以尝试手动指定别名,例如:
SELECT a.id, b.name FROM table1 a JOIN table2 b ON a.id = b.id WHERE a.name = 'test'
改为:
SELECT a.id as id_a, b.name as name_b FROM table1 a JOIN table2 b ON a.id = b.id WHERE a.name = 'test'