You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@ambari.apache.org by ma...@apache.org on 2013/06/13 03:00:47 UTC
svn commit: r1492516 - in
/incubator/ambari/branches/branch-1.2.4/ambari-server: pom.xml
src/main/resources/hive-schema-0.10.0.oracle.sql
Author: mahadev
Date: Thu Jun 13 01:00:47 2013
New Revision: 1492516
URL: http://svn.apache.org/r1492516
Log:
AMBARI-2357. Make hive-schema-0.10.0.oracle.sql available to the user. (mahadev)
Added:
incubator/ambari/branches/branch-1.2.4/ambari-server/src/main/resources/hive-schema-0.10.0.oracle.sql
Modified:
incubator/ambari/branches/branch-1.2.4/ambari-server/pom.xml
Modified: incubator/ambari/branches/branch-1.2.4/ambari-server/pom.xml
URL: http://svn.apache.org/viewvc/incubator/ambari/branches/branch-1.2.4/ambari-server/pom.xml?rev=1492516&r1=1492515&r2=1492516&view=diff
==============================================================================
--- incubator/ambari/branches/branch-1.2.4/ambari-server/pom.xml (original)
+++ incubator/ambari/branches/branch-1.2.4/ambari-server/pom.xml Thu Jun 13 01:00:47 2013
@@ -278,6 +278,9 @@
<source>
<location>src/main/resources/Ambari-DDL-MySQL-DROP.sql</location>
</source>
+ <source>
+ <location>src/main/resources/hive-schema-0.10.0.oracle.sql</location>
+ </source>
</sources>
</mapping>
<mapping>
Added: incubator/ambari/branches/branch-1.2.4/ambari-server/src/main/resources/hive-schema-0.10.0.oracle.sql
URL: http://svn.apache.org/viewvc/incubator/ambari/branches/branch-1.2.4/ambari-server/src/main/resources/hive-schema-0.10.0.oracle.sql?rev=1492516&view=auto
==============================================================================
--- incubator/ambari/branches/branch-1.2.4/ambari-server/src/main/resources/hive-schema-0.10.0.oracle.sql (added)
+++ incubator/ambari/branches/branch-1.2.4/ambari-server/src/main/resources/hive-schema-0.10.0.oracle.sql Thu Jun 13 01:00:47 2013
@@ -0,0 +1,44 @@
+-- Table SEQUENCE_TABLE is an internal table required by DataNucleus.
+-- NOTE: Some versions of SchemaTool do not automatically generate this table.
+-- See http://www.datanucleus.org/servlet/jira/browse/NUCRDBMS-416
+CREATE TABLE SEQUENCE_TABLE
+(
+ SEQUENCE_NAME VARCHAR2(255) NOT NULL,
+ NEXT_VAL NUMBER NOT NULL
+);
+
+ALTER TABLE SEQUENCE_TABLE ADD CONSTRAINT PART_TABLE_PK PRIMARY KEY (SEQUENCE_NAME);
+
+-- Table NUCLEUS_TABLES is an internal table required by DataNucleus.
+-- This table is required if datanucleus.autoStartMechanism=SchemaTable
+-- NOTE: Some versions of SchemaTool do not automatically generate this table.
+-- See http://www.datanucleus.org/servlet/jira/browse/NUCRDBMS-416
+CREATE TABLE NUCLEUS_TABLES
+(
+ CLASS_NAME VARCHAR2(128) NOT NULL,
+ TABLE_NAME VARCHAR2(128) NOT NULL,
+ TYPE VARCHAR2(4) NOT NULL,
+ OWNER VARCHAR2(2) NOT NULL,
+ VERSION VARCHAR2(20) NOT NULL,
+ INTERFACE_NAME VARCHAR2(255) NULL
+);
+
+ALTER TABLE NUCLEUS_TABLES ADD CONSTRAINT NUCLEUS_TABLES_PK PRIMARY KEY (CLASS_NAME);
+
+-- Table TBLS for classes [org.apache.hadoop.hive.metastore.model.MTable]
+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 CLOB NULL,
+ VIEW_ORIGINAL_TEXT CLOB NULL
+);
+
+ALTER TABLE TBLS ADD CONSTRAINT TBLS_PK PRIMARY KEY (TBL_ID);