[
https://issues.apache.org/jira/browse/HIVE-24431?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Fabien Carrion updated HIVE-24431:
----------------------------------
Description:
I was receiving some null pointer while writing in db:
{quote}{{ERROR : FAILED: Execution Error, return code 2 from
org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Reducer
3, vertexId=vertex_1604850281565_5081_1_02, diagnostics=[Task failed,
taskId=task_1604850281565_5081_1_02_000001, diagnostics=[TaskAttempt 0 failed,
info=[Error: Error while running task ( failure ) :
attempt_1604850281565_5081_1_02_000001_0:java.lang.RuntimeException:
java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException:
Hive Runtime Error while processing row}}
{{ at
org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:296)}}
{{ at
org.apache.hadoop.hive.ql.exec.tez.TezProcessor.run(TezProcessor.java:250)}}
{{ at
org.apache.tez.runtime.LogicalIOProcessorRuntimeTask.run(LogicalIOProcessorRuntimeTask.java:374)}}
{{ at
org.apache.tez.runtime.task.TaskRunner2Callable$1.run(TaskRunner2Callable.java:73)}}
{{ at
org.apache.tez.runtime.task.TaskRunner2Callable$1.run(TaskRunner2Callable.java:61)}}
{{ at java.security.AccessController.doPrivileged(Native Method)}}
{{ at javax.security.auth.Subject.doAs(Subject.java:422)}}
{{ at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1730)}}
{{ at
org.apache.tez.runtime.task.TaskRunner2Callable.callInternal(TaskRunner2Callable.java:61)}}
{{ at
org.apache.tez.runtime.task.TaskRunner2Callable.callInternal(TaskRunner2Callable.java:37)}}
{{ at org.apache.tez.common.CallableWithNdc.call(CallableWithNdc.java:36)}}
{{ at
com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:125)}}
{{ at
com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:69)}}
{{ at
com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:78)}}
{{ at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)}}
{{ at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)}}
{{ at java.lang.Thread.run(Thread.java:745)}}
{{Caused by: java.lang.RuntimeException:
org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while
processing row}}
{{ at
org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.pushRecord(ReduceRecordSource.java:304)}}
{{ at
org.apache.hadoop.hive.ql.exec.tez.ReduceRecordProcessor.run(ReduceRecordProcessor.java:318)}}
{{ at
org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:267)}}
{{ ... 16 more}}
{{Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime
Error while processing row}}
{{ at
org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource$GroupIterator.next(ReduceRecordSource.java:378)}}
{{ at
org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.pushRecord(ReduceRecordSource.java:294)}}
{{ ... 18 more}}
{{Caused by: java.lang.NullPointerException}}
{{ at org.apache.hive.storage.jdbc.JdbcSerDe.serialize(JdbcSerDe.java:166)}}
{{ at org.apache.hive.storage.jdbc.JdbcSerDe.serialize(JdbcSerDe.java:59)}}
{{ at
org.apache.hadoop.hive.ql.exec.FileSinkOperator.process(FileSinkOperator.java:961)}}
{{ at org.apache.hadoop.hive.ql.exec.Operator.baseForward(Operator.java:994)}}
{{ at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:940)}}
{{ at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:927)}}
{{ at
org.apache.hadoop.hive.ql.exec.SelectOperator.process(SelectOperator.java:95)}}
{{ at org.apache.hadoop.hive.ql.exec.Operator.baseForward(Operator.java:994)}}
{{ at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:940)}}
{{ at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:927)}}
{{ at
org.apache.hadoop.hive.ql.exec.PTFOperator$PTFInvocation.handleOutputRows(PTFOperator.java:337)}}
{{ at
org.apache.hadoop.hive.ql.exec.PTFOperator$PTFInvocation.processRow(PTFOperator.java:325)}}
{{ at org.apache.hadoop.hive.ql.exec.PTFOperator.process(PTFOperator.java:139)}}
{{ at org.apache.hadoop.hive.ql.exec.Operator.baseForward(Operator.java:994)}}
{{ at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:940)}}
{{ at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:927)}}
{{ at
org.apache.hadoop.hive.ql.exec.SelectOperator.process(SelectOperator.java:95)}}
{{ at
org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource$GroupIterator.next(ReduceRecordSource.java:363)}}
{{ ... 19 more}}
{quote}
I just add a check in the patch.
was:
I was receiving some null pointer while writing in db.
I just add a check.
> Null Pointer exception while sending data to jdbc
> -------------------------------------------------
>
> Key: HIVE-24431
> URL: https://issues.apache.org/jira/browse/HIVE-24431
> Project: Hive
> Issue Type: Bug
> Components: JDBC storage handler
> Affects Versions: All Versions
> Reporter: Fabien Carrion
> Priority: Trivial
> Attachments: check_null.patch
>
>
> I was receiving some null pointer while writing in db:
> {quote}{{ERROR : FAILED: Execution Error, return code 2 from
> org.apache.hadoop.hive.ql.exec.tez.TezTask. Vertex failed, vertexName=Reducer
> 3, vertexId=vertex_1604850281565_5081_1_02, diagnostics=[Task failed,
> taskId=task_1604850281565_5081_1_02_000001, diagnostics=[TaskAttempt 0
> failed, info=[Error: Error while running task ( failure ) :
> attempt_1604850281565_5081_1_02_000001_0:java.lang.RuntimeException:
> java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException:
> Hive Runtime Error while processing row}}
> {{ at
> org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:296)}}
> {{ at
> org.apache.hadoop.hive.ql.exec.tez.TezProcessor.run(TezProcessor.java:250)}}
> {{ at
> org.apache.tez.runtime.LogicalIOProcessorRuntimeTask.run(LogicalIOProcessorRuntimeTask.java:374)}}
> {{ at
> org.apache.tez.runtime.task.TaskRunner2Callable$1.run(TaskRunner2Callable.java:73)}}
> {{ at
> org.apache.tez.runtime.task.TaskRunner2Callable$1.run(TaskRunner2Callable.java:61)}}
> {{ at java.security.AccessController.doPrivileged(Native Method)}}
> {{ at javax.security.auth.Subject.doAs(Subject.java:422)}}
> {{ at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1730)}}
> {{ at
> org.apache.tez.runtime.task.TaskRunner2Callable.callInternal(TaskRunner2Callable.java:61)}}
> {{ at
> org.apache.tez.runtime.task.TaskRunner2Callable.callInternal(TaskRunner2Callable.java:37)}}
> {{ at org.apache.tez.common.CallableWithNdc.call(CallableWithNdc.java:36)}}
> {{ at
> com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:125)}}
> {{ at
> com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:69)}}
> {{ at
> com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:78)}}
> {{ at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)}}
> {{ at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)}}
> {{ at java.lang.Thread.run(Thread.java:745)}}
> {{Caused by: java.lang.RuntimeException:
> org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while
> processing row}}
> {{ at
> org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.pushRecord(ReduceRecordSource.java:304)}}
> {{ at
> org.apache.hadoop.hive.ql.exec.tez.ReduceRecordProcessor.run(ReduceRecordProcessor.java:318)}}
> {{ at
> org.apache.hadoop.hive.ql.exec.tez.TezProcessor.initializeAndRunProcessor(TezProcessor.java:267)}}
> {{ ... 16 more}}
> {{Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime
> Error while processing row}}
> {{ at
> org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource$GroupIterator.next(ReduceRecordSource.java:378)}}
> {{ at
> org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource.pushRecord(ReduceRecordSource.java:294)}}
> {{ ... 18 more}}
> {{Caused by: java.lang.NullPointerException}}
> {{ at org.apache.hive.storage.jdbc.JdbcSerDe.serialize(JdbcSerDe.java:166)}}
> {{ at org.apache.hive.storage.jdbc.JdbcSerDe.serialize(JdbcSerDe.java:59)}}
> {{ at
> org.apache.hadoop.hive.ql.exec.FileSinkOperator.process(FileSinkOperator.java:961)}}
> {{ at org.apache.hadoop.hive.ql.exec.Operator.baseForward(Operator.java:994)}}
> {{ at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:940)}}
> {{ at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:927)}}
> {{ at
> org.apache.hadoop.hive.ql.exec.SelectOperator.process(SelectOperator.java:95)}}
> {{ at org.apache.hadoop.hive.ql.exec.Operator.baseForward(Operator.java:994)}}
> {{ at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:940)}}
> {{ at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:927)}}
> {{ at
> org.apache.hadoop.hive.ql.exec.PTFOperator$PTFInvocation.handleOutputRows(PTFOperator.java:337)}}
> {{ at
> org.apache.hadoop.hive.ql.exec.PTFOperator$PTFInvocation.processRow(PTFOperator.java:325)}}
> {{ at
> org.apache.hadoop.hive.ql.exec.PTFOperator.process(PTFOperator.java:139)}}
> {{ at org.apache.hadoop.hive.ql.exec.Operator.baseForward(Operator.java:994)}}
> {{ at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:940)}}
> {{ at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:927)}}
> {{ at
> org.apache.hadoop.hive.ql.exec.SelectOperator.process(SelectOperator.java:95)}}
> {{ at
> org.apache.hadoop.hive.ql.exec.tez.ReduceRecordSource$GroupIterator.next(ReduceRecordSource.java:363)}}
> {{ ... 19 more}}
> {quote}
> I just add a check in the patch.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
