Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The "Hive/IndexDev" page has been changed by HeYongqiang. http://wiki.apache.org/hadoop/Hive/IndexDev?action=diff&rev1=4&rev2=5 -------------------------------------------------- * need LAST_REBUILD_TIME? how do we track it at partition-level? it should be in the metastore (not just HDFS) * in the case where the index partitioning is a subset of the base table partitioning, we need a way to model this in the metastore + == Metastore Upgrades == + + Here are the MySQL metastore upgrade statements. + + {{{ + DROP TABLE IF EXISTS `IDXS`; + CREATE TABLE `IDXS` ( + `INDEX_ID` bigint(20) NOT NULL, + `CREATE_TIME` int(11) NOT NULL, + `DEFERRED_REBUILD` bit(1) NOT NULL, + `INDEX_HANDLER_CLASS` varchar(256) DEFAULT NULL, + `INDEX_NAME` varchar(128) DEFAULT NULL, + `INDEX_TBL_ID` bigint(20) DEFAULT NULL, + `LAST_ACCESS_TIME` int(11) NOT NULL, + `ORIG_TBL_ID` bigint(20) DEFAULT NULL, + `SD_ID` bigint(20) DEFAULT NULL, + PRIMARY KEY (`INDEX_ID`), + UNIQUE KEY `UNIQUEINDEX` (`INDEX_NAME`,`ORIG_TBL_ID`), + KEY `IDXS_FK1` (`SD_ID`), + KEY `IDXS_FK2` (`INDEX_TBL_ID`), + KEY `IDXS_FK3` (`ORIG_TBL_ID`), + CONSTRAINT `IDXS_FK3` FOREIGN KEY (`ORIG_TBL_ID`) REFERENCES `TBLS` (`TBL_ID`), + CONSTRAINT `IDXS_FK1` FOREIGN KEY (`SD_ID`) REFERENCES `SDS` (`SD_ID`), + CONSTRAINT `IDXS_FK2` FOREIGN KEY (`INDEX_TBL_ID`) REFERENCES `TBLS` (`TBL_ID`) + ) ENGINE=InnoDB DEFAULT CHARSET=latin1; + + -- + -- Table structure for table `INDEX_PARAMS` + -- + + DROP TABLE IF EXISTS `INDEX_PARAMS`; + CREATE TABLE `INDEX_PARAMS` ( + `INDEX_ID` bigint(20) NOT NULL, + `PARAM_KEY` varchar(256) NOT NULL, + `PARAM_VALUE` varchar(767) DEFAULT NULL, + PRIMARY KEY (`INDEX_ID`,`PARAM_KEY`), + CONSTRAINT `INDEX_PARAMS_FK1` FOREIGN KEY (`INDEX_ID`) REFERENCES `IDXS` (`INDEX_ID`) + ) ENGINE=InnoDB DEFAULT CHARSET=latin1; + + }}} == REBUILD == {{{