[
https://issues.apache.org/jira/browse/HIVE-12385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sergey Shelukhin updated HIVE-12385:
------------------------------------
Fix Version/s: (was: 2.00)
> 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
> Attachments: HIVE-12385.patch
>
>
> 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)
