hive执行报错解决

Error during job, obtaining debugging information...
Examining task ID: task_1524216872104_86828_m_000001 (and more) from job job_1524216872104_86828
Examining task ID: task_1524216872104_86828_m_000001 (and more) from job job_1524216872104_86828

Task with the most failures(4):
-----
Task ID:
  task_1524216872104_86828_m_000001

URL:
  http://0.0.0.0:8088/taskdetails.jsp?jobid=job_1524216872104_86828&tipid=task_1524216872104_86828_m_000001
-----
Diagnostic Messages for this Task:
Error: java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing row {"month_id":"201805","user_id":"7117041328091672","cycle_id":"1672","maxfee":0,"owe_fee":16.66,"rn1":1}
    at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.map(ExecMapper.java:179)
    at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54)
    at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:453)
    at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
    at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164)
    at java.security.AccessController.doPrivileged(Native Method)
    at javax.security.auth.Subject.doAs(Subject.java:415)
    at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1693)
    at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing row {"month_id":"201805","user_id":"7117041328091672","cycle_id":"1672","maxfee":0,"owe_fee":16.66,"rn1":1}
    at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:507)
    at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.map(ExecMapper.java:170)
    ... 8 more
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Unable to execute method public org.apache.hadoop.io.Text cn.com.dwsoft.hive.udf.MonthAdd.evaluate(org.apache.hadoop.io.Text,org.apache.hadoop.io.IntWritable)  on object cn.com.dwsoft.hive.udf.MonthAdd@6fd92134 of class cn.com.dwsoft.hive.udf.MonthAdd with arguments {1672:org.apache.hadoop.io.Text, 1:org.apache.hadoop.io.IntWritable} of size 2
    at org.apache.hadoop.hive.ql.exec.FunctionRegistry.invoke(FunctionRegistry.java:970)
    at org.apache.hadoop.hive.ql.udf.generic.GenericUDFBridge.evaluate(GenericUDFBridge.java:182)
    at org.apache.hadoop.hive.ql.exec.ExprNodeGenericFuncEvaluator._evaluate(ExprNodeGenericFuncEvaluator.java:186)
    at org.apache.hadoop.hive.ql.exec.ExprNodeEvaluator.evaluate(ExprNodeEvaluator.java:77)
    at org.apache.hadoop.hive.ql.exec.ExprNodeEvaluator.evaluate(ExprNodeEvaluator.java:65)
    at org.apache.hadoop.hive.ql.exec.SelectOperator.processOp(SelectOperator.java:77)
    at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:815)
    at org.apache.hadoop.hive.ql.exec.TableScanOperator.processOp(TableScanOperator.java:95)
    at org.apache.hadoop.hive.ql.exec.MapOperator$MapOpCtx.forward(MapOperator.java:157)
    at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:497)
    ... 9 more
Caused by: java.lang.reflect.InvocationTargetException
    at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.apache.hadoop.hive.ql.exec.FunctionRegistry.invoke(FunctionRegistry.java:946)
    ... 18 more
Caused by: java.lang.NumberFormatException: For input string: ""
    at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
    at java.lang.Integer.parseInt(Integer.java:504)
    at java.lang.Integer.parseInt(Integer.java:527)
    at cn.com.dwsoft.hive.udf.MonthAdd.evaluate(MonthAdd.java:20)
    ... 22 more

执行hql遇见以上报错，查询了好多方法都不好用，后来经过测试，sql在另一张表上执行无报错，所以初步确定该表中数据有问题，经过多次测试，发现剔除掉cycle_id为1672的数据（该数据为异常数据），sql可以正常执行。