- hive mysql元数据，报错 Specified key w
- 执行建表sql提示Specified key was too l
- MySQL客户端报错1071 - Specified key w
- Specified key was too long; max
- Specified key was too long; max
- Specified key was too long; max
- MySQL[Specified key was too long
- 记录一次Specified key was too long的问
- Funboot安装常见问题
- 报错分析之Specified Key was too long:
原理暂时也没去研究，等自己学通透了再来补充，这里只说解决方案。
set global innodb_file_format = BARRACUDA;
set global innodb_large_prefix = ON;
网上一搜，就这么两句干巴巴的设置的答案很多，害人不浅。还是同样的报错。
实际上还要把建表语句改成
ROW_FORMAT = COMPRESSED
或者
ROW_FORMAT = DYNAMIC。
想追根究底的可以先看看https://blog.51cto.com/13120271/2315189
网友评论