[
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)
