hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Hadoop Wiki] Update of "Hive/IndexDev" by HeYongqiang
Date Sat, 31 Jul 2010 00:30:31 GMT
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 ==
  
  {{{

Mime
View raw message