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" <drah...@googlemail.com> 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 data type to > clob and it worked > > Not sure if it's hive bug > > On Tuesday, September 23, 2014, Alan Gates <ga...@hortonworks.com> wrote: > >> 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 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 delimited >> fields terminated by ","; >> FAILED: Execution Error, return code 1 from >> org.apache.hadoop.hive.ql.exec.DDLTask. MetaException( >> message:javax.jdo.JDODataStoreException: An exception was thrown while >> adding/validating class(es) : ORA-01754: a table may contain only one >> column of type LONG >> >> java.sql.SQLException: ORA-01754: a table may contain only one column of >> type LONG >> >> at >> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) >> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) >> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) >> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) >> at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) >> at >> oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946) >> at >> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160) >> at >> oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1679) >> >> >> -- >> Sent with Postbox <http://www.getpostbox.com> >> >> CONFIDENTIALITY NOTICE >> NOTICE: This message is intended for the use of the individual or entity >> to which it is addressed and may contain information that is confidential, >> privileged and exempt from disclosure under applicable law. If the reader >> of this message is not the intended recipient, you are hereby notified that >> any printing, copying, dissemination, distribution, disclosure or >> forwarding of this communication is strictly prohibited. If you have >> received this communication in error, please contact the sender immediately >> and delete it from your system. Thank You. > >
