1.执行Hive命令的时候报错
FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException:
java.lang.RuntimeException:
Unable to instantiate
org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
2.初始化数据库,又报错,提示Host被锁
schematool -initSchema -dbType mysql
"Host '192.168.100.101' is blocked because of many connection errors;
3.原因
同一ip在短时间内产生太多(超过mysql数据库max_connection_errors的最大值)终端的数据
库连接而导致的阻塞;
4.解决方法,刷新host
登录mysql执行:
FLUSH HOSTS
5.执行以上命令无效
修改max_connection_errors
SHOW GLOBAL VARIABLES LIKE '%max_connect_errors%';//查看错误连接数
SET GLOBAL max_connect_errors = 1000;
FLUSH HOSTS