hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <j...@apache.org>
Subject [jira] [Reopened] (HIVE-12385) schematool failed on MySQL
Date Wed, 11 Nov 2015 22:40:11 GMT

     [ https://issues.apache.org/jira/browse/HIVE-12385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Sergey Shelukhin reopened HIVE-12385:
-------------------------------------

Script does need to be modified

> 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)

Mime
View raw message