You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by vi...@apache.org on 2019/01/29 18:42:00 UTC

hive git commit: HIVE-21077 : Database and Catalogs should have creation time (addendum) (Vihang Karajgaonkar, reviewed by Naveen Gangam)

Repository: hive
Updated Branches:
  refs/heads/master 71dfd1d11 -> 61d8a06b9


HIVE-21077 : Database and Catalogs should have creation time (addendum) (Vihang Karajgaonkar, reviewed by Naveen Gangam)


Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/61d8a06b
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/61d8a06b
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/61d8a06b

Branch: refs/heads/master
Commit: 61d8a06b97e7df810d0aea399d1a9dcecb58bac1
Parents: 71dfd1d
Author: Vihang Karajgaonkar <vi...@apache.org>
Authored: Mon Jan 28 11:14:05 2019 -0800
Committer: Vihang Karajgaonkar <vi...@apache.org>
Committed: Tue Jan 29 10:41:24 2019 -0800

----------------------------------------------------------------------
 .../src/main/sql/mssql/hive-schema-3.2.0.mssql.sql               | 4 ++--
 .../src/main/sql/mssql/hive-schema-4.0.0.mssql.sql               | 4 ++--
 .../src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql          | 4 ++--
 3 files changed, 6 insertions(+), 6 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/hive/blob/61d8a06b/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-3.2.0.mssql.sql
----------------------------------------------------------------------
diff --git a/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-3.2.0.mssql.sql b/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-3.2.0.mssql.sql
index e120128..cd04b4c 100644
--- a/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-3.2.0.mssql.sql
+++ b/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-3.2.0.mssql.sql
@@ -286,7 +286,7 @@ CREATE TABLE DBS
     OWNER_NAME nvarchar(128) NULL,
     OWNER_TYPE nvarchar(10) NULL,
     CTLG_NAME nvarchar(256),
-    CREATE_TIME BIGINT
+    CREATE_TIME INT
 );
 
 ALTER TABLE DBS ADD CONSTRAINT DBS_PK PRIMARY KEY (DB_ID);
@@ -699,7 +699,7 @@ CREATE TABLE CTLGS (
       "NAME" nvarchar(256),
       "DESC" nvarchar(4000),
       LOCATION_URI nvarchar(4000) not null,
-      CREATE_TIME BIGINT
+      CREATE_TIME INT
 );
 
 CREATE UNIQUE INDEX UNIQUE_CTLG ON CTLGS ("NAME");

http://git-wip-us.apache.org/repos/asf/hive/blob/61d8a06b/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-4.0.0.mssql.sql
----------------------------------------------------------------------
diff --git a/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-4.0.0.mssql.sql b/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-4.0.0.mssql.sql
index 895bf01..383d3bc 100644
--- a/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-4.0.0.mssql.sql
+++ b/standalone-metastore/metastore-server/src/main/sql/mssql/hive-schema-4.0.0.mssql.sql
@@ -286,7 +286,7 @@ CREATE TABLE DBS
     OWNER_NAME nvarchar(128) NULL,
     OWNER_TYPE nvarchar(10) NULL,
     CTLG_NAME nvarchar(256),
-    CREATE_TIME BIGINT
+    CREATE_TIME INT
 );
 
 ALTER TABLE DBS ADD CONSTRAINT DBS_PK PRIMARY KEY (DB_ID);
@@ -700,7 +700,7 @@ CREATE TABLE CTLGS (
       "NAME" nvarchar(256),
       "DESC" nvarchar(4000),
       LOCATION_URI nvarchar(4000) not null,
-      CREATE_TIME BIGINT
+      CREATE_TIME INT
 );
 
 CREATE UNIQUE INDEX UNIQUE_CTLG ON CTLGS ("NAME");

http://git-wip-us.apache.org/repos/asf/hive/blob/61d8a06b/standalone-metastore/metastore-server/src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql
----------------------------------------------------------------------
diff --git a/standalone-metastore/metastore-server/src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql b/standalone-metastore/metastore-server/src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql
index 803bf5e..fd78419 100644
--- a/standalone-metastore/metastore-server/src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql
+++ b/standalone-metastore/metastore-server/src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql
@@ -21,8 +21,8 @@ INSERT INTO SEQUENCE_TABLE (SEQUENCE_NAME, NEXT_VAL) VALUES ('org.apache.hadoop.
 ALTER TABLE "SERDE_PARAMS" ALTER COLUMN "PARAM_VALUE" nvarchar(MAX);
 
 -- HIVE-21077
-ALTER TABLE DBS ADD CREATE_TIME BIGINT;
-ALTER TABLE CTLGS ADD CREATE_TIME BIGINT;
+ALTER TABLE DBS ADD CREATE_TIME INT;
+ALTER TABLE CTLGS ADD CREATE_TIME INT;
 
 -- These lines need to be last.  Insert any changes above.
 UPDATE VERSION SET SCHEMA_VERSION='3.2.0', VERSION_COMMENT='Hive release version 3.2.0' where VER_ID=1;