hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hashut...@apache.org
Subject svn commit: r1574579 - in /hive/trunk/metastore/scripts/upgrade: derby/hive-schema-0.13.0.derby.sql mysql/hive-schema-0.13.0.mysql.sql oracle/hive-schema-0.13.0.oracle.sql postgres/hive-schema-0.13.0.postgres.sql
Date Wed, 05 Mar 2014 17:25:35 GMT
Author: hashutosh
Date: Wed Mar  5 17:25:34 2014
New Revision: 1574579

URL: http://svn.apache.org/r1574579
Log:
HIVE-6548 : Missing owner name and type fields in schema script for DBS table (Ashutosh Chauhan
via Thejas Nair)

Modified:
    hive/trunk/metastore/scripts/upgrade/derby/hive-schema-0.13.0.derby.sql
    hive/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.13.0.mysql.sql
    hive/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.13.0.oracle.sql
    hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.13.0.postgres.sql

Modified: hive/trunk/metastore/scripts/upgrade/derby/hive-schema-0.13.0.derby.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/derby/hive-schema-0.13.0.derby.sql?rev=1574579&r1=1574578&r2=1574579&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/derby/hive-schema-0.13.0.derby.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/derby/hive-schema-0.13.0.derby.sql Wed Mar  5 17:25:34
2014
@@ -16,7 +16,7 @@ CREATE FUNCTION "APP"."NUCLEUS_MATCHES" 
 -- DDL Statements for tables
 -- ----------------------------------------------
 
-CREATE TABLE "APP"."DBS" ("DB_ID" BIGINT NOT NULL, "DESC" VARCHAR(4000), "DB_LOCATION_URI"
VARCHAR(4000) NOT NULL, "NAME" VARCHAR(128));
+CREATE TABLE "APP"."DBS" ("DB_ID" BIGINT NOT NULL, "DESC" VARCHAR(4000), "DB_LOCATION_URI"
VARCHAR(4000) NOT NULL, "NAME" VARCHAR(128), "OWNER_NAME" VARCHAR(128), "OWNER_TYPE" VARCHAR(10));
 
 CREATE TABLE "APP"."TBL_PRIVS" ("TBL_GRANT_ID" BIGINT NOT NULL, "CREATE_TIME" INTEGER NOT
NULL, "GRANT_OPTION" SMALLINT NOT NULL, "GRANTOR" VARCHAR(128), "GRANTOR_TYPE" VARCHAR(128),
"PRINCIPAL_NAME" VARCHAR(128), "PRINCIPAL_TYPE" VARCHAR(128), "TBL_PRIV" VARCHAR(128), "TBL_ID"
BIGINT);
 

Modified: hive/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.13.0.mysql.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.13.0.mysql.sql?rev=1574579&r1=1574578&r2=1574579&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.13.0.mysql.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.13.0.mysql.sql Wed Mar  5 17:25:34
2014
@@ -88,6 +88,8 @@ CREATE TABLE IF NOT EXISTS `DBS` (
   `DESC` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
   `DB_LOCATION_URI` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
   `NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
+  `OWNER_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
+  `OWNER_TYPE` varchar(10) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
   PRIMARY KEY (`DB_ID`),
   UNIQUE KEY `UNIQUE_DATABASE` (`NAME`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Modified: hive/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.13.0.oracle.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.13.0.oracle.sql?rev=1574579&r1=1574578&r2=1574579&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.13.0.oracle.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/oracle/hive-schema-0.13.0.oracle.sql Wed Mar  5 17:25:34
2014
@@ -78,7 +78,9 @@ CREATE TABLE DBS
     DB_ID NUMBER NOT NULL,
     "DESC" VARCHAR2(4000) NULL,
     DB_LOCATION_URI VARCHAR2(4000) NOT NULL,
-    "NAME" VARCHAR2(128) NULL
+    "NAME" VARCHAR2(128) NULL,
+    OWNER_NAME VARCHAR2(128) NULL,
+    OWNER_TYPE VARCHAR2(10) NULL
 );
 
 ALTER TABLE DBS ADD CONSTRAINT DBS_PK PRIMARY KEY (DB_ID);

Modified: hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.13.0.postgres.sql
URL: http://svn.apache.org/viewvc/hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.13.0.postgres.sql?rev=1574579&r1=1574578&r2=1574579&view=diff
==============================================================================
--- hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.13.0.postgres.sql (original)
+++ hive/trunk/metastore/scripts/upgrade/postgres/hive-schema-0.13.0.postgres.sql Wed Mar
 5 17:25:34 2014
@@ -80,7 +80,9 @@ CREATE TABLE "DBS" (
     "DB_ID" bigint NOT NULL,
     "DESC" character varying(4000) DEFAULT NULL::character varying,
     "DB_LOCATION_URI" character varying(4000) NOT NULL,
-    "NAME" character varying(128) DEFAULT NULL::character varying
+    "NAME" character varying(128) DEFAULT NULL::character varying,
+    "OWNER_NAME" character varying(128) DEFAULT NULL::character varying,
+    "OWNER_TYPE" character varying(10) DEFAULT NULL::character varying
 );
 
 



Mime
View raw message