hive跑脚本的时候，出现异常，regexp_replace替换函数导致，错误如图所示，解决方案如下

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，问题解决。

最后

以上就是义气奇迹为你收集整理的hive跑脚本的时候，出现异常，regexp_replace替换函数导致，错误如图所示，解决方案如下的全部内容，希望文章能够帮你解决hive跑脚本的时候，出现异常，regexp_replace替换函数导致，错误如图所示，解决方案如下所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。