select
size(split(brand_id_rate_str,",")),
count(1)
from
alg.qz_click_keyword_brandrate_model
group by
size(split(brand_id_rate_str,","))
limit 50;
目的:
查看brand_id_rate_str 按,切分后数组的大小整体分布情况
数据demo:
结果示例:
select
size(split(brand_id_rate_str,",")),
count(1)
from
alg.qz_click_keyword_brandrate_model
group by
size(split(brand_id_rate_str,","))
limit 50;
目的:
查看brand_id_rate_str 按,切分后数组的大小整体分布情况
数据demo:
结果示例: