hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chinna Rao Lalam (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-6832) HiveServer2 not able to create table while using oracle DB for metastore.
Date Thu, 03 Apr 2014 17:43:24 GMT

    [ https://issues.apache.org/jira/browse/HIVE-6832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13959025#comment-13959025
] 

Chinna Rao Lalam commented on HIVE-6832:
----------------------------------------

Hi,
Metastore server address is configured in hive-site.xml ?

> HiveServer2 not able to create table while using oracle DB for metastore.
> -------------------------------------------------------------------------
>
>                 Key: HIVE-6832
>                 URL: https://issues.apache.org/jira/browse/HIVE-6832
>             Project: Hive
>          Issue Type: Bug
>          Components: HiveServer2
>    Affects Versions: 0.12.0
>            Reporter: surendra singh lilhore
>
> My datanucleus.autoCreateSchema is true.
> Exception in server log
> ================================
> 2014-04-03 19:01:03,919 INFO  DataNucleus.Datastore (Log4JLogger.java:info(77)) - The
class "org.apache.hadoop.hive.metastore.model.MOrder" is tagged as "embedded-only" so does
not have its own datastore table.
> 2014-04-03 19:01:05,250 ERROR DataNucleus.Datastore (Log4JLogger.java:error(115)) - Error
thrown executing CREATE TABLE TBLS
> (
>     TBL_ID NUMBER NOT NULL,
>     CREATE_TIME NUMBER (10) NOT NULL,
>     DB_ID NUMBER NULL,
>     LAST_ACCESS_TIME NUMBER (10) NOT NULL,
>     OWNER VARCHAR2(767) NULL,
>     RETENTION NUMBER (10) NOT NULL,
>     SD_ID NUMBER NULL,
>     TBL_NAME VARCHAR2(128) NULL,
>     TBL_TYPE VARCHAR2(128) NULL,
>     VIEW_EXPANDED_TEXT LONG NULL,
>     VIEW_ORIGINAL_TEXT LONG NULL
> )  : ORA-01754: a table may contain only one column of type LONG



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message