hive删除表错误

问题复现：
启动hive的2个前提：hdfs三进程启动好后，mysql数据库也都正常，也能够正常创建数据库、创建表、把数据加载到表中。但是在我们删除表过程中出现了如下报错：

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level.)

去hive的日志下查看，cd /tmp/hadoop，tail -200f hive.log

NestedThrowablesStackTrace:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1

2019-07-01 15:57:54,880 ERROR [main]: exec.DDLTask (DDLTask.java:failed(517)) - org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level.)

Caused by: MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level.)


2019-07-01 15:57:54,881 ERROR [main]: ql.Driver (SessionState.java:printError(936)) - FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level.)
2019-07-01 15:57:54,882 INFO  [main]: ql.Driver (Driver.java:execute(1696)) - Completed executing command(queryId=hadoop_20190701155656_ea6f5ec6-0fa9-43d9-8ac3-88b1ea0374dc); Time taken: 21.302 seconds

说一下我的环境：hadoop2.6.0-cdh5.7.0 + hive-1.1.0-cdh5.7.0 + mysql5.6.23

经过测试发现：是因为jar包的问题，在这个目录下/home/hadoop/app/hive/lib，我们目前使用的jar包是mysql-connector-java-5.1.7-bin.jar，我们将其替换为mysql-connector-java-5.1.46-bin.jar这个版本，重启hive，测试后已无问题。

重启hive后新建表：

hive (ruozeg6)> create table test(
              > empno int,
              > ename string,
              > job string,
              > mgr int,
              > hiredate string,
              > sal double,
              > comm double,
              > deptno int
              > ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t';
OK
Time taken: 0.148 seconds

查看日志打印：

2019-07-01 15:48:14,355 INFO  [main]: ql.Driver (Driver.java:compile(411)) - Compiling command(queryId=hadoop_20190701154747_8519c07b-06ec-4990-a7b2-e64022ead78d): create table test(
empno int,
ename string,
job string,
mgr int,
hiredate string,
sal double,
comm double,
deptno int
) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
2019-07-01 15:48:14,365 INFO  [main]: ql.Driver (Driver.java:compile(463)) - Semantic Analysis Completed
2019-07-01 15:48:14,365 INFO  [main]: ql.Driver (Driver.java:getSchema(245)) - Returning Hive schema: Schema(fieldSchemas:null, properties:null)
2019-07-01 15:48:14,370 INFO  [main]: ql.Driver (Driver.java:compile(541)) - Completed compiling command(queryId=hadoop_20190701154747_8519c07b-06ec-4990-a7b2-e64022ead78d); Time taken: 0.015 seconds
2019-07-01 15:48:14,370 INFO  [main]: ql.Driver (Driver.java:checkConcurrency(165)) - Concurrency mode is disabled, not creating a lock manager
2019-07-01 15:48:14,370 INFO  [main]: ql.Driver (Driver.java:execute(1448)) - Executing command(queryId=hadoop_20190701154747_8519c07b-06ec-4990-a7b2-e64022ead78d): create table test(
empno int,
ename string,
job string,
mgr int,
hiredate string,
sal double,
comm double,
deptno int
) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
2019-07-01 15:48:14,371 INFO  [main]: ql.Driver (Driver.java:launchTask(1772)) - Starting task [Stage-0:DDL] in serial mode
2019-07-01 15:48:14,502 INFO  [main]: ql.Driver (Driver.java:execute(1696)) - Completed executing command(queryId=hadoop_20190701154747_8519c07b-06ec-4990-a7b2-e64022ead78d); Time taken: 0.132 seconds
2019-07-01 15:48:14,503 INFO  [main]: ql.Driver (SessionState.java:printInfo(927)) - OK

hive下删除test表操作：

hive (ruozeg6)> drop table test;
OK
Time taken: 0.331 seconds

/tmp/hadoop/hive.log下查看日志打印：

2019-07-01 15:50:34,888 INFO  [main]: ql.Driver (Driver.java:compile(411)) - Compiling command(queryId=hadoop_20190701154747_8519c07b-06ec-4990-a7b2-e64022ead78d): drop table test
2019-07-01 15:50:34,919 INFO  [main]: ql.Driver (Driver.java:compile(463)) - Semantic Analysis Completed
2019-07-01 15:50:34,920 INFO  [main]: ql.Driver (Driver.java:getSchema(245)) - Returning Hive schema: Schema(fieldSchemas:null, properties:null)
2019-07-01 15:50:34,921 INFO  [main]: ql.Driver (Driver.java:compile(541)) - Completed compiling command(queryId=hadoop_20190701154747_8519c07b-06ec-4990-a7b2-e64022ead78d); Time taken: 0.033 seconds
2019-07-01 15:50:34,921 INFO  [main]: ql.Driver (Driver.java:checkConcurrency(165)) - Concurrency mode is disabled, not creating a lock manager
2019-07-01 15:50:34,921 INFO  [main]: ql.Driver (Driver.java:execute(1448)) - Executing command(queryId=hadoop_20190701154747_8519c07b-06ec-4990-a7b2-e64022ead78d): drop table test
2019-07-01 15:50:34,922 INFO  [main]: ql.Driver (Driver.java:launchTask(1772)) - Starting task [Stage-0:DDL] in serial mode
2019-07-01 15:50:35,216 INFO  [main]: ql.Driver (Driver.java:execute(1696)) - Completed executing command(queryId=hadoop_20190701154747_8519c07b-06ec-4990-a7b2-e64022ead78d); Time taken: 0.295 seconds
2019-07-01 15:50:35,217 INFO  [main]: ql.Driver (SessionState.java:printInfo(927)) - OK

替换jar包后就没问题了，具体mysql版本和对应的驱动包
遇到错误当时查看的博文：
https://blog.csdn.net/sinat_30333853/article/details/53844306