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