Hive错误：java.lang.Throwable：子错误 [英] Hive error: java.lang.Throwable: Child Error

问题描述

我正在使用CDH 5.9，而执行以下配置单元查询时，它将引发错误。有关这个问题的任何想法？
对于正常的select查询来说它的工作正常，但是对于复杂的查询，它会导致失败。

I am using CDH 5.9, while executing following hive query it is throwing error. Any idea about the issue? For normal select query its working but for complex query it results failure.

hive> select * from table where dt='22-01-2017' and field like '%xyz%' limit 10;
Query ID = hdfs_20170123200303_44a9c423-4bb3-4f80-ade4-b1312971eb63
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_201701131637_0067, Tracking URL = http://cdhum03.temp-dsc-updates.bms.bz:50030/jobdetails.jsp?jobid=job_201701131637_0067
Kill Command = /usr/lib/hadoop/bin/hadoop job  -kill job_201701131637_0067
Hadoop job information for Stage-1: number of mappers: 6; number of reducers: 0
2017-01-23 20:05:46,563 Stage-1 map = 100%,  reduce = 100%
Ended Job = job_201701131637_0067 with errors
Error during job, obtaining debugging information...
Job Tracking URL: http://cdhum03.temp-dsc-updates.bms.bz:50030/jobdetails.jsp?jobid=job_201701131637_0067
Examining task ID: task_201701131637_0067_m_000007 (and more) from job job_201701131637_0067
Examining task ID: task_201701131637_0067_r_000000 (and more) from job job_201701131637_0067

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

URL:
  http://cdhum03.temp-dsc-updates.bms.bz:50030/taskdetails.jsp?jobid=job_201701131637_0067&tipid=task_201701131637_0067_m_000006
-----
Diagnostic Messages for this Task:
java.lang.Throwable: Child Error
    at org.apache.hadoop.mapred.TaskRunner.run(TaskRunner.java:250)
Caused by: java.io.IOException: Task process exit with nonzero status of 126.
    at org.apache.hadoop.mapred.TaskRunner.run(TaskRunner.java:237)


FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
MapReduce Jobs Launched:
Stage-Stage-1: Map: 6   HDFS Read: 0 HDFS Write: 0 FAIL
Total MapReduce CPU Time Spent: 0 msec

谢谢。

Thanks.

推荐答案

请检查您的数据大小，因为您的工作需要更多的日志空间，但jvm较少请扩展您的群集或使用特定的查询 -
select * from table where dt = '22 -01-2017'，字段'％xyz％'限制10
，因为'％xyz％'将更好地检查整个数据以使用特定的要求。
否则删除您的表并创建一个新的分区表作为分区列。

Please check your data size as your job needs more space for logs but the jvm are less please scale your cluster or use specific query as you are using - select * from table where dt='22-01-2017' and field like '%xyz%' limit 10 , as '%xyz%' will check whole data better to use specific requirement. Else drop your table and create a new partitioned table with date as a partition column.

这篇关于Hive错误：java.lang.Throwable：子错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！