insert into decent_cloud.t_cpbszb_log
select get_json_object(data, '$.id') id,
get_json_object(data, '$.DjBth') DjBth,
get_json_object(data, '$.create_time') create_time,
get_json_object(data, '$.status') status,
get_json_object(data, '$.DjLsh') DjLsh,
get_json_object(data, '$.package_i_identity') package_i_identity,
get_json_object(data, '$.package_i_code') package_i_code,
get_json_object(data, '$.fast_package_identity') fast_package_identity,
get_json_object(data, '$.xh') xh
from (select regexp_replace(regexp_replace((get_json_object(line, '$.data')), '\\[', ''), '\\]', '') as data,
get_json_object(line, '$.table') as tables,
get_json_object(line, '$.type') as type,
get_json_object(line, '$.es') as es
from decent_cloud_temp_table
where get_json_object(line, '$.table') = 't_cpbszb_log') t
where t.type = 'INSERT';
insert into decent_cloud.t_cpbszb_log
select get_json_object(data, '$.id') id,
get_json_object(data, '$.DjBth') DjBth,
get_json_object(data, '$.create_time') create_time,
get_json_object(data, '$.status') status,
get_json_object(data, '$.DjLsh') DjLsh,
get_json_object(data, '$.package_i_identity') package_i_identity,
get_json_object(data, '$.package_i_code') package_i_code,
get_json_object(data, '$.fast_package_identity') fast_package_identity,
get_json_object(data, '$.xh') xh
from (select translate(translate((get_json_object(line, '$.data')), '\\[', ''), '\\]', '') as data,
get_json_object(line, '$.table') as tables,
get_json_object(line, '$.type') as type,
get_json_object(line, '$.es') as es
from decent_cloud_temp_table
where get_json_object(line, '$.table') = 't_cpbszb_log') t
where t.type = 'INSERT';
将
regexp_replace函数替换成translate,问题解决。