Hi Narendra, What do u mean by bouncing hadoop? Can u share the solution that worked for u?
Vaibhav Negi On Tue, Oct 12, 2010 at 6:48 PM, Narendra <uncle.n...@gmail.com> wrote: > It seemed like a problem with communications between nodes. We bounced > hadoop and the query started working. > > > On Tue, Oct 12, 2010 at 6:07 PM, Parag Arora <pa...@webaroo.com> wrote: > >> I was getting the same issue. Looked into jobtracker logs in /logs/hadoop >> directory and there was an issue related to integer to string casting. I >> think, return code 2 has to deal with casting. Can you copy/paste your >> query. >> >> On Tue, Oct 12, 2010 at 5:59 PM, Narendra <uncle.n...@gmail.com> wrote: >> >>> Even I am facing the same issue. In fact, select * works but if you give >>> a where clause, it cribs. >>> >>> Regards, >>> Narendra >>> >>> On Mon, Oct 11, 2010 at 1:40 PM, Guru Prasad <guru.pra...@ibibogroup.com >>> > wrote: >>> >>>> Hi all, >>>> When i am running "select count(1) from searchlogs", I am getting >>>> following errors. >>>> While "select * from searchlogs" is working properly. >>>> >>>> >>>> -------------------------------------------------------------------------------------- >>>> 2010-10-11 03:52:54,371 Stage-1 map = 0%, reduce = 0% >>>> 2010-10-11 03:53:00,467 Stage-1 map = 4%, reduce = 0% >>>> 2010-10-11 03:53:02,542 Stage-1 map = 5%, reduce = 0% >>>> 2010-10-11 03:53:03,566 Stage-1 map = 9%, reduce = 0% >>>> 2010-10-11 03:53:05,640 Stage-1 map = 13%, reduce = 0% >>>> 2010-10-11 03:53:06,644 Stage-1 map = 16%, reduce = 0% >>>> 2010-10-11 03:53:08,671 Stage-1 map = 20%, reduce = 0% >>>> 2010-10-11 03:53:09,720 Stage-1 map = 24%, reduce = 0% >>>> 2010-10-11 03:53:11,824 Stage-1 map = 29%, reduce = 0% >>>> 2010-10-11 03:53:14,883 Stage-1 map = 36%, reduce = 0% >>>> 2010-10-11 03:53:18,000 Stage-1 map = 44%, reduce = 0% >>>> 2010-10-11 03:53:21,037 Stage-1 map = 51%, reduce = 0% >>>> 2010-10-11 03:53:24,085 Stage-1 map = 56%, reduce = 0% >>>> 2010-10-11 03:53:27,203 Stage-1 map = 62%, reduce = 0% >>>> 2010-10-11 03:53:30,294 Stage-1 map = 69%, reduce = 0% >>>> 2010-10-11 03:53:33,519 Stage-1 map = 75%, reduce = 0% >>>> 2010-10-11 03:53:36,599 Stage-1 map = 82%, reduce = 0% >>>> 2010-10-11 03:53:39,866 Stage-1 map = 89%, reduce = 0% >>>> 2010-10-11 03:53:41,931 Stage-1 map = 91%, reduce = 0% >>>> 2010-10-11 03:53:42,942 Stage-1 map = 95%, reduce = 0% >>>> 2010-10-11 03:53:45,031 Stage-1 map = 98%, reduce = 0% >>>> 2010-10-11 03:53:46,042 Stage-1 map = 100%, reduce = 0% >>>> 2010-10-11 03:53:52,083 Stage-1 map = 100%, reduce = 1% >>>> *2010-10-11 03:54:21,328 Stage-1 map = 100%, reduce = 0%* >>>> 2010-10-11 03:54:33,424 Stage-1 map = 100%, reduce = 2% >>>> 2010-10-11 03:55:12,690 Stage-1 map = 100%, reduce = 3% >>>> *2010-10-11 03:55:42,905 Stage-1 map = 100%, reduce = 0%* >>>> 2010-10-11 03:55:55,010 Stage-1 map = 100%, reduce = 4% >>>> 2010-10-11 03:56:10,106 Stage-1 map = 100%, reduce = 5% >>>> 2010-10-11 03:56:49,384 Stage-1 map = 100%, reduce = 7% >>>> *2010-10-11 03:57:04,478 Stage-1 map = 100%, reduce = 0%* >>>> 2010-10-11 03:57:16,558 Stage-1 map = 100%, reduce = 7% >>>> 2010-10-11 03:57:31,679 Stage-1 map = 100%, reduce = 8% >>>> 2010-10-11 03:58:08,901 Stage-1 map = 100%, reduce = 9% >>>> *2010-10-11 03:58:27,026 Stage-1 map = 100%, reduce = 0%* >>>> 2010-10-11 03:58:33,067 Stage-1 map = 100%, reduce = 100% >>>> Ended Job = job_201009280549_0050 with errors >>>> >>>> Failed tasks with most(4) failures : >>>> Task URL: >>>> http://xx.xx.xx.xxx:50030/taskdetails.jsp?jobid=job_201009280549_0050&tipid=task_201009280549_0050_r_000000 >>>> >>>> FAILED: Execution Error, return code 2 from >>>> org.apache.hadoop.hive.ql.exec.ExecDriver >>>> >>>> ----------------------------------------------------------------------------------------------------------------------- >>>> >>>> Please help me out. >>>> >>>> Thanks & Regards >>>> Guru Prasad >>>> ~guru >>>> >>>> This message is intended only for the use of the addressee and may contain >>>> information that is privileged, confidential >>>> and exempt from disclosure under applicable law. If the reader of this >>>> message is not the intended recipient, or the >>>> employee or agent responsible for delivering the message to the intended >>>> recipient, you are hereby notified that any >>>> dissemination, distribution or copying of this communication is strictly >>>> prohibited. If you have received this e-mail >>>> in error, please notify us immediately by return e-mail and delete this >>>> e-mail and all attachments from your system. >>>> >>>> >>> >> >