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

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.202.16:10000
Open connection: jdbc:hive2://192.168.202.16:10000 (176 ms)
Starting query
Query executed successfully (83 ms)
Starting query
Query executed successfully (40 ms)
0000000000000
1111111111
2018-06-11 22:45:26,838 INFO  [main] jdbc.Utils (Utils.java:parseURL(310)) - Supplied authorities: 192.168.202.16:10000
2018-06-11 22:45:26,838 INFO  [main] jdbc.Utils (Utils.java:parseURL(397)) - Resolved authority: 192.168.202.16:10000
2018-06-11 22:45:26,839 INFO  [main] jdbc.HiveConnection (HiveConnection.java:openTransport(203)) - Will try to open client transport with JDBC Uri: jdbc:hive2://192.168.202.16:10000
Open connection: jdbc:hive2://192.168.202.16:10000 (21 ms)
Starting SQL statement
Unhandled exception in HPL/SQL
java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
        at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:296)
        at org.apache.hive.hplsql.Conn.executeSql(Conn.java:110)
        at org.apache.hive.hplsql.Exec.executeSql(Exec.java:596)
        at org.apache.hive.hplsql.Stmt.insertValues(Stmt.java:801)
        at org.apache.hive.hplsql.Stmt.insert(Stmt.java:714)
        at org.apache.hive.hplsql.Exec.visitInsert_stmt(Exec.java:1120)
        at org.apache.hive.hplsql.Exec.visitInsert_stmt(Exec.java:52)
        at org.apache.hive.hplsql.HplsqlParser$Insert_stmtContext.accept(HplsqlParser.java:10348)
        at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:70)
        at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:1013)
        at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:52)
        at org.apache.hive.hplsql.HplsqlParser$StmtContext.accept(HplsqlParser.java:1023)
        at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:70)
        at org.apache.hive.hplsql.HplsqlBaseVisitor.visitBlock(HplsqlBaseVisitor.java:28)
        at org.apache.hive.hplsql.HplsqlParser$BlockContext.accept(HplsqlParser.java:454)
        at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:70)
        at org.apache.hive.hplsql.Exec.visitBegin_end_block(Exec.java:930)
        at org.apache.hive.hplsql.Exec.visitBegin_end_block(Exec.java:52)
        at org.apache.hive.hplsql.HplsqlParser$Begin_end_blockContext.accept(HplsqlParser.java:549)
        at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:70)
        at org.apache.hive.hplsql.HplsqlBaseVisitor.visitBlock(HplsqlBaseVisitor.java:28)
        at org.apache.hive.hplsql.HplsqlParser$BlockContext.accept(HplsqlParser.java:454)
        at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:70)
        at org.apache.hive.hplsql.Exec.visitProgram(Exec.java:920)
        at org.apache.hive.hplsql.Exec.visitProgram(Exec.java:52)
        at org.apache.hive.hplsql.HplsqlParser$ProgramContext.accept(HplsqlParser.java:395)
        at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:42)
        at org.apache.hive.hplsql.Exec.run(Exec.java:775)
        at org.apache.hive.hplsql.Exec.run(Exec.java:751)
        at org.apache.hive.hplsql.Hplsql.main(Hplsql.java:23)
[root@node01 hplsql]#

---

最近学习hiveQL，遇到这样的错误，没有一个好的解决方案，求大神相助！