分享

hive集群模式简单查询,也非常慢

hive中简单查询非常慢,一条select * from table limit 1; 查了几分钟。
hive用debug模式启动时:日志疯狂刷。。下面重复的日志,耗时就是这个,但不知道原因

18/08/14 09:07:00 [IPC Client (1464191502) connection to trsnode0/12.17.97.81:8020 from root]: DEBUG ipc.Client: IPC Client (1464191502) connection to trsnode0/12.17.97.81:8020 from root got value #5154
18/08/14 09:07:00 [main]: DEBUG ipc.ProtobufRpcEngine: Call: getListing took 7ms
18/08/14 09:07:00 [IPC Parameter Sending Thread #1]: DEBUG ipc.Client: IPC Client (1464191502) connection to trsnode0/12.17.97.81:8020 from root sending #5155
18/08/14 09:07:00 [IPC Client (1464191502) connection to trsnode0/12.17.97.81:8020 from root]: DEBUG ipc.Client: IPC Client (1464191502) connection to trsnode0/12.17.97.81:8020 from root got value #5155
18/08/14 09:07:00 [main]: DEBUG ipc.ProtobufRpcEngine: Call: getListing took 6ms
18/08/14 09:07:00 [IPC Parameter Sending Thread #1]: DEBUG ipc.Client: IPC Client (1464191502) connection to trsnode0/12.17.97.81:8020 from root sending #5156
18/08/14 09:07:00 [IPC Client (1464191502) connection to trsnode0/12.17.97.81:8020 from root]: DEBUG ipc.Client: IPC Client (1464191502) connection to trsnode0/12.17.97.81:8020 from root got value #5156
18/08/14 09:07:00 [main]: DEBUG ipc.ProtobufRpcEngine: Call: getListing took 6ms
18/08/14 09:07:00 [IPC Parameter Sending Thread #1]: DEBUG ipc.Client: IPC Client (1464191502) connection to trsnode0/12.17.97.81:8020 from root sending #5157
18/08/14 09:07:00 [IPC Client (1464191502) connection to trsnode0/12.17.97.81:8020 from root]: DEBUG ipc.Client: IPC Client (1464191502) connection to trsnode0/12.17.97.81:8020 from root got value #5157
18/08/14 09:07:00 [main]: DEBUG ipc.ProtobufRpcEngine: Call: getListing took 6ms
18/08/14 09:07:00 [IPC Parameter Sending Thread #1]: DEBUG ipc.Client: IPC Client (1464191502) connection to trsnode0/12.17.97.81:8020 from root sending #5158

18/08/14 09:07:00 [IPC Client (1464191502) connection to trsnode0/12.17.97.81:8020 from root]: DEBUG ipc.Client: IPC Client (1464191502) connection to trsnode0/12.17.97.81:8020 from root got value #5158






已有(2)人评论

跳转到指定楼层
bioger_hit 发表于 2018-8-14 10:23:08
几个节点,为何这个节点都是自己连接自己
回复

使用道具 举报

水木山川 发表于 2018-8-14 10:36:49
hive 不区分大小写查询
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

关闭

推荐上一条 /2 下一条