Try installing cloudera manager 4.1.2. It has bundled Hadoop hive and few other components. I have this version in production. Cloudera has pretty good documentation. This way u don't have to spend time installing versions that work successful with each other.
Sent from my iPhone On May 17, 2013, at 8:49 PM, "bejoy...@yahoo.com<mailto:bejoy...@yahoo.com>" <bejoy...@yahoo.com<mailto:bejoy...@yahoo.com>> wrote: Hi Raj Which jar depends on what version of oracle you are using? The jar version corresponding to each oracle release would be there in oracle documentations online. JDBC Jars should be available from the oracle website for free download. Regards Bejoy KS Sent from remote device, Please excuse typos ________________________________ From: Raj Hadoop <hadoop...@yahoo.com<mailto:hadoop...@yahoo.com>> Date: Fri, 17 May 2013 20:43:46 -0700 (PDT) To: bejoy...@yahoo.com<mailto:bejoy...@yahoo.com><bejoy...@yahoo.com<mailto:bejoy...@yahoo.com>>; u...@hive.apache.org<mailto:u...@hive.apache.org><u...@hive.apache.org<mailto:u...@hive.apache.org>>; User<user@hadoop.apache.org<mailto:user@hadoop.apache.org>> ReplyTo: u...@hive.apache.org<mailto:u...@hive.apache.org> Subject: Re: Hive on Oracle Thanks for the reply. Can you specify whether which jar file need need to be used ? where can i get the jar file? does oracle provide one for free? let me know please. Thanks, Raj ________________________________ From: "bejoy...@yahoo.com<mailto:bejoy...@yahoo.com>" <bejoy...@yahoo.com<mailto:bejoy...@yahoo.com>> To: u...@hive.apache.org<mailto:u...@hive.apache.org>; Raj Hadoop <hadoop...@yahoo.com<mailto:hadoop...@yahoo.com>>; User <user@hadoop.apache.org<mailto:user@hadoop.apache.org>> Sent: Friday, May 17, 2013 11:42 PM Subject: Re: Hive on Oracle Hi The procedure is same as setting up mysql metastore. You need to use the jdbc driver/jar corresponding to the oracle version/release you are intending to use. Regards Bejoy KS Sent from remote device, Please excuse typos ________________________________ From: Raj Hadoop <hadoop...@yahoo.com<mailto:hadoop...@yahoo.com>> Date: Fri, 17 May 2013 17:10:07 -0700 (PDT) To: Hive<u...@hive.apache.org<mailto:u...@hive.apache.org>>; User<user@hadoop.apache.org<mailto:user@hadoop.apache.org>> ReplyTo: u...@hive.apache.org<mailto:u...@hive.apache.org> Subject: Hive on Oracle Hi, I am planning to install Hive and want to set up Meta store on Oracle. What is the procedure? Which driver (JDBC) do I need to use it? Thanks, Raj 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.