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 <vihan...@apache.org> Authored: Mon Jan 28 11:14:05 2019 -0800 Committer: Vihang Karajgaonkar <vihan...@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;