hive正则 模糊匹配

SELECT
count(1), count(DISTINCT xx)
from xxx.xxx
where dt = '2020-10-11'
and length(regexp_extract(goods_tag_name, '易方达蓝筹|张坤|蔡徐坤', 0)) > 0
;