五百年前

SELECT brand, sum(`_c4`) as total_count FROM tmp.search_filter_order LATERAL VIEW explode(split(filter_brands, ',')) num as brand WHERE filter_brands != '' GROUP BY brand