You just need to enable map joins before executing your join query. hive> Set hive.auto.convert.join=true
Regards Bejoy KS Sent from handheld, please excuse typos. -----Original Message----- From: abhishek dodda <abhishek.dod...@gmail.com> Date: Mon, 11 Jun 2012 08:59:49 To: <user@hive.apache.org> Reply-To: user@hive.apache.org Subject: Hive Mapside join with Distributed cache hi all, Map side join with distributed cache how to do this? can any one help me on this. Regards Abhishek