I define outputformat class, but the class don't take effect

I define inputformat and outputformat for one tables, example below: create table test3 ( id int, name string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS inputformat 'my.format.MyInputFormat' outputformat 'my.format.MyOutputFormat'. I find the my.format.MyInputFormat class take ef

Re: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver

Narendra 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 mailto:guru.pra...@ibibogroup.com>> wrote: Hi all, When i am running "select count(1) from searchlogs",

Re: IN clause usage in "where"

find_in_set is documented on this page: http://wiki.apache.org/hadoop/Hive/LanguageManual/UDF But Hive 0.6 also supports the IN syntax (HIVE-801). JVS On Oct 12, 2010, at 10:23 AM, Karthik wrote: Neil, Thanks a lot, that works like a charm. Perhaps, that should go into the Hive Wiki page to

Re: IN clause usage in "where"

Neil, Thanks a lot, that works like a charm. Perhaps, that should go into the Hive Wiki page too sometime. Regards, Karthik. From: Neil Xu To: user@hive.apache.org Sent: Mon, October 11, 2010 6:42:10 PM Subject: Re: IN clause usage in "where" you can try

Re: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver

Guru, The error message is in your tasktracker log. Go the link pointed by hive when the job fails to find the logs. In your case it was http://xx.xx.xx.xxx:50030/taskdetails.jsp?jobid=job_201009280549_0050&tipid=task_201009280549_0050_r_00 . This particular link might have expired by now, so r

boolean types thru a transform script

I'm trying to pass a FALSE value thru a custom transform script to another table, like so: FROM ( FROM downloads SELECT project, file, os, FALSE as folder, country, dt WHERE dt='2010-05-14' DISTRIBUTE BY project SORT BY project as

Re: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver

Restarting hadoop server is not working for me. Thanks & Regards Guru Prasad ~guru On 10/12/2010 07:24 PM, Narendra wrote: We just restarted the hadoop server... On Tue, Oct 12, 2010 at 6:57 PM, vaibhav negi > wrote: Hi Narendra, What do u mean by b

Re: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver

We just restarted the hadoop server... On Tue, Oct 12, 2010 at 6:57 PM, vaibhav negi wrote: > 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 wrote: > >> It seemed like a problem

Hive 0.6.0 Release

Was Hive 0.6.0 Released? If so where is it available for download please? Thanks David

Re: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver

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 wrote: > It seemed like a problem with communications between nodes. We bounced > hadoop and the query started working. > > > On Tue, Oct 12, 2010

Re: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver

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 wrote: > I was getting the same issue. Looked into jobtracker logs in /logs/hadoop > directory and there was an issue related to integer to st

Re: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver

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 wrote: > Even I am facing the

Re: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver

Hi, I too was stuck at this problem. On investigation i found that this error occurs when reduce task is trying to resolve hostname of task tracker returned by map task. I recompiled hadoop code . map reduce and all queries started working. However , task tracker at second datanode stopped working

Re: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.ExecDriver

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 wrote: > Hi all, > When i am running "select count(1) from searchlogs", I am getting following > errors. > While "select * from search