Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
HDFS >> mail # user >> Re: Hive on Oracle


Copy link to this message
-
Re: Hive on Oracle
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, "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> 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 <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Date: Fri, 17 May 2013 20:43:46 -0700 (PDT)
To: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]><[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>; [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]><[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>; User<[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
ReplyTo: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>
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: "[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>" <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
To: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>; Raj Hadoop <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>; User <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
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 <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
Date: Fri, 17 May 2013 17:10:07 -0700 (PDT)
To: Hive<[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>; User<[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>>
ReplyTo: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>
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.