想按照 sum_count 列值的和将 sID 均匀分成5组,结果是每组的 sum_count 列值的和均匀分布,组内的sID变成逗号分隔的字串,请问这个有啥办法实现吗?
rNum.txt
t = loadText("/home/ffliu/data/rNum.txt")
select sum(sum_count) as sum, toArray(sID) from t group by volumeBar(t.sum_count, 0.2)