블로그 이미지
magicps
Connected dot

calendar

1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30

TiCumulus Tag Cloud

11-21 14:12
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;




posted by magicps