I'm HIVE 1.0.0 and I got this error Query ID = hadoop_20151023210202_9d73cf48-62f0-4d47-ae26-f5dfff0a24d9 Total jobs = 3 Execution log at: /var/log/hive/tmp/hadoop/hadoop_20151023210202_9d73cf48-62f0-4d47-ae26-f5dfff0a24d9.log 2015-10-23 09:03:14 Starting to launch local task to process map join; maximum memory = 1013645312 2015-10-23 09:03:23 Dump the side-table for tag: 1 with group count: 27 into file: file:/var/log/hive/tmp/hadoop/ccfa168d-3b18-4551-b253-070682b406a0/hive_2015-10-23_21-02-55_298_3710383116074055586-1/-local-10004/HashTable-Stage-8/MapJoin-mapfile311--.hashtable 2015-10-23 09:03:26 Uploaded 1 File to: file:/var/log/hive/tmp/hadoop/ccfa168d-3b18-4551-b253-070682b406a0/hive_2015-10-23_21-02-55_298_3710383116074055586-1/-local-10004/HashTable-Stage-8/MapJoin-mapfile311--.hashtable (1216 bytes) 2015-10-23 09:03:26 End of local task; Time Taken: 11.675 sec. Execution completed successfully MapredLocal task succeeded Launching Job 1 out of 3 Number of reduce tasks is set to 0 since there's no reduce operator Starting Job = job_1445632064722_0029, Tracking URL = http://ip-10-252-112-226.sa-east-1.compute.internal:20888/proxy/application_1445632064722_0029/ Kill Command = /usr/lib/hadoop/bin/hadoop job -kill job_1445632064722_0029 Hadoop job information for Stage-8: number of mappers: 1; number of reducers: 0 2015-10-23 21:03:43,140 Stage-8 map = 0%, reduce = 0% 2015-10-23 21:04:25,621 Stage-8 map = 100%, reduce = 0% Ended Job = job_1445632064722_0029 with errors Error during job, obtaining debugging information... Examining task ID: task_1445632064722_0029_m_000000 (and more) from job job_1445632064722_0029
Task with the most failures(4): ----- Task ID: task_1445632064722_0029_m_000000 URL: http://ip-10-252-112-226.sa-east-1.compute.internal:8088/taskdetails.jsp?jobid=job_1445632064722_0029&tipid=task_1445632064722_0029_m_000000 ----- Diagnostic Messages for this Task: Error: java.lang.RuntimeException: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing row {"bi_lead_id":2459,"consultor":2,"etapa":"Atendimento","tempo_ate":null,"duracao":null,"data":"2015-03-16 18:08:41"} at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.map(ExecMapper.java:185) at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:65) at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:452) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:344) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:171) 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:1628) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:166) Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error while processing row {"bi_lead_id":2459,"consultor":2,"etapa":"Atendimento","tempo_ate":null,"duracao":null,"data":"2015-03-16 18:08:41"} at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:503) at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.map(ExecMapper.java:176) ... 8 more Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Unexpected exception: org.apache.hadoop.io.Text cannot be cast to org.apache.hadoop.hive.serde2.io.HiveVarcharWritable at org.apache.hadoop.hive.ql.exec.MapJoinOperator.processOp(MapJoinOperator.java:311) 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:493) ... 9 more Caused by: java.lang.ClassCastException: org.apache.hadoop.io.Text cannot be cast to org.apache.hadoop.hive.serde2.io.HiveVarcharWritable at org.apache.hadoop.hive.serde2.objectinspector.primitive.WritableHiveVarcharObjectInspector.copyObject(WritableHiveVarcharObjectInspector.java:109) at org.apache.hadoop.hive.serde2.objectinspector.ObjectInspectorUtils.copyToStandardObject(ObjectInspectorUtils.java:305) at org.apache.hadoop.hive.ql.exec.JoinUtil.computeValues(JoinUtil.java:193) at org.apache.hadoop.hive.ql.exec.CommonJoinOperator.getFilteredValue(CommonJoinOperator.java:408) at org.apache.hadoop.hive.ql.exec.MapJoinOperator.processOp(MapJoinOperator.java:295) ... 13 more FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask MapReduce Jobs Launched: Stage-Stage-8: Map: 1 HDFS Read: 0 HDFS Write: 0 FAIL Total MapReduce CPU Time Spent: 0 msec Command exiting with ret '2' Best, -- *Daniel Lopes, B.Eng* Data Scientist - BankFacil CREA/SP 5069410560 <http://edital.confea.org.br/ConsultaProfissional/cartao.aspx?rnp=2613651334> Mob +55 (18) 99764-2733 <callto:+5518997642733> Ph +55 (11) 3522-8009 http://about.me/dannyeuu Av. Nova Independência, 956, São Paulo, SP Bairro Brooklin Paulista CEP 04570-001 https://www.bankfacil.com.br