在HPL/SQL中执行插入操作报错

最新推荐文章于 2023-12-19 16:17:50 发布

yesha_baci

最新推荐文章于 2023-12-19 16:17:50 发布

阅读量1.1k

点赞数

分类专栏： HQL 文章标签： hive HPL/SQL

本文链接：https://blog.csdn.net/yesha_baci/article/details/80651851

版权

Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask

下面是执行存储过程：

begin


        --truncate table iptv_vmos;

        open   RC3 for  select avgmdilr,userid from iptv_data_day limit 2;
          loop

            print '0000000000000';
            FETCH RC3 INTO v_avgmdilr,v_userid;
            print '1111111111';
            EXIT WHEN RC3 % NOTFOUND;     
            insert into iptv_vmos(userid,remark,insert_date,loid,community,community_id,mainten_code)  values('1','2','2018-06-08','4','5','6','7');
            print '22222222222';
            commit;
          endloop;
          close RC3;
          end;

报错如下：

[root@node01 hplsql]# ./hplsql -f   szw.sql
2018-06-11 22:45:26,453 INFO  [main] jdbc.Utils (Utils.java:parseURL(310)) - Supplied authorities: 192.168.202.16:10000
2018-06-11 22:45:26,459 INFO  [main] jdbc.Utils (Utils.java:parseURL(397)) - Resolved authority: 192.168.202.16:10000
2018-06-11 22:45:26,555 INFO  [main] jdbc.HiveConnection (HiveConnection.java:openTransport(203)) - Will try to open client transport with JDBC Uri: jdbc:hive2://192.168