com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes

hive-user | Arthur.hk.chan@gmail.com | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Re: CREATE FUNCTION: How to automatically load extra jar file?

    hive-user | 2 years ago | Arthur.hk.chan@gmail.com
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
  2. 0

    Re: CREATE FUNCTION: How to automatically load extra jar file?

    hive-user | 2 years ago | Arthur.hk.chan@gmail.com
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
  3. 0

    Re: CREATE FUNCTION: How to automatically load extra jar file?

    hive-user | 2 years ago | Arthur.hk.chan@gmail.com
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Re: CREATE FUNCTION: How to automatically load extra jar file?

    hive-user | 2 years ago | Arthur.hk.chan@gmail.com
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
  6. 0
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

    Specified key was too long; max key length is 767 bytes

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    4 frames
  3. MySQL jdbc
    StatementImpl.execute
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:408)
    2. com.mysql.jdbc.Util.getInstance(Util.java:383)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1062)
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4226)
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4158)
    6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2615)
    7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
    8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2834)
    9. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2783)
    10. com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:908)
    11. com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:788)
    11 frames
  4. BoneCP :: Core Library
    StatementHandle.execute
    1. com.jolbox.bonecp.StatementHandle.execute(StatementHandle.java:254)
    1 frame
  5. DataNucleus RDBMS plugin
    RDBMSStoreManager.addClasses
    1. org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:760)
    2. org.datanucleus.store.rdbms.table.TableImpl.createIndices(TableImpl.java:648)
    3. org.datanucleus.store.rdbms.table.TableImpl.validateIndices(TableImpl.java:593)
    4. org.datanucleus.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:390)
    5. org.datanucleus.store.rdbms.table.ClassTable.validateConstraints(ClassTable.java:3463)
    6. org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3464)
    7. org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:3190)
    8. org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2841)
    9. org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:122)
    10. org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:1605)
    10 frames
  6. DataNucleus Core
    AbstractStoreManager.addClass
    1. org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:954)
    1 frame
  7. DataNucleus RDBMS plugin
    JDOQLQuery.compileInternal
    1. org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(RDBMSStoreManager.java:679)
    2. org.datanucleus.store.rdbms.query.RDBMSQueryUtils.getStatementForCandidates(RDBMSQueryUtils.java:408)
    3. org.datanucleus.store.rdbms.query.JDOQLQuery.compileQueryFull(JDOQLQuery.java:947)
    4. org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:370)
    4 frames
  8. DataNucleus Core
    Query.execute
    1. org.datanucleus.store.query.Query.executeQuery(Query.java:1744)
    2. org.datanucleus.store.query.Query.executeWithArray(Query.java:1672)
    3. org.datanucleus.store.query.Query.execute(Query.java:1654)
    3 frames
  9. DataNucleus JDO API plugin
    JDOQuery.execute
    1. org.datanucleus.api.jdo.JDOQuery.execute(JDOQuery.java:221)
    1 frame
  10. Hive Metastore
    ObjectStore.setConf
    1. org.apache.hadoop.hive.metastore.MetaStoreDirectSql.<init>(MetaStoreDirectSql.java:121)
    2. org.apache.hadoop.hive.metastore.ObjectStore.initialize(ObjectStore.java:252)
    3. org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:223)
    3 frames
  11. Hadoop
    ReflectionUtils.newInstance
    1. org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:73)
    2. org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:133)
    2 frames
  12. Hive Metastore
    HiveMetaStoreClient.<init>
    1. org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:58)
    2. org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:67)
    3. org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStore(HiveMetaStore.java:497)
    4. org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:475)
    5. org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:523)
    6. org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:397)
    7. org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:356)
    8. org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:54)
    9. org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:59)
    10. org.apache.hadoop.hive.metastore.HiveMetaStore.newHMSHandler(HiveMetaStore.java:4944)
    11. org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:171)
    11 frames
  13. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    4. java.lang.reflect.Constructor.newInstance(Constructor.java:526)
    4 frames
  14. Hive Metastore
    RetryingMetaStoreClient.getProxy
    1. org.apache.hadoop.hive.metastore.MetaStoreUtils.newInstance(MetaStoreUtils.java:1410)
    2. org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.<init>(RetryingMetaStoreClient.java:62)
    3. org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.getProxy(RetryingMetaStoreClient.java:72)
    3 frames
  15. Hive Query Language
    SessionState.start
    1. org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2453)
    2. org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2465)
    3. org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:340)
    3 frames
  16. org.apache.hadoop
    CliDriver.main
    1. org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:681)
    2. org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:625)
    2 frames
  17. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    4. java.lang.reflect.Method.invoke(Method.java:606)
    4 frames
  18. Hadoop
    RunJar.main
    1. org.apache.hadoop.util.RunJar.main(RunJar.java:212)
    1 frame