1数据类型转换
cast(a as varchar)
2json串解析
,json_extract(params, '$.p') as p
3.拆分字符串split
,split(cast(json_extract(data, '$.tag') as varchar), ',') as tag
拆分字符串是list类型,index从1开始
4.截取字符串
substr(create_time, 1, 10) as apply_dt
1数据类型转换
cast(a as varchar)
2json串解析
,json_extract(params, '$.p') as p
3.拆分字符串split
,split(cast(json_extract(data, '$.tag') as varchar), ',') as tag
拆分字符串是list类型,index从1开始
4.截取字符串
substr(create_time, 1, 10) as apply_dt