欢迎投稿

今日深度:

hive问题,

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访问正常。

www.htsjk.Com true http://www.htsjk.com/hive/40351.html NewsArticle 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.apach...
相关文章
    暂无相关文章
评论暂时关闭