Hive简单查询非常慢

Question

hive> use mytest

    > ;

OK

Time taken: 66.814 seconds  ===》這裡也很慢了

hive> show tables

    > ;

一直卡在这里，没有报错的信息，现在不知道从哪个地方下手查找原因了，求指导

[root@root]# jps
1600 DataNode
2256 NodeManager
12768 RunJar
1842 SecondaryNameNode
1461 NameNode
2119 ResourceManager
12924 RunJar
13148 RunJar
28751 Jps

hive.log有错误信息，但不知道是否这这个有关系

2021-03-26T14:07:24,157  WARN [85ab6794-b37d-4f0b-aca4-8219be8a27b0 main-SendThread(localhost:2181)] zookeeper.ClientCnxn: Session 0x0 for server null, unexpected error, closing socket connection and attempting reconnect

java.net.ConnectException: Connection refused

           at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method) ~[?:1.8.0_281]

           at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:715) ~[?:1.8.0_281]

           at org.apache.zookeeper.ClientCnxnSocketNIO.doTransport(ClientCnxnSocketNIO.java:361) ~[zookeeper-3.4.6.jar:3.4.6-1569965]

           at org.apache.zookeeper.ClientCnxn$SendThread.run(ClientCnxn.java:1081) ~[zookeeper-3.4.6.jar:3.4.6-1569965]

 

Answer 1

可能還是zookeeper的原因，安裝了zookeeper之後，就能很快查詢了,hive.log也沒有錯誤的信息了。

 

[root@xxx ~]# jps
2081 ResourceManager
1428 NameNode
26117 QuorumPeerMain
2759 RunJar
27607 Jps
26169 RunJar
2218 NodeManager
2618 RunJar
1805 SecondaryNameNode
1567 DataNode
[root@rpoipt-ap02 ~]#