https://community.cloudera.com/t5/Support-Questions/kudu-scan-very-slow/m-p/85473#M11686 <P>Sorry to reply late, and thanks a lot for your attention</P><P>&nbsp;</P><P>Here is&nbsp;the sql:</P><PRE>SELECT user_id, team_id, name, pile_no_prefix, version FROM project_spot order by version LIMIT 7</PRE><P>Here is the trace in cm:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="cm_scan.png" style="width: 537px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/5233iD02D88F94D32DDE3/image-dimensions/537x487?v=v2" width="537" height="487" role="button" title="cm_scan.png" alt="cm_scan.png" /></span></P><P>Here is the picture in kudu web ui scan page:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="kudu_scan1.png" style="width: 716px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/5234iE2498E57AA44CDC3/image-dimensions/716x130?v=v2" width="716" height="130" role="button" title="kudu_scan1.png" alt="kudu_scan1.png" /></span></P><P>&nbsp;</P><P>Here is the tace in kudu rpcz page:</P><PRE>{ "header": { "call_id": 23, "remote_method": { "service_name": "kudu.tserver.TabletServerService", "method_name": "Scan" }, "timeout_millis": 9999 }, "trace": "0125 16:44:14.197738 (+ 0us) service_pool.cc:163] Inserting onto call queue\n0125 16:44:14.197757 (+ 19us) service_pool.cc:222] Handling call\n0125 16:44:14.197852 (+ 95us) tablet_service.cc:1745] Creating iterator\n0125 16:44:14.198093 (+ 241us) tablet_service.cc:1789] Iterator init: OK\n0125 16:44:14.198096 (+ 3us) tablet_service.cc:1838] has_more: true\n0125 16:44:14.198097 (+ 1us) tablet_service.cc:1853] Continuing scan request\n0125 16:44:14.198101 (+ 4us) tablet_service.cc:1901] Found scanner a7c9ec89e70c4a65aed5da01e9c846cb\n0125 16:44:14.708182 (+510081us) tablet_service.cc:1960] Deadline expired - responding early\n0125 16:44:14.708296 (+ 114us) inbound_call.cc:157] Queueing success response\n", "duration_ms": 510, "metrics": [ { "key": "delta_iterators_relevant", "value": 1 }, { "key": "cfile_cache_hit", "value": 14 }, { "key": "cfile_cache_hit_bytes", "value": 289477 }, { "key": "threads_started", "value": 1 }, { "key": "thread_start_us", "value": 29 }, { "key": "compiler_manager_pool.queue_time_us", "value": 62 }, { "key": "compiler_manager_pool.run_cpu_time_us", "value": 110612 }, { "key": "compiler_manager_pool.run_wall_time_us", "value": 110623 } ] }</PRE> Fri, 25 Jan 2019 08:52:59 GMT huaj 2019-01-25T08:52:59Z