hiveserver2是启动的,查询hive内部表没问题。对于hive的hbase外部表,在hive cli里执行select * from tablename是没问题的,但是hiveserver2里执行就是超时然后报错,hive日志中有大量client.RpcRetryingCaller (RpcRetryingCaller.java:callWithRetries(142)) - Call exception, tries=11, retries=35, started=88229 ms ago, cancelled=false, msg=row 'test,,00000000000000' on table 'hbase:meta' at region=hbase:meta,,1.1588230740, hostname=hdfs07,16020,1467270821072, seqNum=0这样的信息,然后就是Caused by: org.apache.hadoop.hbase.exceptions.ConnectionClosingException: Connection to hdfs07/10.129.20.107:16020 is closing. Call id=15, waitTime=2这样的错误信息。
另外必需说明的是:除了select * from table这样的不需要mapreduce过程的语句,其他语句,例如:select count(1) from table在cli和hiveserver2执行都是没问题的。 |