Improve your programming skills

HIVE Collect_Set and Colect_list

select
slot,
collect_set(size)
from
(select
slot,
size,
count(d_date_id) as cnt
from xxx.table1 where dt >= 20200601
group by
slot,
size
) x
group by
slot
;

Leave a comment

Your email address will not be published. Required fields are marked *

One thought on “HIVE Collect_Set and Colect_list”