我们有些时候没法使用 集合类型,却要提供所有元素。
我可以使用concat_ws("||",collect_set(字段))
实现
with price_group_01 as(
select
partner_id,
collect_set(pgd) as pgd_set
from
(select distinct
partner_id,
concat(division,'-',price_group_description) as pgd
from
ccsd.tb_cpp_etl_bp_sales_basic_info
)
group by partner_id
)
select distinct
partner_id as id,
concat_ws('&&',pgd_set) as price_group
from
price_group_01;