hive问题,
1、
0: jdbc:hive2://172.21.11.140:10000/default> select * from thisMonth_fee201705 where user_id=’test1’;
ERROR : Ended Job = job_1530517590445_0020 with errors
ERROR : FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
Error: Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask (state=08S01,code=2)
2、执行hive命令,报错
FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
查看cdh manager,3个metastore server 异常,重启时报错,连接不上配置的metastore数据库(mysql),修改“集群”-“hive”-“配置”,修改metastore配置的mysql数据库用户名和密码,重启3个metastore server 启动成功,hive访问正常。