[S2GRAPH-90] Specified key was too long error.

• Type: Bug
• Status: To Do
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.1.0
• Assignee: Unassigned
• Reporter: Hyoungjun Kim
• Created: 04/Jul/16 07:51
• Updated: 04/Jul/16 07:51

Description

The following error message is shown when creating table.

# mysql -uroot < ./s2core/target/scala-2.11/classes/org/apache/s2graph/core/mysqls/schema.sql
ERROR 1071 (42000) at line 26: Specified key was too long; max key length is 767 bytes

There is restriction for index key length under the default mysql configuration.
I succeeded creating table after setting some variables. See the following article.

http://mechanics.flite.com/blog/2014/07/29/using-innodb-large-prefix-to-avoid-error-1071/