You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@s2graph.apache.org by "Hyoungjun Kim (JIRA)" <ji...@apache.org> on 2016/07/04 07:52:10 UTC

[jira] [Created] (S2GRAPH-90) Specified key was too long error.

Hyoungjun Kim created S2GRAPH-90:
------------------------------------

             Summary: Specified key was too long error.
                 Key: S2GRAPH-90
                 URL: https://issues.apache.org/jira/browse/S2GRAPH-90
             Project: S2Graph
          Issue Type: Bug
    Affects Versions: 0.1.0
            Reporter: Hyoungjun Kim


The following error message is shown when creating table.  
{noformat}
# 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
{noformat}

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/ 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)