[Mycat2]Expression ‘t.user_id‘ is not being grouped

877 阅读1分钟

SELECT t.user_id FROM db1.travelrecord t GROUP BY id;

Expression 't.user_id' is not being grouped

修改成

SELECT any_value(t.user_id) FROM db1.travelrecord t GROUP BY id;

projectItem被group by的引用的无聚合函数的字段需要使用any_value