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<mailto:nimar...@pssd.com>> Reply-To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>> Date: Monday, October 7, 2013 5:13 PM To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto: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.