You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Chinna Rao Lalam (JIRA)" <ji...@apache.org> on 2014/04/03 19:43:24 UTC
[jira] [Commented] (HIVE-6832) HiveServer2 not able to create table
while using oracle DB for metastore.
[ 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)