Takahiko Saito created HIVE-12385:
-------------------------------------
Summary: schematool failed on MySQL
Key: HIVE-12385
URL: https://issues.apache.org/jira/browse/HIVE-12385
Project: Hive
Issue Type: Bug
Affects Versions: 2.00
Environment: MySQL
Reporter: Takahiko Saito
Assignee: Sergey Shelukhin
Fix For: 2.00
Run schematool and got the following error:
{noformat}
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)
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
