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
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