本文共 218 字,大约阅读时间需要 1 分钟。
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:
结果示例:
转载地址:http://gzldi.baihongyu.com/