Hello yogesh, The only thing hive doesn't support in join is non equi join but in Ur case bellow hive ll definitely support. If u still getting error msg, plz paste it here. There must be something else.
Thanks Ashok ________________________________________ From: Mohit Durgapal [durgapalmo...@gmail.com] Sent: Wednesday, October 15, 2014 2:36 PM To: user@hive.apache.org Subject: Re: PLEASE HELP :: HOW TO DO INNER JOIN IN HIVE Hi Yogesh, Hive DOES support inner joins. For example for two tables a & b, the inner join query could be SELECT a.id<http://a.id>,a.item,b.color FROM a JOIN b ON (a.id<http://a.id> = b.id<http://b.id>) You also need to understand how hive converts the joins into mapreduce jobs for good performance. Please read about it here https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins & https://blog.safaribooksonline.com/2012/12/05/tip-using-joins-in-hive/ Regards Mohit On Wed, Oct 15, 2014 at 1:18 PM, yogesh dhari <yogeshh...@gmail.com<mailto:yogeshh...@gmail.com>> wrote: Hello all, I have a use case where I need to do inner join.. Like select A.iteam , B.Decsription, from iteam_table A INNER JOIN iteam_desc B on A.id = B.id As hive does not support Inner Join, Please suggest how to do it Thanks in Advance The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com