Description
SQL like below:
select tmp.*
from
(select
device_id, ads_id,
from_json(regexp_replace(device_personas, '(?<=(\\\\\\{|,))"device_', '"user_device_'), ${device_schema}) as tmp
from input )
${device_schema} includes more than 100 fields.
if Rule: OptimizeCsvJsonExprs been applied, the expression, regexp_replace, will be invoked many times, that costs so much time.