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
;
You may also like
How to return closest Monday date before, when date is given? It is very simple, user next_day and date_add funtions select next_day(date_add(‘YOUR_DATE’,-7),’MONDAY’) […]
alter table table_name change column column_name column_name column_name_type after column_name2; https://community.cloudera.com/t5/Support-Questions/How-can-we-change-the-column-order-in-Hive-table-without/td-p/89495
How to get first day of quarter in hive? select add_months(trunc(‘2020-10-01′,’MM’),-(month(‘2020-10-01’)-1)%3)
One thought on “HIVE Collect_Set and Colect_list”
Some genuinely excellent content on this web site , thanks for contribution. Deloris Spence Docilu