starrocks_列转行_sr

select
     t1.tenantcode
    ,t1.custom_field_htid
    ,t1.custom_field_zcid
    ,unnest as zcid_item
from (
    select 
         a.tenantcode
        ,a.custom_field_htid 
        ,a.custom_field_zcid
    from table_zlhtxxcj a
    where a.custom_field_htid='541eb0e5e3e04fdf8cb39841d23a7e2b'
) t1
cross join unnest(split(t1.custom_field_zcid, ',')) AS unnest
;