在hive执行创建表的命令，遇到异常com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
今天在练习hive的操作时，在创建数据表时，遇到了异常
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
HDFS与hive版本：hadoop-2.5.0-cdh5.3.6.tar.gz，hive-0.13.1-cdh5.3.6.tar.gz
hive-site.xml文件配置内容：
1 <?xml version="1.0" encoding="UTF-8" standalone="no"?> 2 <?xml-stylesheet type="text/xsl" href="configuration.xsl"?> 3 <configuration> 4 <property> 5 <name>javax.jdo.option.ConnectionURL</name> 6 <value>jdbc:mysql://127.0.0.1:3306/hive?createDatabaseIfNotExist=true</value> 7 </property> 8 <property> 9 <name>javax.jdo.option.ConnectionDriverName</name> 10 <value>com.mysql.jdbc.Driver</value> 11 </property> 12 <property> 13 <name>javax.jdo.option.ConnectionUserName</name> 14 <value>root</value> 15 </property> 16 <property> 17 <name>javax.jdo.option.ConnectionPassword</name> 18 <value>123456</value> 19 </property> 20 21 <property> 22 <name>hive.cli.print.header</name> 23 <value>true</value> 24 </property> 25 <property> 26 <name>hive.cli.print.current.db</name> 27 <value>true</value> 28 </property> 29 </configuration>
执行的HQL语句：
1 create table emp( 2 empno string, 3 ename string, 4 job string, 5 mgr string, 6 hiredate string, 7 sal double, 8 comm double, 9 deptno string 10 )row format delimited fields terminated by '\t' ;
异常内容：
1 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 2 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes 3 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 4 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 5 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 6 at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 7 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) 8 at com.mysql.jdbc.Util.getInstance(Util.java:381) 9 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) 10 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 11 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) 12 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) 13 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) 14 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) 15 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536) 16 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465) 17 at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734) 18 at com.jolbox.bonecp.StatementHandle.execute(StatementHandle.java:254) 19 at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:760) 20 at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:711) 21 at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:425) 22 at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:488) 23 at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3380) 24 at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:3190) 25 at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2841) 26 at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:122) 27 at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:1605) 28 at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:954) 29 at org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(RDBMSStoreManager.java:679) 30 at org.datanucleus.store.rdbms.RDBMSStoreManager.getPropertiesForGenerator(RDBMSStoreManager.java:2045) 31 at org.datanucleus.store.AbstractStoreManager.getStrategyValue(AbstractStoreManager.java:1365) 32 at org.datanucleus.ExecutionContextImpl.newObjectId(ExecutionContextImpl.java:3827) 33 at org.datanucleus.state.JDOStateManager.setIdentity(JDOStateManager.java:2571) 34 at org.datanucleus.state.JDOStateManager.initialiseForPersistentNew(JDOStateManager.java:513) 35 at org.datanucleus.state.ObjectProviderFactoryImpl.newForPersistentNew(ObjectProviderFactoryImpl.java:232) 36 at org.datanucleus.ExecutionContextImpl.newObjectProviderForPersistentNew(ExecutionContextImpl.java:1414) 37 at org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2218) 38 at org.datanucleus.ExecutionContextImpl.persistObjectWork(ExecutionContextImpl.java:2065) 39 at org.datanucleus.ExecutionContextImpl.persistObject(ExecutionContextImpl.java:1913) 40 at org.datanucleus.ExecutionContextThreadedImpl.persistObject(ExecutionContextThreadedImpl.java:217) 41 at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:727) 42 at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:752) 43 at org.apache.hadoop.hive.metastore.ObjectStore.createTable(ObjectStore.java:749) 44 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 45 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 46 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 47 at java.lang.reflect.Method.invoke(Method.java:498) 48 at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:108) 49 at com.sun.proxy.$Proxy6.createTable(Unknown Source) 50 at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_core(HiveMetaStore.java:1272) 51 at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_with_environment_context(HiveMetaStore.java:1305) 52 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 53 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 54 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 55 at java.lang.reflect.Method.invoke(Method.java:498) 56 at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:106) 57 at com.sun.proxy.$Proxy15.create_table_with_environment_context(Unknown Source) 58 at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:575) 59 at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:564) 60 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 61 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 62 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 63 at java.lang.reflect.Method.invoke(Method.java:498) 64 at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:90) 65 at com.sun.proxy.$Proxy16.createTable(Unknown Source) 66 at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:640) 67 at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:4224) 68 at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:286) 69 at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:155) 70 at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:85) 71 at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1554) 72 at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1321) 73 at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1139) 74 at org.apache.hadoop.hive.ql.Driver.run(Driver.java:962) 75 at org.apache.hadoop.hive.ql.Driver.run(Driver.java:952) 76 at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:269) 77 at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:221) 78 at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:431) 79 at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:800) 80 at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:694) 81 at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:633) 82 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 83 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 84 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 85 at java.lang.reflect.Method.invoke(Method.java:498) 86 at org.apache.hadoop.util.RunJar.main(RunJar.java:212) 87 88 at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:451) 89 at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:732) 90 at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:752) 91 at org.apache.hadoop.hive.metastore.ObjectStore.createTable(ObjectStore.java:749) 92 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 93 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 94 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 95 at java.lang.reflect.Method.invoke(Method.java:498) 96 at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:108) 97 at com.sun.proxy.$Proxy6.createTable(Unknown Source) 98 at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_core(HiveMetaStore.java:1272) 99 at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_with_environment_context(HiveMetaStore.java:1305) 100 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 101 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 102 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 103 at java.lang.reflect.Method.invoke(Method.java:498) 104 at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:106) 105 at com.sun.proxy.$Proxy15.create_table_with_environment_context(Unknown Source) 106 at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:575) 107 at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:564) 108 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 109 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 110 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 111 at java.lang.reflect.Method.invoke(Method.java:498) 112 at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:90) 113 at com.sun.proxy.$Proxy16.createTable(Unknown Source) 114 at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:640) 115 at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:4224) 116 at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:286) 117 at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:155) 118 at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:85) 119 at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1554) 120 at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1321) 121 at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1139) 122 at org.apache.hadoop.hive.ql.Driver.run(Driver.java:962) 123 at org.apache.hadoop.hive.ql.Driver.run(Driver.java:952) 124 at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:269) 125 at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:221) 126 at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:431) 127 at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:800) 128 at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:694) 129 at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:633) 130 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 131 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 132 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 133 at java.lang.reflect.Method.invoke(Method.java:498) 134 at org.apache.hadoop.util.RunJar.main(RunJar.java:212) 135 NestedThrowablesStackTrace: 136 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes 137 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 138 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) 139 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) 140 at java.lang.reflect.Constructor.newInstance(Constructor.java:423) 141 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) 142 at com.mysql.jdbc.Util.getInstance(Util.java:381) 143 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) 144 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) 145 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) 146 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) 147 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) 148 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) 149 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536) 150 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465) 151 at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:734) 152 at com.jolbox.bonecp.StatementHandle.execute(StatementHandle.java:254) 153 at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatement(AbstractTable.java:760) 154 at org.datanucleus.store.rdbms.table.AbstractTable.executeDdlStatementList(AbstractTable.java:711) 155 at org.datanucleus.store.rdbms.table.AbstractTable.create(AbstractTable.java:425) 156 at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:488) 157 at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.performTablesValidation(RDBMSStoreManager.java:3380) 158 at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.addClassTablesAndValidate(RDBMSStoreManager.java:3190) 159 at org.datanucleus.store.rdbms.RDBMSStoreManager$ClassAdder.run(RDBMSStoreManager.java:2841) 160 at org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:122) 161 at org.datanucleus.store.rdbms.RDBMSStoreManager.addClasses(RDBMSStoreManager.java:1605) 162 at org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:954) 163 at org.datanucleus.store.rdbms.RDBMSStoreManager.getDatastoreClass(RDBMSStoreManager.java:679) 164 at org.datanucleus.store.rdbms.RDBMSStoreManager.getPropertiesForGenerator(RDBMSStoreManager.java:2045) 165 at org.datanucleus.store.AbstractStoreManager.getStrategyValue(AbstractStoreManager.java:1365) 166 at org.datanucleus.ExecutionContextImpl.newObjectId(ExecutionContextImpl.java:3827) 167 at org.datanucleus.state.JDOStateManager.setIdentity(JDOStateManager.java:2571) 168 at org.datanucleus.state.JDOStateManager.initialiseForPersistentNew(JDOStateManager.java:513) 169 at org.datanucleus.state.ObjectProviderFactoryImpl.newForPersistentNew(ObjectProviderFactoryImpl.java:232) 170 at org.datanucleus.ExecutionContextImpl.newObjectProviderForPersistentNew(ExecutionContextImpl.java:1414) 171 at org.datanucleus.ExecutionContextImpl.persistObjectInternal(ExecutionContextImpl.java:2218) 172 at org.datanucleus.ExecutionContextImpl.persistObjectWork(ExecutionContextImpl.java:2065) 173 at org.datanucleus.ExecutionContextImpl.persistObject(ExecutionContextImpl.java:1913) 174 at org.datanucleus.ExecutionContextThreadedImpl.persistObject(ExecutionContextThreadedImpl.java:217) 175 at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:727) 176 at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:752) 177 at org.apache.hadoop.hive.metastore.ObjectStore.createTable(ObjectStore.java:749) 178 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 179 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 180 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 181 at java.lang.reflect.Method.invoke(Method.java:498) 182 at org.apache.hadoop.hive.metastore.RawStoreProxy.invoke(RawStoreProxy.java:108) 183 at com.sun.proxy.$Proxy6.createTable(Unknown Source) 184 at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_core(HiveMetaStore.java:1272) 185 at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.create_table_with_environment_context(HiveMetaStore.java:1305) 186 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 187 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 188 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 189 at java.lang.reflect.Method.invoke(Method.java:498) 190 at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:106) 191 at com.sun.proxy.$Proxy15.create_table_with_environment_context(Unknown Source) 192 at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:575) 193 at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.createTable(HiveMetaStoreClient.java:564) 194 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 195 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 196 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 197 at java.lang.reflect.Method.invoke(Method.java:498) 198 at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:90) 199 at com.sun.proxy.$Proxy16.createTable(Unknown Source) 200 at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:640) 201 at org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:4224) 202 at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:286) 203 at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:155) 204 at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:85) 205 at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1554) 206 at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1321) 207 at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1139) 208 at org.apache.hadoop.hive.ql.Driver.run(Driver.java:962) 209 at org.apache.hadoop.hive.ql.Driver.run(Driver.java:952) 210 at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:269) 211 at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:221) 212 at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:431) 213 at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:800) 214 at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:694) 215 at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:633) 216 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 217 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 218 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) 219 at java.lang.reflect.Method.invoke(Method.java:498) 220 at org.apache.hadoop.util.RunJar.main(RunJar.java:212) 221 )
解决办法：
经过百度查找，得到了解决方法如下：
- 第一步，删除原hive连接MySQL数据库中存放hive元数据的数据库。drop database hive;
- 第二步，新建存放元数据库的数据。create database hive;
- 第三步，修改数据的编码为latin1 。 alter database hive character set latin1;
