百度查是字符问题,已解决
1.在创建table时报:“FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Meta Exception(message:For direct MetaStore DB connections, we don't support retries at the client level.)”
或者“FAILED: SemanticException Unable to fetch table flux. For direct MetaStore DB connections, we don't support retries at the client level.”
解决办法:
在mysql数据库中执行:ALTER DATABASE hive CHARACTER SET latin1;
然后在hive继续创建表成功
2.如果上述办法无效,请替换hive中的mysql-connector-java-×××××-bin.jar
替换为:
mysql-connector-java-5.1.1.38-bin.jar
亲测hive版本:apache-hive-1.2.0-bin替换后好使.