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

Oracle backend for Hive Metastore

2014-09-22 Thread Rahul Channe
Hi All, I am using oracle as hive metastore. I could see the schema created in oracle after logging into hive and executing create database command successfully. When i am trying to create table in hive its throwing error, please help hive> create table test ( name string,age int) row format de