mysql collect_set_hive：数据库“行专列”操作---使用collect_set/collect_list/collect_all & row_number()over(partit...
selectgridid,height,collect_set(cell),collect_set(mrcount),collect_set(weakmrcount)from (select * from tommyduan_test order by gridid,height,mrcount desc) t10group bygridid,height;+---------+---------...
