2014. 7. 9. 13:56
Peter's Part 0/Hive
Cannot Create Hive Table Flamingo.UI.js:103
[105] Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:javax.jdo.JDODataStoreException: An exception was thrown while adding/validating class(es) : Specified key was too long; max key length is 767 bytes
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
mysql에서 Hive Table을 생성 시
위와 같은
Specified key was too long; max key length is 767 bytes
오류가 발생할 경우
mysql -uroot 로 접속 후
아래 명령을 입력하면 된다.
mysql> alter database hive character set latin1;