hive整合 hbase报错

hive整合hbase,用hive client直接连接hbase的表可以,用beeline连hbase不行,报连接失败; 我理解是hiveser2整合hbase的方式不对,但hiveserver2启动是正常的:报错详细:

2016-10-11T23:35:42,563 INFO  [1a38a308-67fc-4d07-a2ab-562edf3cf553 HiveServer2-Handler-Pool: Thread-56-EventThread]: zookeeper.ClientCnxn (ClientCnxn.java:run(512)) - EventThread shut down

2016-10-11T23:35:42,563 INFO  [1a38a308-67fc-4d07-a2ab-562edf3cf553 HiveServer2-Handler-Pool: Thread-56]: zookeeper.ZooKeeper (ZooKeeper.java:close(684)) - Session: 0x3576b287bca5179 closed

2016-10-11T23:35:42,564 INFO  [1a38a308-67fc-4d07-a2ab-562edf3cf553 HiveServer2-Handler-Pool: Thread-56]: client.ConnectionManager$HConnectionImplementation (ConnectionManager.java:closeZooKeeperWatcher(1710)) - Closing zookeeper sessionid=0x2576b297bdb528b

2016-10-11T23:35:42,568 INFO  [1a38a308-67fc-4d07-a2ab-562edf3cf553 HiveServer2-Handler-Pool: Thread-56]: zookeeper.ZooKeeper (ZooKeeper.java:close(684)) - Session: 0x2576b297bdb528b closed

2016-10-11T23:35:42,568 INFO  [1a38a308-67fc-4d07-a2ab-562edf3cf553 HiveServer2-Handler-Pool: Thread-56-EventThread]: zookeeper.ClientCnxn (ClientCnxn.java:run(512)) - EventThread shut down

2016-10-11T23:35:42,569 INFO  [1a38a308-67fc-4d07-a2ab-562edf3cf553 HiveServer2-Handler-Pool: Thread-56]: conf.HiveConf (HiveConf.java:getLogIdVar(3177)) - Using the default value passed in for log id: 1a38a308-67fc-4d07-a2ab-562edf3cf553

2016-10-11T23:35:42,569 INFO  [1a38a308-67fc-4d07-a2ab-562edf3cf553 HiveServer2-Handler-Pool: Thread-56]: session.SessionState (SessionState.java:resetThreadName(417)) - Resetting thread name to  HiveServer2-Handler-Pool: Thread-56

2016-10-11T23:35:42,569 WARN  [HiveServer2-Handler-Pool: Thread-56]: thrift.ThriftCLIService (ThriftCLIService.java:FetchResults(702)) - Error fetching results:

org.apache.hive.service.cli.HiveSQLException: java.io.IOException: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after attempts=36, exceptions:

Tue Oct 11 23:35:42 CST 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68328: row 'data_visit_year_2,,00000000000000' on table 'hbase:meta' at region=hbase:meta,,1.1588230740, hostname=slave3,16020,1476072663759, seqNum=0

        at org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:361) ~[hive-service-2.0.1.jar:2.0.1]

        at org.apache.hive.service.cli.operation.OperationManager.getOperationNextRowSet(OperationManager.java:241) ~[hive-service-2.0.1.jar:2.0.1]

        at org.apache.hive.service.cli.session.HiveSessionImpl.fetchResults(HiveSessionImpl.java:777) ~[hive-service-2.0.1.jar:2.0.1]

        at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) ~[?:?]

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_20]

        at java.lang.reflect.Method.invoke(Method.java:483) ~[?:1.8.0_20]

        at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78) ~[hive-service-2.0.1.jar:2.0.1]

        at org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:36) ~[hive-service-2.0.1.jar:2.0.1]

        at org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63) ~[hive-service-2.0.1.jar:2.0.1]

        at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_20]

        at javax.security.auth.Subject.doAs(Subject.java:422) ~[?:1.8.0_20]

        at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1698) ~[hadoop-common-2.7.3.jar:?]

        at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59) ~[hive-service-2.0.1.jar:2.0.1]

        at com.sun.proxy.$Proxy35.fetchResults(Unknown Source) ~[?:?]

        at org.apache.hive.service.cli.CLIService.fetchResults(CLIService.java:439) ~[hive-service-2.0.1.jar:2.0.1]

        at org.apache.hive.service.cli.thrift.ThriftCLIService.FetchResults(ThriftCLIService.java:693) [hive-service-2.0.1.jar:2.0.1]

        at org.apache.hive.service.cli.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1557) [hive-service-2.0.1.jar:2.0.1]

        at org.apache.hive.service.cli.thrift.TCLIService$Processor$FetchResults.getResult(TCLIService.java:1542) [hive-service-2.0.1.jar:2.0.1]

        at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) [hive-exec-2.0.1.jar:2.0.1]

        at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39) [hive-exec-2.0.1.jar:2.0.1]

        at org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56) [hive-service-2.0.1.jar:2.0.1]

        at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286) [hive-exec-2.0.1.jar:2.0.1]

        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_20]

        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_20]

        at java.lang.Thread.run(Thread.java:745) [?:1.8.0_20]

Caused by: java.io.IOException: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after attempts=36, exceptions:

Tue Oct 11 23:35:42 CST 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68328: row 'data_visit_year_2,,00000000000000' on table 'hbase:meta' at region=hbase:meta,,1.1588230740, hostname=slave3,16020,1476072663759, seqNum=0

        at org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:513) ~[hive-exec-2.0.1.jar:2.0.1]

        at org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:420) ~[hive-exec-2.0.1.jar:2.0.1]

        at org.apache.hadoop.hive.ql.exec.FetchTask.fetch(FetchTask.java:145) ~[hive-exec-2.0.1.jar:2.0.1]

        at org.apache.hadoop.hive.ql.Driver.getResults(Driver.java:1850) ~[hive-exec-2.0.1.jar:2.0.1]

        at org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:356) ~[hive-service-2.0.1.jar:2.0.1]

        ... 24 more

Caused by: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after attempts=36, exceptions:

Tue Oct 11 23:35:42 CST 2016, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68328: row 'data_visit_year_2,,00000000000000' on table 'hbase:meta' at region=hbase:meta,,1.1588230740, hostname=slave3,16020,1476072663759, seqNum=0

        at org.apache.hadoop.hbase.client.RpcRetryingCallerWithReadReplicas.throwEnrichedException(RpcRetryingCallerWithReadReplicas.java:276) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:210) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:60) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:210) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.ClientScanner.call(ClientScanner.java:326) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.ClientScanner.nextScanner(ClientScanner.java:301) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.ClientScanner.initializeScannerInConstruction(ClientScanner.java:166) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.ClientScanner.<init>(ClientScanner.java:161) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.HTable.getScanner(HTable.java:797) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.MetaScanner.metaScan(MetaScanner.java:193) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.MetaScanner.metaScan(MetaScanner.java:89) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.MetaScanner.allTableRegions(MetaScanner.java:324) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.HRegionLocator.getAllRegionLocations(HRegionLocator.java:89) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.util.RegionSizeCalculator.init(RegionSizeCalculator.java:94) ~[hbase-server-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.util.RegionSizeCalculator.<init>(RegionSizeCalculator.java:81) ~[hbase-server-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.mapreduce.TableInputFormatBase.getSplits(TableInputFormatBase.java:256) ~[hbase-server-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hive.hbase.HiveHBaseTableInputFormat.getSplitsInternal(HiveHBaseTableInputFormat.java:501) ~[hive-hbase-handler-2.0.1.jar:2.0.1]

        at org.apache.hadoop.hive.hbase.HiveHBaseTableInputFormat.getSplits(HiveHBaseTableInputFormat.java:433) ~[hive-hbase-handler-2.0.1.jar:2.0.1]

        at org.apache.hadoop.hive.ql.exec.FetchOperator.getNextSplits(FetchOperator.java:368) ~[hive-exec-2.0.1.jar:2.0.1]

        at org.apache.hadoop.hive.ql.exec.FetchOperator.getRecordReader(FetchOperator.java:300) ~[hive-exec-2.0.1.jar:2.0.1]

        at org.apache.hadoop.hive.ql.exec.FetchOperator.getNextRow(FetchOperator.java:451) ~[hive-exec-2.0.1.jar:2.0.1]

        at org.apache.hadoop.hive.ql.exec.FetchOperator.pushRow(FetchOperator.java:420) ~[hive-exec-2.0.1.jar:2.0.1]

        at org.apache.hadoop.hive.ql.exec.FetchTask.fetch(FetchTask.java:145) ~[hive-exec-2.0.1.jar:2.0.1]

        at org.apache.hadoop.hive.ql.Driver.getResults(Driver.java:1850) ~[hive-exec-2.0.1.jar:2.0.1]

        at org.apache.hive.service.cli.operation.SQLOperation.getNextRowSet(SQLOperation.java:356) ~[hive-service-2.0.1.jar:2.0.1]

        ... 24 more

Caused by: java.net.SocketTimeoutException: callTimeout=60000, callDuration=68328: row 'data_visit_year_2,,00000000000000' on table 'hbase:meta' at region=hbase:meta,,1.1588230740, hostname=slave3,16020,1476072663759, seqNum=0

        at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:169) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.ResultBoundedCompletionService$QueueingFuture.run(ResultBoundedCompletionService.java:65) ~[hbase-client-1.2.3.jar:1.2.3]

        ... 3 more

Caused by: org.apache.hadoop.hbase.exceptions.ConnectionClosingException: Call to slave3/10.0.5.58:16020 failed on local exception: org.apache.hadoop.hbase.exceptions.ConnectionClosingException: Connection to slave3/10.0.5.58:16020 is closing. Call id=11, waitTime=2

        at org.apache.hadoop.hbase.ipc.AbstractRpcClient.wrapException(AbstractRpcClient.java:289) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.ipc.RpcClientImpl.call(RpcClientImpl.java:1271) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.ipc.AbstractRpcClient.callBlockingMethod(AbstractRpcClient.java:227) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.ipc.AbstractRpcClient$BlockingRpcChannelImplementation.callBlockingMethod(AbstractRpcClient.java:336) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$BlockingStub.scan(ClientProtos.java:34094) ~[hbase-protocol-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.ScannerCallable.openScanner(ScannerCallable.java:394) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:203) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.ScannerCallable.call(ScannerCallable.java:64) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithoutRetries(RpcRetryingCaller.java:210) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:364) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas$RetryingRPC.call(ScannerCallableWithReplicas.java:338) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.RpcRetryingCaller.callWithRetries(RpcRetryingCaller.java:136) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.client.ResultBoundedCompletionService$QueueingFuture.run(ResultBoundedCompletionService.java:65) ~[hbase-client-1.2.3.jar:1.2.3]

        ... 3 more

Caused by: org.apache.hadoop.hbase.exceptions.ConnectionClosingException: Connection to slave3/10.0.5.58:16020 is closing. Call id=11, waitTime=2

        at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.cleanupCalls(RpcClientImpl.java:1084) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.close(RpcClientImpl.java:863) ~[hbase-client-1.2.3.jar:1.2.3]

        at org.apache.hadoop.hbase.ipc.RpcClientImpl$Connection.run(RpcClientImpl.java:580) ~[hbase-client-1.2.3.jar:1.2.3]

2016-10-11T23:35:42,578 INFO  [HiveServer2-Handler-Pool: Thread-56]: conf.HiveConf (HiveConf.java:getLogIdVar(3177)) - Using the default value passed in for log id: 1a38a308-67fc-4d07-a2ab-562edf3cf553

2016-10-11T23:35:42,578 INFO  [HiveServer2-Handler-Pool: Thread-56]: session.SessionState (SessionState.java:updateThreadName(406)) - Updating thread name to 1a38a308-67fc-4d07-a2ab-562edf3cf553 HiveServer2-Handler-Pool: Thread-56

Beeline是Hive新的命令行客户端工具。
还没有见过连接hbase。
楼主从官网，还是什么地方，可以连接Hbase

einhep 发表于 2016-10-12 09:14
Beeline是Hive新的命令行客户端工具。
还没有见过连接hbase。
楼主从官网，还是什么地方，可以连接Hbase
...

我理解:hiveserver2是hive提供出来适用房以jdbc的方式连接hive,而beeline是hiveserver2的客户端, 肯定是可以连得