Repository: hive Updated Branches: refs/heads/branch-3 e6e11a902 -> 7065c92ef
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/7065c92e Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/7065c92e Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/7065c92e Branch: refs/heads/branch-3 Commit: 7065c92ef2b037f0b95e85362f57c7836b334e47 Parents: e6e11a9 Author: Vihang Karajgaonkar <vihan...@apache.org> Authored: Tue Jan 29 10:50:52 2019 -0800 Committer: Vihang Karajgaonkar <vihan...@apache.org> Committed: Tue Jan 29 10:50:52 2019 -0800 ---------------------------------------------------------------------- .../src/main/sql/mssql/hive-schema-3.2.0.mssql.sql | 4 ++-- .../src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/7065c92e/standalone-metastore/src/main/sql/mssql/hive-schema-3.2.0.mssql.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/src/main/sql/mssql/hive-schema-3.2.0.mssql.sql b/standalone-metastore/src/main/sql/mssql/hive-schema-3.2.0.mssql.sql index b427f00..df0b0da 100644 --- a/standalone-metastore/src/main/sql/mssql/hive-schema-3.2.0.mssql.sql +++ b/standalone-metastore/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/7065c92e/standalone-metastore/src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql ---------------------------------------------------------------------- diff --git a/standalone-metastore/src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql b/standalone-metastore/src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql index 47a585c..a5bcf78 100644 --- a/standalone-metastore/src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql +++ b/standalone-metastore/src/main/sql/mssql/upgrade-3.1.0-to-3.2.0.mssql.sql @@ -17,8 +17,8 @@ ALTER TABLE TXN_WRITE_NOTIFICATION_LOG ADD CONSTRAINT TXN_WRITE_NOTIFICATION_LOG INSERT INTO SEQUENCE_TABLE (SEQUENCE_NAME, NEXT_VAL) VALUES ('org.apache.hadoop.hive.metastore.model.MTxnWriteNotificationLog', 1); -- 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;