hive的Specified key was too long; max key length is 767 bytes问题解决
来源：互联网 发布：python数据库怎么安装 编辑：程序博客网 时间：2024/05/17 01:58
hive的Specified key was too long; max key length is 767 bytes问题解决
http://sunjia-704471770-qq-com.iteye.com/blog/1631430
当在hive中show table 时如果报以下错时
FAILED: Error in metadata: javax.jdo.JDODataStoreException: Error(s) were found while auto-creating/validating the datastore for classes. The errors are printed in the log, and are attached to this exception.
NestedThrowables:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
（略去 很多java 提示）
是到mysql中的hive数据库里执行 alter database hive character set latin1;改变hive元数据库的字符集，问题就可以解决！
0 0
- hive的Specified key was too long; max key length is 767 bytes问题解决
- hive的Specified key was too long; max key length is 767 bytes问题解决
- hive的Specified key was too long; max key length is 767 bytes问题解决
- hive的Specified key was too long; max key length is 767 bytes问题解决
- hive的Specified key was too long; max key length is 767 bytes问题解决
- hive的Specified key was too long; max key length is 767 bytes问题解决
- hive的Specified key was too long; max key length is 767 bytes问题解决
- hive中Specified key was too long; max key length is 767 bytes问题解决
- Hive 创建表提示"Specified key was too long; max key length is 767 bytes"解决办法
- 配置hive后，Specified key was too long; max key length is 767 bytes
- Hive 创建表报"Specified key was too long; max key length is 767 bytes" 错误
- hive 1.1.1 Specified key was too long; max key length is 767 bytes
- hive执行命令Specified key was too long; max key length is 767 bytes 问题
- Hive部署安装时，Specified key was too long; max key length is 767 bytes
- Hive创建表时报错，Specified key was too long; max key length is 767 bytes
- Hive建表报错 Specified key was too long; max key length is 767 bytes
- 使用hive的cli创建table报Specified key was too long; max key length is 767 bytes
- 关于Django出现Specified key was too long; max key length is 767 bytes的解决办法
- PS域业务与CS域业务的区别
- iOS: JS和Native交互的两种方法
- 如何为linux释放内存和缓存
- oracle实例
- 在服务器端判断request来自Ajax请求(异步)还是传统请求(同步)
- hive的Specified key was too long; max key length is 767 bytes问题解决
- 白话经典算法系列之二 直接插入排序的三种实现
- Oracle表序列生成
- hibernate中get方法和load方法的根本区别
- Medoo轻量级的数据库框架
- 【机房重构】UML图
- 关于ASP.net - Joyrock：异步应用示例、JSON-RPC了解
- hdu 4578 Transformation（线段树中级，区间和加强）
- linux 配置邮件发送功能
