hiveserver2使用hbase外部表时报ConnectionClosingException

[zh350229319]

我使用hive cli连接hbase可以正常查询hbase数据。
但是使用beeline或者hive jdbc连接时，无法对hbase外部表查询，但是可以show tables;

异常信息如下：

Caused by: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after attempts=36, exceptions:
Wed Aug 15 20:46:12 CST 2018, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68514: row 'dcm_order,,00000000000000' on table 'hbase:meta' at region=hbase:meta,,1.1588230740, hostname=dashuju172,16020,1533805973753, seqNum=0

        at org.apache.hadoop.hbase.client.RpcRetryingCallerWithReadReplicas.throwEnrichedException(RpcRetryingCallerWithReadReplicas.java:271) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:223) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:61) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:200) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.ClientScanner.call(ClientScanner.java:320) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.ClientScanner.nextScanner(ClientScanner.java:295) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.ClientScanner.initializeScannerInConstruction(ClientScanner.java:160) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.ClientScanner.<init>(ClientScanner.java:155) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.HTable.getScanner(HTable.java:811) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.MetaScanner.metaScan(MetaScanner.java:193) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.MetaScanner.metaScan(MetaScanner.java:89) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.MetaScanner.allTableRegions(MetaScanner.java:324) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.HRegionLocator.getAllRegionLocations(HRegionLocator.java:88) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.util.RegionSizeCalculator.init(RegionSizeCalculator.java:94) ~[hbase-server-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.util.RegionSizeCalculator.<init>(RegionSizeCalculator.java:81) ~[hbase-server-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.mapreduce.TableInputFormatBase.getSplits(TableInputFormatBase.java:256) ~[hbase-server-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hive.hbase.HiveHBaseTableInputFormat.getSplitsInternal(HiveHBaseTableInputFormat.java:526) ~[hive-hbase-handler-2.3.2.jar:2.3.2]
        at org.apache.hadoop.hive.hbase.HiveHBaseTableInputFormat.getSplits(HiveHBaseTableInputFormat.java:452) ~[hive-hbase-handler-2.3.2.jar:2.3.2]
        at org.apache.hadoop.hive.ql.exec.FetchOperator.getNextSplits(FetchOperator.java:372) ~[hive-exec-2.3.2.jar:2.3.2]
        at org.apache.hadoop.hive.ql.exec.FetchOperator.getRecordReader(FetchOperator.java:304) ~[hive-exec-2.3.2.jar:2.3.2]
        at org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:459) ~[hive-exec-2.3.2.jar:2.3.2]
        at org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:428) ~[hive-exec-2.3.2.jar:2.3.2]
        at org.apache.hadoop.hive.ql.exec.FetchTask.fetch(FetchTask.java:147) ~[hive-exec-2.3.2.jar:2.3.2]
        at org.apache.hadoop.hive.ql.Driver.getResults(Driver.java:2208) ~[hive-exec-2.3.2.jar:2.3.2]
        at org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:494) ~[hive-service-2.3.2.jar:2.3.2]
        ... 25 more
Caused by: java.net.SocketTimeoutException: callTimeout=60000, callDuration=68514: row 'dcm_order,,00000000000000' on table 'hbase:meta' at region=hbase:meta,,1.1588230740, hostname=dashuju172,16020,1533805973753, seqNum=0
        at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:159) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.ResultBoundedCompletionService$QueueingFuture.run(ResultBoundedCompletionService.java:64) ~[hbase-client-1.1.1.jar:1.1.1]
        ... 3 more
Caused by: org.apache.hadoop.hbase.exceptions.ConnectionClosingException: Call to dashuju172/192.168.5.172:16020 failed on local exception: org.apache.hadoop.hbase.exceptions.ConnectionClosingException: Connection to dashuju172/192.168.5.172:16020 is closing. Call id=9, waitTime=3
        at org.apache.hadoop.hbase.ipc.RpcClientImpl.wrapException(RpcClientImpl.java:1239) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.ipc.RpcClientImpl.call(RpcClientImpl.java:1210) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:213) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.callBlockingMethod(AbstractRpcClient.java:287) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$BlockingStub.scan(ClientProtos.java:32651) ~[hbase-protocol-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.ScannerCallable.openScanner(ScannerCallable.java:372) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:199) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:62) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:200) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:369) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:343) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:126) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.client.ResultBoundedCompletionService$QueueingFuture.run(ResultBoundedCompletionService.java:64) ~[hbase-client-1.1.1.jar:1.1.1]
        ... 3 more
Caused by: org.apache.hadoop.hbase.exceptions.ConnectionClosingException: Connection to dashuju172/192.168.5.172:16020 is closing. Call id=9, waitTime=3
        at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.cleanupCalls(RpcClientImpl.java:1037) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.close(RpcClientImpl.java:844) ~[hbase-client-1.1.1.jar:1.1.1]
        at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.run(RpcClientImpl.java:572) ~[hbase-client-1.1.1.jar:1.1.1]

[东南一混]

##beeline连接hbase时这里要设置为false
##默认情况下，HiveServer2以提交查询的用户执行查询（true），如果hive.server2.enable.doAs设置为false，查询将以运行hiveserver2进程的用户运行

<property>

<name>hive.server2.enable.doAs</name>

<value>false</value>

</property>