diff --git a/package/HDPAzure/hdp.winpkg/resources/HiveMetaStore.sql b/package/HDPAzure/hdp.winpkg/resources/HiveMetaStore.sql index aafb01e..20bc84c 100644 --- a/package/HDPAzure/hdp.winpkg/resources/HiveMetaStore.sql +++ b/package/HDPAzure/hdp.winpkg/resources/HiveMetaStore.sql @@ -1187,6 +1187,12 @@ ON [dbo].[PARTITION_KEY_VALS] ([PART_ID]) END + IF NOT EXISTS(SELECT * FROM sys.indexes WHERE name = 'PARTITION_INTEGER_INDEX' AND object_id = OBJECT_ID('PARTITION_KEY_VALS')) + BEGIN + CREATE NONCLUSTERED INDEX PARTITION_INTEGER_INDEX + ON [dbo].[PARTITION_KEY_VALS] ([INTEGER_IDX]) + INCLUDE ([PART_ID],[PART_KEY_VAL]) + END /****** Adding indexes for PARTITION_PARAMS ******/ IF NOT EXISTS(SELECT * FROM sys.indexes WHERE name = 'PARTITION_PARAMS_N49' AND object_id = OBJECT_ID('PARTITION_PARAMS'))