/tags/release-0.1-rc2/hive/external/metastore/scripts/upgrade/mysql/006-HIVE-1823.mysql.sql

# · SQL · 8 lines · 8 code · 0 blank · 0 comment · 0 complexity · 2255edffff7b9111ef34471d76ce1a8e MD5 · raw file 

    

  1. SELECT '< HIVE-1823 Upgrade the database thrift interface to allow parameters key-value pairs >' AS ' ';
    2. 

  2. CREATE TABLE IF NOT EXISTS `DATABASE_PARAMS` (
    3. 

  3.   `DB_ID` bigint(20) NOT NULL,
    4. 

  4.   `PARAM_KEY` varchar(180) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
    5. 

  5.   `PARAM_VALUE` varchar(4000) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
    6. 

  6.   PRIMARY KEY (`DB_ID`,`PARAM_KEY`),
    7. 

  7.   CONSTRAINT `DATABASE_PARAMS_FK1` FOREIGN KEY (`DB_ID`) REFERENCES `DBS` (`DB_ID`)
    8. 

  8. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    9.