hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rahul Channe <drah...@googlemail.com>
Subject Oracle backend for Hive Metastore
Date Mon, 22 Sep 2014 17:47:45 GMT
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)

Mime
View raw message