Return-Path: X-Original-To: apmail-hive-commits-archive@www.apache.org Delivered-To: apmail-hive-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 367CA173AC for ; Wed, 6 May 2015 18:17:54 +0000 (UTC) Received: (qmail 75472 invoked by uid 500); 6 May 2015 18:17:54 -0000 Delivered-To: apmail-hive-commits-archive@hive.apache.org Received: (qmail 75438 invoked by uid 500); 6 May 2015 18:17:54 -0000 Mailing-List: contact commits-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hive.apache.org Delivered-To: mailing list commits@hive.apache.org Received: (qmail 75426 invoked by uid 99); 6 May 2015 18:17:54 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 May 2015 18:17:54 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id E5C33E042A; Wed, 6 May 2015 18:17:53 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: khorgath@apache.org To: commits@hive.apache.org Message-Id: <08636fa86efb41769447c6315e049b47@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: hive git commit: HIVE-9456 : Make Hive support unicode with MSSQL as Metastore backend (Xiaobing Zhou via Sushanth Sowmyan, reviewed by Thejas Nair) (part2/2) Date: Wed, 6 May 2015 18:17:53 +0000 (UTC) Repository: hive Updated Branches: refs/heads/master 8c93f2ba6 -> d39c829fa HIVE-9456 : Make Hive support unicode with MSSQL as Metastore backend (Xiaobing Zhou via Sushanth Sowmyan, reviewed by Thejas Nair) (part2/2) Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/d39c829f Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/d39c829f Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/d39c829f Branch: refs/heads/master Commit: d39c829fa42e572cf9141d00d87797ffe53c251e Parents: 8c93f2b Author: Sushanth Sowmyan Authored: Wed May 6 11:17:08 2015 -0700 Committer: Sushanth Sowmyan Committed: Wed May 6 11:17:47 2015 -0700 ---------------------------------------------------------------------- .../upgrade/mssql/006-HIVE-9456.mssql.sql | 323 +++++++++++++++++++ 1 file changed, 323 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/d39c829f/metastore/scripts/upgrade/mssql/006-HIVE-9456.mssql.sql ---------------------------------------------------------------------- diff --git a/metastore/scripts/upgrade/mssql/006-HIVE-9456.mssql.sql b/metastore/scripts/upgrade/mssql/006-HIVE-9456.mssql.sql new file mode 100644 index 0000000..707843a --- /dev/null +++ b/metastore/scripts/upgrade/mssql/006-HIVE-9456.mssql.sql @@ -0,0 +1,323 @@ + +--ALTER TABLE MASTER_KEYS +ALTER TABLE MASTER_KEYS ALTER COLUMN MASTER_KEY nvarchar(767) NULL; +GO + +--ALTER TABLE IDXS +ALTER TABLE IDXS ALTER COLUMN INDEX_HANDLER_CLASS nvarchar(4000) NULL; +GO + +DROP INDEX IDXS.UNIQUEINDEX; +ALTER TABLE IDXS ALTER COLUMN INDEX_NAME nvarchar(128) NULL; +CREATE UNIQUE INDEX UNIQUEINDEX ON IDXS (INDEX_NAME,ORIG_TBL_ID); +GO + +--ALTER TABLE PART_COL_STATS +DROP INDEX PART_COL_STATS.PCS_STATS_IDX; +ALTER TABLE PART_COL_STATS ALTER COLUMN "COLUMN_NAME" nvarchar(128) NOT NULL; +ALTER TABLE PART_COL_STATS ALTER COLUMN COLUMN_TYPE nvarchar(128) NOT NULL; +ALTER TABLE PART_COL_STATS ALTER COLUMN DB_NAME nvarchar(128) NOT NULL; +ALTER TABLE PART_COL_STATS ALTER COLUMN BIG_DECIMAL_HIGH_VALUE nvarchar(255) NULL; +ALTER TABLE PART_COL_STATS ALTER COLUMN BIG_DECIMAL_LOW_VALUE nvarchar(255) NULL; +ALTER TABLE PART_COL_STATS ALTER COLUMN PARTITION_NAME nvarchar(767) NOT NULL; +ALTER TABLE PART_COL_STATS ALTER COLUMN "TABLE_NAME" nvarchar(128) NOT NULL; +CREATE INDEX PCS_STATS_IDX ON PART_COL_STATS (DB_NAME,TABLE_NAME,COLUMN_NAME,PARTITION_NAME); +GO + +--ALTER TABLE PART_PRIVS +DROP INDEX PART_PRIVS.PARTPRIVILEGEINDEX; +ALTER TABLE PART_PRIVS ALTER COLUMN GRANTOR nvarchar(128) NULL; +ALTER TABLE PART_PRIVS ALTER COLUMN GRANTOR_TYPE nvarchar(128) NULL; +ALTER TABLE PART_PRIVS ALTER COLUMN PRINCIPAL_NAME nvarchar(128) NULL; +ALTER TABLE PART_PRIVS ALTER COLUMN PRINCIPAL_TYPE nvarchar(128) NULL; +ALTER TABLE PART_PRIVS ALTER COLUMN PART_PRIV nvarchar(128) NULL; +CREATE INDEX PARTPRIVILEGEINDEX ON PART_PRIVS (PART_ID,PRINCIPAL_NAME,PRINCIPAL_TYPE,PART_PRIV,GRANTOR,GRANTOR_TYPE); +GO + + +--ALTER TABLE ROLES +DROP INDEX ROLES.ROLEENTITYINDEX; +ALTER TABLE ROLES ALTER COLUMN OWNER_NAME nvarchar(128) NULL; +ALTER TABLE ROLES ALTER COLUMN ROLE_NAME nvarchar(128) NULL; +CREATE UNIQUE INDEX ROLEENTITYINDEX ON ROLES (ROLE_NAME); +GO + +--ALTER TABLE VERSION +ALTER TABLE VERSION ALTER COLUMN SCHEMA_VERSION nvarchar(127) NOT NULL; +ALTER TABLE VERSION ALTER COLUMN VERSION_COMMENT nvarchar(255) NOT NULL; +GO + +--ALTER TABLE GLOBAL_PRIVS +DROP INDEX GLOBAL_PRIVS.GLOBALPRIVILEGEINDEX; +ALTER TABLE GLOBAL_PRIVS ALTER COLUMN GRANTOR nvarchar(128) NULL; +ALTER TABLE GLOBAL_PRIVS ALTER COLUMN GRANTOR_TYPE nvarchar(128) NULL; +ALTER TABLE GLOBAL_PRIVS ALTER COLUMN PRINCIPAL_NAME nvarchar(128) NULL; +ALTER TABLE GLOBAL_PRIVS ALTER COLUMN PRINCIPAL_TYPE nvarchar(128) NULL; +ALTER TABLE GLOBAL_PRIVS ALTER COLUMN USER_PRIV nvarchar(128) NULL; +CREATE UNIQUE INDEX GLOBALPRIVILEGEINDEX ON GLOBAL_PRIVS (PRINCIPAL_NAME,PRINCIPAL_TYPE,USER_PRIV,GRANTOR,GRANTOR_TYPE); +GO + + +--ALTER TABLE PART_COL_PRIVS +DROP INDEX PART_COL_PRIVS.PARTITIONCOLUMNPRIVILEGEINDEX; +ALTER TABLE PART_COL_PRIVS ALTER COLUMN "COLUMN_NAME" nvarchar(128) NULL; +ALTER TABLE PART_COL_PRIVS ALTER COLUMN GRANTOR nvarchar(128) NULL; +ALTER TABLE PART_COL_PRIVS ALTER COLUMN GRANTOR_TYPE nvarchar(128) NULL; +ALTER TABLE PART_COL_PRIVS ALTER COLUMN PRINCIPAL_NAME nvarchar(128) NULL; +ALTER TABLE PART_COL_PRIVS ALTER COLUMN PRINCIPAL_TYPE nvarchar(128) NULL; +ALTER TABLE PART_COL_PRIVS ALTER COLUMN PART_COL_PRIV nvarchar(128) NULL; +CREATE INDEX PARTITIONCOLUMNPRIVILEGEINDEX ON PART_COL_PRIVS (PART_ID,"COLUMN_NAME",PRINCIPAL_NAME,PRINCIPAL_TYPE,PART_COL_PRIV,GRANTOR,GRANTOR_TYPE); +GO + +--ALTER TABLE DB_PRIVS +DROP INDEX DB_PRIVS.DBPRIVILEGEINDEX; +ALTER TABLE DB_PRIVS ALTER COLUMN GRANTOR nvarchar(128) NULL; +ALTER TABLE DB_PRIVS ALTER COLUMN GRANTOR_TYPE nvarchar(128) NULL; +ALTER TABLE DB_PRIVS ALTER COLUMN PRINCIPAL_NAME nvarchar(128) NULL; +ALTER TABLE DB_PRIVS ALTER COLUMN PRINCIPAL_TYPE nvarchar(128) NULL; +ALTER TABLE DB_PRIVS ALTER COLUMN DB_PRIV nvarchar(128) NULL; +CREATE UNIQUE INDEX DBPRIVILEGEINDEX ON DB_PRIVS (DB_ID,PRINCIPAL_NAME,PRINCIPAL_TYPE,DB_PRIV,GRANTOR,GRANTOR_TYPE); +GO + + +--ALTER TABLE TAB_COL_STATS +ALTER TABLE TAB_COL_STATS ALTER COLUMN "COLUMN_NAME" nvarchar(128) NOT NULL; +ALTER TABLE TAB_COL_STATS ALTER COLUMN COLUMN_TYPE nvarchar(128) NOT NULL; +ALTER TABLE TAB_COL_STATS ALTER COLUMN DB_NAME nvarchar(128) NOT NULL; +ALTER TABLE TAB_COL_STATS ALTER COLUMN BIG_DECIMAL_HIGH_VALUE nvarchar(255) NULL; +ALTER TABLE TAB_COL_STATS ALTER COLUMN BIG_DECIMAL_LOW_VALUE nvarchar(255) NULL; +ALTER TABLE TAB_COL_STATS ALTER COLUMN "TABLE_NAME" nvarchar(128) NOT NULL; +GO + + +--ALTER TABLE TYPES +DROP INDEX TYPES.UNIQUETYPE; +ALTER TABLE TYPES ALTER COLUMN TYPE_NAME nvarchar(128) NULL; +ALTER TABLE TYPES ALTER COLUMN TYPE1 nvarchar(767) NULL; +ALTER TABLE TYPES ALTER COLUMN TYPE2 nvarchar(767) NULL; +CREATE UNIQUE INDEX UNIQUETYPE ON TYPES (TYPE_NAME); +GO + + +--ALTER TABLE TBL_PRIVS +DROP INDEX TBL_PRIVS.TABLEPRIVILEGEINDEX; +ALTER TABLE TBL_PRIVS ALTER COLUMN GRANTOR nvarchar(128) NULL; +ALTER TABLE TBL_PRIVS ALTER COLUMN GRANTOR_TYPE nvarchar(128) NULL; +ALTER TABLE TBL_PRIVS ALTER COLUMN PRINCIPAL_NAME nvarchar(128) NULL; +ALTER TABLE TBL_PRIVS ALTER COLUMN PRINCIPAL_TYPE nvarchar(128) NULL; +ALTER TABLE TBL_PRIVS ALTER COLUMN TBL_PRIV nvarchar(128) NULL; +CREATE INDEX TABLEPRIVILEGEINDEX ON TBL_PRIVS (TBL_ID,PRINCIPAL_NAME,PRINCIPAL_TYPE,TBL_PRIV,GRANTOR,GRANTOR_TYPE); +GO + + +--ALTER TABLE DBS +DROP INDEX DBS.UNIQUEDATABASE; +ALTER TABLE DBS ALTER COLUMN "DESC" nvarchar(4000) NULL; +ALTER TABLE DBS ALTER COLUMN DB_LOCATION_URI nvarchar(4000) NOT NULL; +ALTER TABLE DBS ALTER COLUMN "NAME" nvarchar(128) NULL; +ALTER TABLE DBS ALTER COLUMN OWNER_NAME nvarchar(128) NULL; +ALTER TABLE DBS ALTER COLUMN OWNER_TYPE nvarchar(10) NULL; +CREATE UNIQUE INDEX UNIQUEDATABASE ON DBS ("NAME"); +GO + + +--ALTER TABLE TBL_COL_PRIVS +DROP INDEX TBL_COL_PRIVS.TABLECOLUMNPRIVILEGEINDEX; +ALTER TABLE TBL_COL_PRIVS ALTER COLUMN "COLUMN_NAME" nvarchar(128) NULL; +ALTER TABLE TBL_COL_PRIVS ALTER COLUMN GRANTOR nvarchar(128) NULL; +ALTER TABLE TBL_COL_PRIVS ALTER COLUMN GRANTOR_TYPE nvarchar(128) NULL; +ALTER TABLE TBL_COL_PRIVS ALTER COLUMN PRINCIPAL_NAME nvarchar(128) NULL; +ALTER TABLE TBL_COL_PRIVS ALTER COLUMN PRINCIPAL_TYPE nvarchar(128) NULL; +ALTER TABLE TBL_COL_PRIVS ALTER COLUMN TBL_COL_PRIV nvarchar(128) NULL; +CREATE INDEX TABLECOLUMNPRIVILEGEINDEX ON TBL_COL_PRIVS (TBL_ID,"COLUMN_NAME",PRINCIPAL_NAME,PRINCIPAL_TYPE,TBL_COL_PRIV,GRANTOR,GRANTOR_TYPE); +GO + +--ALTER TABLE DELEGATION_TOKENS +ALTER TABLE DELEGATION_TOKENS DROP CONSTRAINT DELEGATION_TOKENS_PK; +ALTER TABLE DELEGATION_TOKENS ALTER COLUMN TOKEN_IDENT nvarchar(767) NOT NULL; +ALTER TABLE DELEGATION_TOKENS ALTER COLUMN TOKEN nvarchar(767) NULL; +ALTER TABLE DELEGATION_TOKENS ADD CONSTRAINT DELEGATION_TOKENS_PK PRIMARY KEY (TOKEN_IDENT); +GO + +--ALTER TABLE SERDES +ALTER TABLE SERDES ALTER COLUMN "NAME" nvarchar(128) NULL; +ALTER TABLE SERDES ALTER COLUMN SLIB nvarchar(4000) NULL; +GO + + +--ALTER TABLE FUNCS +DROP INDEX FUNCS.UNIQUEFUNCTION; +ALTER TABLE FUNCS ALTER COLUMN CLASS_NAME nvarchar(4000) NULL; +ALTER TABLE FUNCS ALTER COLUMN FUNC_NAME nvarchar(128) NULL; +ALTER TABLE FUNCS ALTER COLUMN OWNER_NAME nvarchar(128) NULL; +ALTER TABLE FUNCS ALTER COLUMN OWNER_TYPE nvarchar(10) NULL; +CREATE UNIQUE INDEX UNIQUEFUNCTION ON FUNCS (FUNC_NAME,DB_ID); +GO + + +--ALTER TABLE ROLE_MAP +DROP INDEX ROLE_MAP.USERROLEMAPINDEX; +ALTER TABLE ROLE_MAP ALTER COLUMN GRANTOR nvarchar(128) NULL; +ALTER TABLE ROLE_MAP ALTER COLUMN GRANTOR_TYPE nvarchar(128) NULL; +ALTER TABLE ROLE_MAP ALTER COLUMN PRINCIPAL_NAME nvarchar(128) NULL; +ALTER TABLE ROLE_MAP ALTER COLUMN PRINCIPAL_TYPE nvarchar(128) NULL; +CREATE UNIQUE INDEX USERROLEMAPINDEX ON ROLE_MAP (PRINCIPAL_NAME,ROLE_ID,GRANTOR,GRANTOR_TYPE); +GO + + +--ALTER TABLE TBLS +DROP INDEX TBLS.UNIQUETABLE; +ALTER TABLE TBLS ALTER COLUMN OWNER nvarchar(767) NULL; +ALTER TABLE TBLS ALTER COLUMN TBL_NAME nvarchar(128) NULL; +ALTER TABLE TBLS ALTER COLUMN TBL_TYPE nvarchar(128) NULL; +CREATE UNIQUE INDEX UNIQUETABLE ON TBLS (TBL_NAME,DB_ID); +GO + +--ALTER TABLE SDS +ALTER TABLE SDS ALTER COLUMN INPUT_FORMAT nvarchar(4000) NULL; +ALTER TABLE SDS ALTER COLUMN OUTPUT_FORMAT nvarchar(4000) NULL; +GO + +--ALTER TABLE PARTITION_EVENTS +DROP INDEX PARTITION_EVENTS.PARTITIONEVENTINDEX; +ALTER TABLE PARTITION_EVENTS ALTER COLUMN DB_NAME nvarchar(128) NULL; +ALTER TABLE PARTITION_EVENTS ALTER COLUMN PARTITION_NAME nvarchar(767) NULL; +ALTER TABLE PARTITION_EVENTS ALTER COLUMN TBL_NAME nvarchar(128) NULL; +CREATE INDEX PARTITIONEVENTINDEX ON PARTITION_EVENTS (PARTITION_NAME); +GO + +--ALTER TABLE SORT_COLS +ALTER TABLE SORT_COLS ALTER COLUMN "COLUMN_NAME" nvarchar(128) NULL; +GO + +--ALTER TABLE SKEWED_COL_NAMES +ALTER TABLE SKEWED_COL_NAMES ALTER COLUMN SKEWED_COL_NAME nvarchar(255) NULL; +GO + + +--ALTER TABLE SKEWED_COL_VALUE_LOC_MAP +ALTER TABLE SKEWED_COL_VALUE_LOC_MAP ALTER COLUMN LOCATION nvarchar(4000) NULL; +GO + +--ALTER TABLE SKEWED_STRING_LIST_VALUES +ALTER TABLE SKEWED_STRING_LIST_VALUES ALTER COLUMN STRING_LIST_VALUE nvarchar(255) NULL; +GO + +--ALTER TABLE PARTITION_KEYS +ALTER TABLE PARTITION_KEYS DROP CONSTRAINT PARTITION_KEY_PK; +ALTER TABLE PARTITION_KEYS ALTER COLUMN PKEY_COMMENT nvarchar(4000) NULL; +ALTER TABLE PARTITION_KEYS ALTER COLUMN PKEY_NAME nvarchar(128) NOT NULL; +ALTER TABLE PARTITION_KEYS ALTER COLUMN PKEY_TYPE nvarchar(767) NOT NULL; +ALTER TABLE PARTITION_KEYS ADD CONSTRAINT PARTITION_KEY_PK PRIMARY KEY (TBL_ID,PKEY_NAME); +GO + +--ALTER TABLE SD_PARAMS +ALTER TABLE SD_PARAMS DROP CONSTRAINT SD_PARAMS_PK; +ALTER TABLE SD_PARAMS ALTER COLUMN PARAM_KEY nvarchar(256) NOT NULL; +ALTER TABLE SD_PARAMS ALTER COLUMN PARAM_VALUE nvarchar(4000) NULL; +ALTER TABLE SD_PARAMS ADD CONSTRAINT SD_PARAMS_PK PRIMARY KEY (SD_ID,PARAM_KEY); +GO + + +--ALTER TABLE FUNC_RU +ALTER TABLE FUNC_RU ALTER COLUMN RESOURCE_URI nvarchar(4000) NULL; +GO + + +--ALTER TABLE TYPE_FIELDS +ALTER TABLE TYPE_FIELDS DROP CONSTRAINT TYPE_FIELDS_PK; +ALTER TABLE TYPE_FIELDS ALTER COLUMN COMMENT nvarchar(256) NULL; +ALTER TABLE TYPE_FIELDS ALTER COLUMN FIELD_NAME nvarchar(128) NOT NULL; +ALTER TABLE TYPE_FIELDS ALTER COLUMN FIELD_TYPE nvarchar(767) NOT NULL; +ALTER TABLE TYPE_FIELDS ADD CONSTRAINT TYPE_FIELDS_PK PRIMARY KEY (TYPE_NAME,FIELD_NAME); +GO + +--ALTER TABLE BUCKETING_COLS +ALTER TABLE BUCKETING_COLS ALTER COLUMN BUCKET_COL_NAME nvarchar(255) NULL; +GO + +--ALTER TABLE DATABASE_PARAMS +ALTER TABLE DATABASE_PARAMS DROP CONSTRAINT DATABASE_PARAMS_PK; +ALTER TABLE DATABASE_PARAMS ALTER COLUMN PARAM_KEY nvarchar(180) NOT NULL; +ALTER TABLE DATABASE_PARAMS ALTER COLUMN PARAM_VALUE nvarchar(4000) NULL; +ALTER TABLE DATABASE_PARAMS ADD CONSTRAINT DATABASE_PARAMS_PK PRIMARY KEY (DB_ID,PARAM_KEY); +GO + + +--ALTER TABLE INDEX_PARAMS +ALTER TABLE INDEX_PARAMS DROP CONSTRAINT INDEX_PARAMS_PK; +ALTER TABLE INDEX_PARAMS ALTER COLUMN PARAM_KEY nvarchar(256) NOT NULL; +ALTER TABLE INDEX_PARAMS ALTER COLUMN PARAM_VALUE nvarchar(4000) NULL; +ALTER TABLE INDEX_PARAMS ADD CONSTRAINT INDEX_PARAMS_PK PRIMARY KEY (INDEX_ID,PARAM_KEY); +GO + +--ALTER TABLE COLUMNS_V2 +ALTER TABLE COLUMNS_V2 DROP CONSTRAINT COLUMNS_PK; +ALTER TABLE COLUMNS_V2 ALTER COLUMN COMMENT nvarchar(256) NULL; +ALTER TABLE COLUMNS_V2 ALTER COLUMN "COLUMN_NAME" nvarchar(128) NOT NULL; +ALTER TABLE COLUMNS_V2 ALTER COLUMN TYPE_NAME nvarchar(4000) NOT NULL; +ALTER TABLE COLUMNS_V2 ADD CONSTRAINT COLUMNS_PK PRIMARY KEY (CD_ID,"COLUMN_NAME"); +GO + +--ALTER TABLE SERDE_PARAMS +ALTER TABLE SERDE_PARAMS DROP CONSTRAINT SERDE_PARAMS_PK; +ALTER TABLE SERDE_PARAMS ALTER COLUMN PARAM_KEY nvarchar(256) NOT NULL; +ALTER TABLE SERDE_PARAMS ALTER COLUMN PARAM_VALUE nvarchar(4000) NULL; +ALTER TABLE SERDE_PARAMS ADD CONSTRAINT SERDE_PARAMS_PK PRIMARY KEY (SERDE_ID,PARAM_KEY); +GO + +--ALTER TABLE PARTITION_PARAMS +ALTER TABLE PARTITION_PARAMS DROP CONSTRAINT PARTITION_PARAMS_PK; +ALTER TABLE PARTITION_PARAMS ALTER COLUMN PARAM_KEY nvarchar(256) NOT NULL; +ALTER TABLE PARTITION_PARAMS ALTER COLUMN PARAM_VALUE nvarchar(4000) NULL; +ALTER TABLE PARTITION_PARAMS ADD CONSTRAINT PARTITION_PARAMS_PK PRIMARY KEY (PART_ID,PARAM_KEY); +GO + +--ALTER TABLE TABLE_PARAMS +ALTER TABLE TABLE_PARAMS DROP CONSTRAINT TABLE_PARAMS_PK; +ALTER TABLE TABLE_PARAMS ALTER COLUMN PARAM_KEY nvarchar(256) NOT NULL; +ALTER TABLE TABLE_PARAMS ALTER COLUMN PARAM_VALUE nvarchar(4000) NULL; +ALTER TABLE TABLE_PARAMS ADD CONSTRAINT TABLE_PARAMS_PK PRIMARY KEY (TBL_ID,PARAM_KEY); +GO + +--ALTER TABLE NOTIFICATION_LOG +ALTER TABLE NOTIFICATION_LOG DROP CONSTRAINT NOTIFICATION_LOG_PK; +ALTER TABLE NOTIFICATION_LOG ALTER COLUMN EVENT_TYPE nvarchar(32) NOT NULL; +ALTER TABLE NOTIFICATION_LOG ALTER COLUMN DB_NAME nvarchar(128) NOT NULL; +ALTER TABLE NOTIFICATION_LOG ALTER COLUMN TBL_NAME nvarchar(128) NOT NULL; +ALTER TABLE NOTIFICATION_LOG ADD CONSTRAINT NOTIFICATION_LOG_PK PRIMARY KEY (NL_ID); +GO + +--ALTER TABLE COMPACTION_QUEUE +ALTER TABLE COMPACTION_QUEUE ALTER COLUMN CQ_DATABASE nvarchar(128) NOT NULL; +ALTER TABLE COMPACTION_QUEUE ALTER COLUMN CQ_TABLE nvarchar(128) NOT NULL; +ALTER TABLE COMPACTION_QUEUE ALTER COLUMN CQ_PARTITION nvarchar(767) NULL; +ALTER TABLE COMPACTION_QUEUE ALTER COLUMN CQ_WORKER_ID nvarchar(128) NULL; +ALTER TABLE COMPACTION_QUEUE ALTER COLUMN CQ_RUN_AS nvarchar(128) NULL; +GO + +--ALTER TABLE COMPLETED_TXN_COMPONENTS +ALTER TABLE COMPLETED_TXN_COMPONENTS ALTER COLUMN CTC_DATABASE nvarchar(128) NOT NULL; +ALTER TABLE COMPLETED_TXN_COMPONENTS ALTER COLUMN CTC_TABLE nvarchar(128) NULL; +ALTER TABLE COMPLETED_TXN_COMPONENTS ALTER COLUMN CTC_PARTITION nvarchar(767) NULL; +GO + +--ALTER TABLE HIVE_LOCKS +ALTER TABLE HIVE_LOCKS ALTER COLUMN HL_DB nvarchar(128) NOT NULL; +ALTER TABLE HIVE_LOCKS ALTER COLUMN HL_TABLE nvarchar(128) NULL; +ALTER TABLE HIVE_LOCKS ALTER COLUMN HL_PARTITION nvarchar(767) NULL; +ALTER TABLE HIVE_LOCKS ALTER COLUMN HL_USER nvarchar(128) NOT NULL; +ALTER TABLE HIVE_LOCKS ALTER COLUMN HL_HOST nvarchar(128) NOT NULL; +GO + + +--ALTER TABLE TXNS +ALTER TABLE TXNS ALTER COLUMN TXN_USER nvarchar(128) NOT NULL; +ALTER TABLE TXNS ALTER COLUMN TXN_HOST nvarchar(128) NOT NULL; +GO + +--ALTER TABLE TXN_COMPONENTS +ALTER TABLE TXN_COMPONENTS ALTER COLUMN TC_DATABASE nvarchar(128) NOT NULL; +ALTER TABLE TXN_COMPONENTS ALTER COLUMN TC_TABLE nvarchar(128) NULL; +ALTER TABLE TXN_COMPONENTS ALTER COLUMN TC_PARTITION nvarchar(767) NULL; +GO