Hi, This is my xml file
<Company> <Employee> <id>100</id> <ename>ranjini</ename> <dept>IT1</dept> <sal>123456</sal> <location>nextlevel1</location> <Address> <Home>Chennai1</Home> <Office>Navallur1</Office> </Address> </Employee> <Employee> <id>1001</id> <ename>ranjinikumar</ename> <dept>IT</dept> <sal>1234516</sal> <location>nextlevel</location> <Address> <Home>Chennai</Home> <Office>Navallur</Office> </Address> </Employee> </Company> In hive shell , i use xpath hive> select xpath(str,'/Company/Employee/ename/text()') from hivexml; Total MapReduce 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_201401081034_0019, Tracking URL = http://localhost:50030/jobdetails.jsp?jobid=job_201401081034_0019 Kill Command = /usr/local/hadoop/bin/../bin/hadoop job -Dmapred.job.tracker=localhost:4441 -kill job_201401081034_0019 2014-01-08 14:18:18,199 Stage-1 map = 0%, reduce = 0% 2014-01-08 14:18:45,294 Stage-1 map = 100%, reduce = 100% Ended Job = job_201401081034_0019 with errors FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask hive> When check in the URL of tasktracker and jobtracker i did not find any error log there. Please help to fix this , What is correct step to solve. Thanks in advance. Ranjini R
