Hive group by操作后将其他字段串接

表tmp_test aio

bandriod aandriod

目标数据

aio | andriod bandriod

sql:,选择uid, concat_ws (“|”, collect_set(设备)从tmp_test group by uid;

Hive group by操作后将其他字段串接