Impala中的REGEXP_EXTRACT

您可以使用以下正则表达式：

"customer_id":"([wd]+)"

演示：https :
//regex101.com/r/MEOGw8/1

测试：

{"param":"success","value":"10","level":"0","error_pre":"101","customer_id":"5b0e9b23e423b0d33c9f7ddfd", "purchases": "13", "last_activity_ts": "123523465"}

比赛：

Match 1Full match  63-104  `"customer_id":"5b0e9b23e423b0d33c9f7ddfd"`Group 1.    78-103  `5b0e9b23e423b0d33c9f7ddfd`

SQL语句：

select regexp_extract(field, '"customer_id":"([wd]+)"',1, 1) from table_namewhere field rlike '"error_pre":"101"'