尝试在Hive 0.13.0之后使用COLLECT_LIST(col)
SELECt hash_id, COLLECT_LIST(num_of_cats) AS aggr_setFROM tablenameWHERe blablablaGROUP BY hash_id;

尝试在Hive 0.13.0之后使用COLLECT_LIST(col)
SELECt hash_id, COLLECT_LIST(num_of_cats) AS aggr_setFROM tablenameWHERe blablablaGROUP BY hash_id;