Re: Oracle backend for Hive Metastore

2014-09-23 Thread hadoop hive
You can import the metastore db in oracle directly. Inside oracle db @/path/to/oracle-hive-0.12.0.sql On Sep 23, 2014 9:08 PM, "Rahul Channe" wrote: > Hi Alan, > > I am using version 0.12.0, I did not create tables explicitly. > > Temporarily I modified the hive-metastore jar to update long dat

Re: Oracle backend for Hive Metastore

2014-09-23 Thread Rahul Channe
Hi Alan, I am using version 0.12.0, I did not create tables explicitly. Temporarily I modified the hive-metastore jar to update long data type to clob and it worked Not sure if it's hive bug On Tuesday, September 23, 2014, Alan Gates wrote: > What version of Hive are you using? > > Did you ex

Re: Oracle backend for Hive Metastore

2014-09-23 Thread Alan Gates
What version of Hive are you using? Did you explicitly create the tables in the metastore via the Oracle script or depend on DataNucleus to do it for you? Alan. Rahul Channe September 22, 2014 at 10:47 Hi All, I am using oracle as hive metastore. I could see