You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "surendra singh lilhore (JIRA)" <ji...@apache.org> on 2014/04/03 16:28:16 UTC
[jira] [Updated] (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:all-tabpanel ]
surendra singh lilhore updated HIVE-6832:
-----------------------------------------
Description:
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
was:My datanucleus.autoCreateSchema is true.
> 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)