在mysql中可以设置sql_mode 取消ONLY_FULL_GROUP_BY执行该条语句select name, age from user group by age;
在starrocks中可以吗？尝试了一下好像不行
建表语句
create table user
(
id BIGINT(20) NOT NULL COMMENT ‘主键id’,
name varchar(255) null,
age int null
)
ENGINE=olap
PRIMARY KEY(id)
DISTRIBUTED BY HASH(id) BUCKETS 10
PROPERTIES(“replication_num” = “1”);
