hbase整合hive后,hive beeline中select超时,但hbase整合hive后,hive beeli是在hive-cli中可以正常select
beeline
0: jdbc:hive2://master:10000/test> select * from test;
Error: java.io.IOException: org.apache.hadoop.hbase.client.RetriesExhaustedException: Failed after attempts=36, exceptions:
Mon Apr 17 05:30:03 EDT 2017, null, java.net.SocketTimeoutException: callTimeout=60000, callDuration=68258: row 'user,,00000000000000' on table 'hbase:meta' at region=hbase:meta,,1.1588230740, hostname=slave02,16020,1492419586738, seqNum=0 (state=,code=0)
0: jdbc:hive2://master:10000/test>
hive-cli
hive> select * from test;
OK
2017-04-17 05:28:50,135 INFO [872eebcc-fe0e-442f-b350-e53499e0797b main] Configuration.deprecation: mapred.input.dir is deprecated. Instead, use mapreduce.input.fileinputformat.inputdir
2017-04-17 05:28:50,412 INFO [872eebcc-fe0e-442f-b350-e53499e0797b main] zookeeper.RecoverableZooKeeper: Process identifier=hconnection-0x20ba544b connecting to ZooKeeper ensemble=master:2181,slave01:2181,slave02:2181
2017-04-17 05:28:50,860 INFO [872eebcc-fe0e-442f-b350-e53499e0797b main] util.RegionSizeCalculator: Calculating region sizes for table "user".
2017-04-17 05:28:52,402 INFO [872eebcc-fe0e-442f-b350-e53499e0797b main] client.ConnectionManager$HConnectionImplementation: Closing master protocol: MasterService
2017-04-17 05:28:52,405 INFO [872eebcc-fe0e-442f-b350-e53499e0797b main] client.ConnectionManager$HConnectionImplementation: Closing zookeeper sessionid=0x15b7acbfd3d0010
2017-04-17 05:28:52,572 INFO [872eebcc-fe0e-442f-b350-e53499e0797b main] zookeeper.RecoverableZooKeeper: Process identifier=hconnection-0x6d73c199 connecting to ZooKeeper ensemble=master:2181,slave01:2181,slave02:2181
2017-04-17 05:28:52,702 INFO [872eebcc-fe0e-442f-b350-e53499e0797b main] mapreduce.TableInputFormatBase: Input split length: 0 bytes.
2017-04-17 05:28:52,967 INFO [872eebcc-fe0e-442f-b350-e53499e0797b main] client.ConnectionManager$HConnectionImplementation: Closing zookeeper sessionid=0x15b7acbfd3d0011
rk0001 wangwu
Time taken: 2.96 seconds, Fetched: 1 row(s)
hive>