Hi Martin, Are these tables created by any serde?
On Tue, Oct 8, 2013 at 9:47 PM, Martin, Nick <nimar...@pssd.com> wrote: > Hi Sanjay, thanks for the suggestion. **** > > ** ** > > There are no partitions on either table. **** > > ** ** > > *From:* Sanjay Subramanian [mailto:sanjay.subraman...@wizecommerce.com] > *Sent:* Monday, October 07, 2013 8:19 PM > *To:* user@hive.apache.org > *Subject:* Re: Execution failed with exit status: 3**** > > ** ** > > Hi Nick**** > > ** ** > > How many partitions are there in table t1 and table t2**** > > If there are many partitions in either t1 or t2 or both can u mod your > query as follows and see if the error comes up **** > > ** ** > > SELECT**** > > T1.somecolumn,**** > > T2.someothercolumn**** > > FROM **** > > (SELECT * FROM t1 WHERE partition_column1='<some_val>') T1**** > > JOIN **** > > (SELECT * FROM t2 WHERE partition_column2='<some_val>') T2**** > > ON (T1.idfield=T2.idfield)**** > > ** ** > > ** ** > > Thanks**** > > Regards**** > > ** ** > > sanjay**** > > ** ** > > email : sanjay.subraman...@wizecommerce.com**** > > Irc : sanjaysub (channel #noc)**** > > skype : sanjaysubramanian**** > > mobile : (925) 399 2692**** > > ** ** > > *From: *<Martin>, Nick <nimar...@pssd.com> > *Reply-To: *"user@hive.apache.org" <user@hive.apache.org> > *Date: *Monday, October 7, 2013 5:13 PM > *To: *"user@hive.apache.org" <user@hive.apache.org> > *Subject: *Execution failed with exit status: 3**** > > ** ** > > Hi all,**** > > **** > > I’m doing a very basic join in Hive and getting the error below. The > HiveQL join syntax I’m using is:**** > > **** > > SELECT**** > > T1.somecolumn,**** > > T2.someothercolumn**** > > FROM t1**** > > JOIN t2**** > > ON (t1.idfield=t2.idfield)**** > > **** > > **** > > **** > > Driver returned: 3. Errors: OK**** > > Total MapReduce jobs = 1**** > > setting HADOOP_USER_NAME someuser**** > > Execution failed with exit status: 3**** > > Obtaining error information**** > > **** > > Task failed!**** > > Task ID:**** > > Stage-4**** > > **** > > Logs:**** > > **** > > FAILED: Execution Error, return code 3 from > org.apache.hadoop.hive.ql.exec.MapredLocalTask**** > > I searched through the logs and couldn’t find anything terribly useful, > although perhaps I’m missing something. Is this a common error I’m just now > coming across?**** > > **** > > On Hive 0.11**** > > **** > > Thanks!**** > > Nick**** > > ** ** > > CONFIDENTIALITY NOTICE > ====================== > This email message and any attachments are for the exclusive use of the > intended recipient(s) and may contain confidential and privileged > information. Any unauthorized review, use, disclosure or distribution is > prohibited. If you are not the intended recipient, please contact the > sender by reply email and destroy all copies of the original message along > with any attachments, from your computer system. If you are the intended > recipient, please be advised that the content of this message is subject to > access, review and disclosure by the sender's Email System Administrator.* > *** > -- Nitin Pawar
