[HIVE-12385] schematool failed on MySQL

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 2.0.0

Environment

MySQL

• Target Version/s: 2.0.0
• Assignee: Sergey Shelukhin
• Reporter: Takahiko Saito
• Created: 11/Nov/15 22:04
• Updated: 16/Feb/16 23:51
• Resolved: 12/Nov/15 19:46

Description

Run schematool and got the following error:

CREATE TABLE IF NOT EXISTS `COLUMNS_V2` ( `CD_ID` bigint(20) NOT NULL, `COMMENT` varchar(256) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, `COLUMN_NAME` varchar(1000) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `TYPE_NAME` varchar(4000) DEFAULT NULL, `INTEGER_IDX` int(11) NOT NULL, PRIMARY KEY (`CD_ID`,`COLUMN_NAME`), KEY `COLUMNS_V2_N49` (`CD_ID`), CONSTRAINT `COLUMNS_V2_FK1` FOREIGN KEY (`CD_ID`) REFERENCES `CDS` (`CD_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1
Error: Specified key was too long; max key length is 767 bytes (state=42000,code=1071)