hive删除表失败： ERROR [main]: exec.DDLTask (DDLTask.java:failed(520)) - org.apache.hadoop.hive.ql.metadat

最新推荐文章于 2022-12-15 16:38:44 发布

交个朋友@zdp

最新推荐文章于 2022-12-15 16:38:44 发布

阅读量995

点赞数

分类专栏： hadoop hive

本文链接：https://blog.csdn.net/qq_31073717/article/details/81225515

版权

hadoop hive 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

hive删除database和table失败问题：

ERROR [main]: exec.DDLTask (DDLTask.java:failed(520)) - 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.)

2018-07-27 02:10:56,946 ERROR [main]: ql.Driver (SessionState.java:printError(960)) - 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.)
2018-07-27 02:10:56,946 INFO [main]: log.PerfLogger (PerfLogger.java:PerfLogEnd(148)) - </PERFLOG method=Driver.execute start=1532628635183 end=1532628656946 duration=21763 from=org.apache.hadoop.hive.ql.Driver>
2018-07-27 02:10:56,946 INFO [main]: log.PerfLogger (PerfLogger.java:PerfLogBegin(121)) - <PERFLOG method=releaseLocks from=org.apache.hadoop.hive.ql.Driver>
2018-07-27 02:10:56,946 INFO [main]: log.PerfLogger (PerfLogger.java:PerfLogEnd(148)) - </PERFLOG method=releaseLocks start=1532628656946 end=1532628656946 duration=0 from=org.apache.hadoop.hive.ql.Driver>
2018-07-27 02:10:56,955 INFO [main]: log.PerfLogger (PerfLogger.java:PerfLogBegin(121)) - <PERFLOG method=releaseLocks from=org.apache.hadoop.hive.ql.Driver>
2018-07-27 02:10:56,956 INFO [main]: log.PerfLogger (PerfLogger.java:PerfLogEnd(148)) - </PERFLOG method=releaseLocks start=1532628656955 end=1532628656956 duration=1 from=org.apache.hadoop.hive.ql.Driver>

问题主要是出现在msql连接jar包上，建议使用 mysql-connector-java-5.1.32.jar，换掉jar包之后问题解决。