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
;
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
;
One thought on “HIVE Collect_Set and Colect_list”
Some genuinely excellent content on this web site , thanks for contribution. Deloris Spence Docilu