Hi Pradeep, Your config values will need to look something like this:
javax.jdo.option.ConnectionURL = jdbc:oracle:thin:@'host':'port':'db-name' javax.jdo.option.ConnectionDriverName = oracle.jdbc.driver.OracleDriver javax.jdo.option.ConnectionUserName </hadoop/ConnectionUserName> = your-user-name javax.jdo.option.ConnectionPassword </hadoop/ConnectionPassword> = your-password Obviously you need to replace 'host', 'port' and 'db-name' with appropriate values. You also need to get a copy of the Oracle thin JDBC driver (or some other JDBC driver that supports Oracle) and make sure that it is available in Hive's classpath (e.g. by referencing it in HIVE_AUX_JARS_PATH). If this does not work out of the box I recommend consulting the documentation that comes with your JDBC driver. Thanks. Carl On Tue, May 25, 2010 at 11:12 AM, Pradeep Kamath <[email protected]>wrote: > Hi Sonal, > I want to set up hive metastore with Oracle as backend and wanted the > config values for that. > > Thanks, > Pradee > > -----Original Message----- > From: Sonal Goyal [mailto:[email protected]] > Sent: Tuesday, May 25, 2010 10:42 AM > To: [email protected] > Subject: Fwd: metastore set up with Oracle backend? > > Hi Pradeep, > > You can check the config values for MySQL as a metastore for Hive at > the following link: > > > http://www.mazsoft.com/blog/post/2010/02/01/Setting-up-HadoopHive-to-use-MySQL-as-metastore.aspx > > Thanks and Regards, > Sonal > www.meghsoft.com > http://in.linkedin.com/in/sonalgoyal > > > On Tue, May 25, 2010 at 10:00 PM, Pradeep Kamath <[email protected]> > wrote: > > > > Hi Aaron, > > > > Can you share some details along the lines of what is described in > http://wiki.apache.org/hadoop/Hive/AdminManual/MetastoreAdmin#Local_Metastorefor > MySQL? (Essentially what changes are needed in properties to get this > working) > > > > > > > > Thanks, > > > > Pradeep > > > > > > > > ________________________________ > > > > From: Aaron McCurry [mailto:[email protected]] > > Sent: Monday, May 24, 2010 1:42 PM > > To: [email protected] > > Subject: Re: metastore set up with Oracle backend? > > > > > > > > I have done it, everything seemed to work just fine. > > > > > > > > Aaron > > > > > > > > > > > > On Mon, May 24, 2010 at 4:37 PM, Pradeep Kamath <[email protected]> > wrote: > > > > Hi, > > > > Can hive metastore be setup with Oracle as backend without any code > changes? Has anyone tried this? Any pointers would be much appreciated. > > > > > > > > Thanks, > > > > Pradeep > > > > >
