RE: configuring Hive metastore to use Oracle DB ignored

2015-03-09 Thread Mich Talebzadeh
email is virus free, therefore neither Peridale Ltd, its subsidiaries nor their employees accept any responsibility. From: Mich Talebzadeh [mailto:m...@peridale.co.uk] Sent: 09 March 2015 09:28 To: user@hive.apache.org Subject: configuring Hive metastore to use Oracle DB ignored Hi all,

configuring Hive metastore to use Oracle DB ignored

2015-03-09 Thread Mich Talebzadeh
Hi all, I am trying to use an Oracle DB as the metastore for Hive. I have create all the users and connections, added Oracle jar file ojdbc6.jar to /usr/lib/hive/lib. I have also renamed the derby jar file derby-10.10.1.1.jar to derby-10.10.1.1.jar_ori so it does not use the embedded Derby