转载
hive之regexp_replace函数、split函数的正则_leeshutao的博客-CSDN博客_hive split 正则
hive之regexp_replace函数、split函数的正则
Hive中,regexp_replace函数的第2个参数是正则表达式,第3个参数是字符串
split函数解析也是正则
因此上面如果写成这样:
select split(regexp_replace(data,'\\},\\{','}||{'),'||')[0]as test #这里做了修改
from
(select '[{"source":"7fresh","monthSales":4900,"userCount":1900,"score":"9.9"},{"source":"jd","monthSales":2090,"userCount":78981,"score":"9.8"},{"source":"jdmart","monthSales":6987,"userCount":1600,"score":"9.0"}]'
as data) a
就得不到想要的结果了
参考自:转义字符\(在hive+shell以及java中注意事项):正则表达式的转义字符为双斜线,split函数解析也是正则_longshenlmj的博客-CSDN博客_hive split 转义
常用的
select size(split(
regexp_replace(
regexp_replace(get_json_object(data_map, '$.data_map'), '\\}\\,\\{','\\}\\;\\{')
,'\\]|\\[','')
,'\\;')) as split1_size
from xxx.xxx_table
where pt ='2021-02-01'
limit 1000
切分之后看数组长度