【详述】查询 导致 becrash
SELECT get_json_string(url_decode(t1.moreinfo), '$.store_id') AS store_id , url_decode(regexp_replace(url_decode(get_json_string(url_decode(t1.moreinfo), '$.session_id')), '
|^M', '')) AS session_id , url_decode(regexp_replace(url_decode(get_json_string(url_decode(t1.moreinfo), '$.iframe_id')), '
|^M', '')) AS uuid , url_decode(regexp_replace(url_decode(get_json_string(url_decode(t1.moreinfo), '$.event_name')), '
|^M', '')) AS event_name , eventid, url, ref, reserve1, event_day , hour FROM act_change_debug.sl_websdkprotocol_original t1 WHERE t1.event_day >= '2022-12-05' AND t1.event_day <= '2022-12-06' AND t1.prodid = 'shopline' AND get_json_string(url_decode(t1.moreinfo), '$.store_id') = '1658471375684' AND url_decode(regexp_replace(url_decode(get_json_string(url_decode(t1.moreinfo), '$.iframe_id')), '
|^M', '')) = '4fc6b9ef6d044f447ede77ccfb6f6fec' AND url_decode(regexp_replace(url_decode(get_json_string(url_decode(t1.moreinfo), '$.event_name')), '
|^M', '')) IN ('101') ORDER BY reserve1 DESC LIMIT 1000
其中udf函数的代码很简单
