Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-6257

TestKuduMemLimits::test_low_mem_limit_low_selectivity_scan times out in S3 build

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Critical
    • Resolution: Cannot Reproduce
    • Impala 2.11.0
    • Impala 2.11.0
    • None
    • ghx-label-9

    Description

      In a recent S3 build, TestKuduMemLimits::test_low_mem_limit_low_selectivity_scan failed because a fragment doesn't finish in time. The error message is:

      07:49:57  TestKuduMemLimits.test_low_mem_limit_low_selectivity_scan[exec_option: {'batch_size': 0, 'num_nodes': 0, 'disable_codegen_rows_threshold': 0, 'disable_codegen': False, 'abort_on_error': 1, 'exec_single_node_rows_threshold': 0} | table_format: text/none-1] 
      07:49:57 query_test/test_kudu.py:1062: in test_low_mem_limit_low_selectivity_scan
      07:49:57     v.wait_for_metric("impala-server.num-fragments-in-flight", 0, timeout=30)
      07:49:57 verifiers/metric_verifier.py:62: in wait_for_metric
      07:49:58     self.impalad_service.wait_for_metric_value(metric_name, expected_value, timeout)
      07:49:58 common/impala_service.py:89: in wait_for_metric_value
      07:49:58     (metric_name, expected_value, timeout)
      07:49:58 E   AssertionError: Metric value impala-server.num-fragments-in-flight did not reach value 0 in 30s
      

      Looking at the coordinator log, the query hangs for 30 seconds before it's cancelled by the client:

      I1127 07:30:37.677126  5939 coordinator.cc:789] Coordinator waiting for backends to finish, 1 remaining
      I1127 07:30:37.677865  5939 coordinator.cc:794] All backends finished successfully.
      I1127 07:30:37.677877  5939 coordinator.cc:1090] Release admssion control resources for query 4044d47830c1cc98:8a63d27b00000000
      I1127 07:30:37.677942  6043 data-stream-mgr.cc:238] DeregisterRecvr(): fragment_instance_id=4044d47830c1cc98:8a63d27b00000000, node=1
      I1127 07:30:37.677963  6043 data-stream-recvr.cc:235] cancelled stream: fragment_instance_id_=4044d47830c1cc98:8a63d27b00000000 node_id=1
      I1127 07:30:37.678045  6043 query-state.cc:385] Instance completed. instance_id=4044d47830c1cc98:8a63d27b00000000 #in-flight=1 status=OK
      I1127 07:30:37.678073  6043 query-exec-mgr.cc:149] ReleaseQueryState(): query_id=4044d47830c1cc98:8a63d27b00000000 refcnt=2
      I1127 07:31:08.084748  5939 impala-hs2-server.cc:699] CloseOperation(): query_id=4044d47830c1cc98:8a63d27b00000000
      I1127 07:31:08.084779  5939 impala-server.cc:992] UnregisterQuery(): query_id=4044d47830c1cc98:8a63d27b00000000
      I1127 07:31:08.084790  5939 impala-server.cc:1075] Cancel(): query_id=4044d47830c1cc98:8a63d27b00000000
      I1127 07:31:08.084808  5939 coordinator.cc:895] Cancel() query_id=4044d47830c1cc98:8a63d27b00000000
      I1127 07:31:08.084827  5939 coordinator.cc:905] CancelBackends() query_id=4044d47830c1cc98:8a63d27b00000000, tried to cancel 0 backends
      I1127 07:31:08.090203  5939 query-exec-mgr.cc:149] ReleaseQueryState(): query_id=4044d47830c1cc98:8a63d27b00000000 refcnt=1
      I1127 07:31:08.101332  5939 impala-hs2-server.cc:381] CloseSession(): request=TCloseSessionReq {
      

      Compared to the same but successful query, the #in-flight differs:

      I1128 07:35:45.863986  7571 coordinator.cc:789] Coordinator waiting for backends to finish, 1 remaining
      I1128 07:35:45.864734  7571 coordinator.cc:794] All backends finished successfully.
      I1128 07:35:45.864749  7571 coordinator.cc:1090] Release admssion control resources for query 6f43945cef3a95be:744fd2a300000000
      I1128 07:35:45.864823  7671 data-stream-mgr.cc:238] DeregisterRecvr(): fragment_instance_id=6f43945cef3a95be:744fd2a300000000, node=1
      I1128 07:35:45.864845  7671 data-stream-recvr.cc:235] cancelled stream: fragment_instance_id_=6f43945cef3a95be:744fd2a300000000 node_id=1
      I1128 07:35:45.864953  7671 query-state.cc:385] Instance completed. instance_id=6f43945cef3a95be:744fd2a300000000 #in-flight=0 status=OK
      I1128 07:35:45.864982  7671 query-exec-mgr.cc:149] ReleaseQueryState(): query_id=6f43945cef3a95be:744fd2a300000000 refcnt=2
      I1128 07:35:45.944633  7571 impala-hs2-server.cc:699] CloseOperation(): query_id=6f43945cef3a95be:744fd2a300000000
      I1128 07:35:45.944655  7571 impala-server.cc:992] UnregisterQuery(): query_id=6f43945cef3a95be:744fd2a300000000
      I1128 07:35:45.944666  7571 impala-server.cc:1075] Cancel(): query_id=6f43945cef3a95be:744fd2a300000000
      I1128 07:35:45.944691  7571 coordinator.cc:895] Cancel() query_id=6f43945cef3a95be:744fd2a300000000
      I1128 07:35:45.944710  7571 coordinator.cc:905] CancelBackends() query_id=6f43945cef3a95be:744fd2a300000000, tried to cancel 0 backends
      I1128 07:35:45.949873  7571 query-exec-mgr.cc:149] ReleaseQueryState(): query_id=6f43945cef3a95be:744fd2a300000000 refcnt=1
      I1128 07:35:45.959841  7571 impala-hs2-server.cc:381] CloseSession(): request=TCloseSessionReq {
      

      In the query profile, there is a 30s gap between "First row fetched" (The query only returns 1 row) and "Unregister query".

      Query (id=4044d47830c1cc98:8a63d27b00000000):
        DEBUG MODE WARNING: Query profile created while running a DEBUG build of Impala. Use RELEASE builds to measure query performance.
        Summary:
          Session ID: c4db0e602700a43:81f5e7a5788465b0
          Session Type: HIVESERVER2
          HiveServer2 Protocol Version: V6
          Start Time: 2017-11-27 07:30:37.616861
          End Time: 2017-11-27 07:31:08.085625
          Query Type: QUERY
          Query State: FINISHED
          Query Status: OK
          Impala Version: impalad version 2.11.0-SNAPSHOT DEBUG (build 79a5de1028b1c9523d3a2525d2a189288ca55357)
          User: jenkins
          Connected User: jenkins
          Delegated User: 
          Network Address: 127.0.0.1:34124
          Default Db: fkfp7v
          Sql Statement: select * from tpch_kudu.lineitem limit 90
          Coordinator: impala-boost-static-burst-slave-10ec.vpc.cloudera.com:22000
          Query Options (set by configuration): ABORT_ON_ERROR=1,MEM_LIMIT=10485760,EXEC_SINGLE_NODE_ROWS_THRESHOLD=0,DISABLE_CODEGEN_ROWS_THRESHOLD=0
          Query Options (set by configuration and planner): ABORT_ON_ERROR=1,MEM_LIMIT=10485760,EXEC_SINGLE_NODE_ROWS_THRESHOLD=0,MT_DOP=0,DISABLE_CODEGEN_ROWS_THRESHOLD=0
          Plan: 
      ----------------
      Max Per-Host Resource Reservation: Memory=0B
      Per-Host Resource Estimates: Memory=10.00MB
      
      F01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1
      |  Per-Host Resources: mem-estimate=0B mem-reservation=0B
      PLAN-ROOT SINK
      |  mem-estimate=0B mem-reservation=0B
      |
      01:EXCHANGE [UNPARTITIONED]
      |  limit: 90
      |  mem-estimate=0B mem-reservation=0B
      |  tuple-ids=0 row-size=263B cardinality=90
      |
      F00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3
      Per-Host Resources: mem-estimate=0B mem-reservation=0B
      00:SCAN KUDU [tpch_kudu.lineitem]
         limit: 90
         mem-estimate=0B mem-reservation=0B
         tuple-ids=0 row-size=263B cardinality=90
      ----------------
          Estimated Per-Host Mem: 10485760
          Per Host Min Reservation: impala-boost-static-burst-slave-10ec.vpc.cloudera.com:22000(0) impala-boost-static-burst-slave-10ec.vpc.cloudera.com:22001(0) impala-boost-static-burst-slave-10ec.vpc.cloudera.com:22002(0) 
          Request Pool: default-pool
          Admission result: Admitted immediately
          ExecSummary: 
      Operator       #Hosts  Avg Time  Max Time  #Rows  Est. #Rows  Peak Mem  Est. Peak Mem  Detail             
      ----------------------------------------------------------------------------------------------------------
      01:EXCHANGE         1  14.999ms  14.999ms     90          90         0              0  UNPARTITIONED      
      00:SCAN KUDU        3  12.666ms  12.999ms    270          90   1.52 MB              0  tpch_kudu.lineitem 
          Errors: 
          Planner Timeline: 10.640ms
             - Analysis finished: 2.106ms (2.106ms)
             - Value transfer graph computed: 2.404ms (297.594us)
             - Single node plan created: 8.894ms (6.490ms)
             - Runtime filters computed: 9.062ms (167.506us)
             - Distributed plan created: 9.165ms (103.670us)
             - Planning finished: 10.640ms (1.474ms)
          Query Timeline: 30s468ms
             - Query submitted: 0.000ns (0.000ns)
             - Planning finished: 12.999ms (12.999ms)
             - Submit for admission: 12.999ms (0.000ns)
             - Completed admission: 12.999ms (0.000ns)
             - Ready to start on 3 backends: 12.999ms (0.000ns)
             - All 3 execution backends (4 fragment instances) started: 13.999ms (999.983us)
             - Rows available: 47.999ms (33.999ms)
             - First row fetched: 58.998ms (10.999ms)
             - Unregister query: 30s468ms (30s409ms)
           - ComputeScanRangeAssignmentTimer: 0.000ns
        ImpalaServer:
           - ClientFetchWaitTimer: 30s418ms
           - RowMaterializationTimer: 1.999ms
        Execution Profile 4044d47830c1cc98:8a63d27b00000000:(Total: 35.999ms, non-child: 0.000ns, % non-child: 0.00%)
          Number of filters: 0
          Filter routing table: 
       ID  Src. Node  Tgt. Node(s)  Target type  Partition filter  Pending (Expected)  First arrived  Completed   Enabled
      -------------------------------------------------------------------------------------------------------------------
      
          Backend startup latencies: Count: 3, min / max: 1ms / 1ms, 25th %-ile: 1ms, 50th %-ile: 1ms, 75th %-ile: 1ms, 90th %-ile: 1ms, 95th %-ile: 1ms, 99.9th %-ile: 1ms
          Per Node Peak Memory Usage: impala-boost-static-burst-slave-10ec.vpc.cloudera.com:22000(1.36 MB) impala-boost-static-burst-slave-10ec.vpc.cloudera.com:22001(1.89 MB) impala-boost-static-burst-slave-10ec.vpc.cloudera.com:22002(1.33 MB) 
           - FiltersReceived: 0 (0)
           - FinalizationTimer: 0.000ns
           - NumBackends: 3 (3)
           - NumFragmentInstances: 4 (4)
           - NumFragments: 2 (2)
          Averaged Fragment F01:(Total: 44.999ms, non-child: 0.000ns, % non-child: 0.00%)
            split sizes:  min: 0, max: 0, avg: 0, stddev: 0
            completion times: min:45.999ms  max:45.999ms  mean: 45.999ms  stddev:0.000ns
            execution rates: min:0.00 /sec  max:0.00 /sec  mean:0.00 /sec  stddev:0.00 /sec
            num instances: 1
             - AverageThreadTokens: 0.00 
             - BloomFilterBytes: 0
             - PeakMemoryUsage: 80.18 KB (82103)
             - PeakReservation: 0
             - PeakUsedReservation: 0
             - PerHostPeakMemUsage: 1.36 MB (1428125)
             - RowsProduced: 90 (90)
             - TotalNetworkReceiveTime: 14.999ms
             - TotalNetworkSendTime: 0.000ns
             - TotalStorageWaitTime: 0.000ns
             - TotalThreadsInvoluntaryContextSwitches: 0 (0)
             - TotalThreadsTotalWallClockTime: 25.999ms
               - TotalThreadsSysTime: 0.000ns
               - TotalThreadsUserTime: 1.000ms
             - TotalThreadsVoluntaryContextSwitches: 2 (2)
            Fragment Instance Lifecycle Timings:
               - ExecTime: 10.999ms
                 - ExecTreeExecTime: 0.000ns
               - OpenTime: 14.999ms
                 - ExecTreeOpenTime: 14.999ms
               - PrepareTime: 17.999ms
                 - ExecTreePrepareTime: 0.000ns
            PLAN_ROOT_SINK:
               - PeakMemoryUsage: 0
            CodeGen:(Total: 17.999ms, non-child: 0.000ns, % non-child: 0.00%)
               - CodegenTime: 0.000ns
               - CompileTime: 0.000ns
               - LoadTime: 0.000ns
               - ModuleBitcodeSize: 1.86 MB (1950540)
               - NumFunctions: 0 (0)
               - NumInstructions: 0 (0)
               - OptimizationTime: 0.000ns
               - PeakMemoryUsage: 0
               - PrepareTime: 16.999ms
            EXCHANGE_NODE (id=1):(Total: 14.999ms, non-child: 0.000ns, % non-child: 0.00%)
               - ConvertRowBatchTime: 0.000ns
               - PeakMemoryUsage: 0
               - RowsReturned: 90 (90)
               - RowsReturnedRate: 6.00 K/sec
              DataStreamReceiver:
                 - BytesReceived: 32.87 KB (33662)
                 - DeserializeRowBatchTimer: 0.000ns
                 - FirstBatchArrivalWaitTime: 14.999ms
                 - PeakMemoryUsage: 48.90 KB (50074)
                 - SendersBlockedTimer: 0.000ns
                 - SendersBlockedTotalTimer(*): 0.000ns
          Coordinator Fragment F01:
            Instance 4044d47830c1cc98:8a63d27b00000000 (host=impala-boost-static-burst-slave-10ec.vpc.cloudera.com:22000):(Total: 44.999ms, non-child: 0.000ns, % non-child: 0.00%)
               - AverageThreadTokens: 0.00 
               - BloomFilterBytes: 0
               - PeakMemoryUsage: 80.18 KB (82103)
               - PeakReservation: 0
               - PeakUsedReservation: 0
               - PerHostPeakMemUsage: 1.36 MB (1428125)
               - RowsProduced: 90 (90)
               - TotalNetworkReceiveTime: 14.999ms
               - TotalNetworkSendTime: 0.000ns
               - TotalStorageWaitTime: 0.000ns
               - TotalThreadsInvoluntaryContextSwitches: 0 (0)
               - TotalThreadsTotalWallClockTime: 25.999ms
                 - TotalThreadsSysTime: 0.000ns
                 - TotalThreadsUserTime: 1.000ms
               - TotalThreadsVoluntaryContextSwitches: 2 (2)
              Fragment Instance Lifecycle Timings:
                 - ExecTime: 10.999ms
                   - ExecTreeExecTime: 0.000ns
                 - OpenTime: 14.999ms
                   - ExecTreeOpenTime: 14.999ms
                 - PrepareTime: 17.999ms
                   - ExecTreePrepareTime: 0.000ns
              PLAN_ROOT_SINK:
                 - PeakMemoryUsage: 0
              CodeGen:(Total: 17.999ms, non-child: 0.000ns, % non-child: 0.00%)
                 - CodegenTime: 0.000ns
                 - CompileTime: 0.000ns
                 - LoadTime: 0.000ns
                 - ModuleBitcodeSize: 1.86 MB (1950540)
                 - NumFunctions: 0 (0)
                 - NumInstructions: 0 (0)
                 - OptimizationTime: 0.000ns
                 - PeakMemoryUsage: 0
                 - PrepareTime: 16.999ms
              EXCHANGE_NODE (id=1):(Total: 14.999ms, non-child: 0.000ns, % non-child: 0.00%)
                 - ConvertRowBatchTime: 0.000ns
                 - PeakMemoryUsage: 0
                 - RowsReturned: 90 (90)
                 - RowsReturnedRate: 6.00 K/sec
                DataStreamReceiver:
                   - BytesReceived: 32.87 KB (33662)
                   - DeserializeRowBatchTimer: 0.000ns
                   - FirstBatchArrivalWaitTime: 14.999ms
                   - PeakMemoryUsage: 48.90 KB (50074)
                   - SendersBlockedTimer: 0.000ns
                   - SendersBlockedTotalTimer(*): 0.000ns
          Averaged Fragment F00:(Total: 34.332ms, non-child: 0.000ns, % non-child: 0.00%)
            split sizes:  min: 0, max: 0, avg: 0, stddev: 0
            completion times: min:33.999ms  max:37.999ms  mean: 36.332ms  stddev:1.699ms
            execution rates: min:0.00 /sec  max:0.00 /sec  mean:0.00 /sec  stddev:0.00 /sec
            num instances: 3
             - AverageThreadTokens: 0.00 
             - BloomFilterBytes: 0
             - PeakMemoryUsage: 1.52 MB (1589936)
             - PeakReservation: 0
             - PeakUsedReservation: 0
             - PerHostPeakMemUsage: 1.53 MB (1600852)
             - RowsProduced: 90 (90)
             - TotalNetworkReceiveTime: 0.000ns
             - TotalNetworkSendTime: 333.327us
             - TotalStorageWaitTime: 27.666ms
             - TotalThreadsInvoluntaryContextSwitches: 11 (11)
             - TotalThreadsTotalWallClockTime: 38.999ms
               - TotalThreadsSysTime: 1.333ms
               - TotalThreadsUserTime: 6.664ms
             - TotalThreadsVoluntaryContextSwitches: 15 (15)
            Fragment Instance Lifecycle Timings:
               - ExecTime: 12.666ms
                 - ExecTreeExecTime: 11.333ms
               - OpenTime: 666.655us
                 - ExecTreeOpenTime: 666.655us
               - PrepareTime: 20.999ms
                 - ExecTreePrepareTime: 0.000ns
            DataStreamSender (dst_id=1):(Total: 999.982us, non-child: 0.000ns, % non-child: 0.00%)
               - BytesSent: 10.96 KB (11220)
               - NetworkThroughput(*): 0.00 /sec
               - OverallThroughput: 5.37 MB/sec
               - PeakMemoryUsage: 688.00 B (688)
               - RowsReturned: 90 (90)
               - SerializeBatchTime: 666.655us
               - TransmitDataRPCTime: 0.000ns
               - UncompressedRowBatchSize: 24.06 KB (24637)
            CodeGen:(Total: 19.666ms, non-child: 0.000ns, % non-child: 0.00%)
               - CodegenTime: 0.000ns
               - CompileTime: 0.000ns
               - LoadTime: 0.000ns
               - ModuleBitcodeSize: 1.86 MB (1950540)
               - NumFunctions: 0 (0)
               - NumInstructions: 0 (0)
               - OptimizationTime: 0.000ns
               - PeakMemoryUsage: 0
               - PrepareTime: 18.999ms
            KUDU_SCAN_NODE (id=0):(Total: 12.666ms, non-child: 0.000ns, % non-child: 0.00%)
               - BytesRead: 0
               - CollectionItemsRead: 0 (0)
               - KuduRemoteScanTokens: 0 (0)
               - NumScannerThreadsStarted: 3 (3)
               - PeakMemoryUsage: 1.39 MB (1454080)
               - RowsRead: 9.34K (9338)
               - RowsReturned: 90 (90)
               - RowsReturnedRate: 7.12 K/sec
               - ScanRangesComplete: 1 (1)
               - ScannerThreadsInvoluntaryContextSwitches: 10 (10)
               - ScannerThreadsTotalWallClockTime: 25.666ms
                 - MaterializeTupleTime(*): 11.333ms
                 - ScannerThreadsSysTime: 666.333us
                 - ScannerThreadsUserTime: 5.998ms
               - ScannerThreadsVoluntaryContextSwitches: 5 (5)
               - TotalKuduScanRoundTrips: 2 (2)
               - TotalReadThroughput: 0.00 /sec
          Fragment F00:
            Instance 4044d47830c1cc98:8a63d27b00000001 (host=impala-boost-static-burst-slave-10ec.vpc.cloudera.com:22002):(Total: 35.999ms, non-child: 0.000ns, % non-child: 0.00%)
              Hdfs split stats (<volume id>:<# splits>/<split lengths>): 
               - AverageThreadTokens: 0.00 
               - BloomFilterBytes: 0
               - PeakMemoryUsage: 1.33 MB (1395376)
               - PeakReservation: 0
               - PeakUsedReservation: 0
               - PerHostPeakMemUsage: 1.33 MB (1395376)
               - RowsProduced: 90 (90)
               - TotalNetworkReceiveTime: 0.000ns
               - TotalNetworkSendTime: 999.982us
               - TotalStorageWaitTime: 29.999ms
               - TotalThreadsInvoluntaryContextSwitches: 27 (27)
               - TotalThreadsTotalWallClockTime: 56.998ms
                 - TotalThreadsSysTime: 0.000ns
                 - TotalThreadsUserTime: 9.997ms
               - TotalThreadsVoluntaryContextSwitches: 18 (18)
              Fragment Instance Lifecycle Timings:
                 - ExecTime: 13.999ms
                   - ExecTreeExecTime: 12.999ms
                 - OpenTime: 0.000ns
                   - ExecTreeOpenTime: 0.000ns
                 - PrepareTime: 21.999ms
                   - ExecTreePrepareTime: 0.000ns
              DataStreamSender (dst_id=1):
                 - BytesSent: 10.92 KB (11177)
                 - NetworkThroughput(*): 0.00 /sec
                 - OverallThroughput: 0.00 /sec
                 - PeakMemoryUsage: 688.00 B (688)
                 - RowsReturned: 90 (90)
                 - SerializeBatchTime: 0.000ns
                 - TransmitDataRPCTime: 0.000ns
                 - UncompressedRowBatchSize: 24.15 KB (24731)
              CodeGen:(Total: 20.999ms, non-child: 0.000ns, % non-child: 0.00%)
                 - CodegenTime: 0.000ns
                 - CompileTime: 0.000ns
                 - LoadTime: 0.000ns
                 - ModuleBitcodeSize: 1.86 MB (1950540)
                 - NumFunctions: 0 (0)
                 - NumInstructions: 0 (0)
                 - OptimizationTime: 0.000ns
                 - PeakMemoryUsage: 0
                 - PrepareTime: 20.999ms
              KUDU_SCAN_NODE (id=0):(Total: 12.999ms, non-child: 0.000ns, % non-child: 0.00%)
                 - BytesRead: 0
                 - CollectionItemsRead: 0 (0)
                 - KuduRemoteScanTokens: 0 (0)
                 - NumScannerThreadsStarted: 3 (3)
                 - PeakMemoryUsage: 1.32 MB (1386496)
                 - RowsRead: 12.01K (12014)
                 - RowsReturned: 90 (90)
                 - RowsReturnedRate: 6.92 K/sec
                 - ScanRangesComplete: 2 (2)
                 - ScannerThreadsInvoluntaryContextSwitches: 27 (27)
                 - ScannerThreadsTotalWallClockTime: 42.999ms
                   - MaterializeTupleTime(*): 12.999ms
                   - ScannerThreadsSysTime: 0.000ns
                   - ScannerThreadsUserTime: 8.997ms
                 - ScannerThreadsVoluntaryContextSwitches: 9 (9)
                 - TotalKuduScanRoundTrips: 3 (3)
                 - TotalReadThroughput: 0.00 /sec
            Instance 4044d47830c1cc98:8a63d27b00000002 (host=impala-boost-static-burst-slave-10ec.vpc.cloudera.com:22000):(Total: 34.999ms, non-child: 0.000ns, % non-child: 0.00%)
              Hdfs split stats (<volume id>:<# splits>/<split lengths>): 
               - AverageThreadTokens: 0.00 
               - BloomFilterBytes: 0
               - PeakMemoryUsage: 1.33 MB (1395376)
               - PeakReservation: 0
               - PeakUsedReservation: 0
               - PerHostPeakMemUsage: 1.36 MB (1428125)
               - RowsProduced: 90 (90)
               - TotalNetworkReceiveTime: 0.000ns
               - TotalNetworkSendTime: 0.000ns
               - TotalStorageWaitTime: 27.999ms
               - TotalThreadsInvoluntaryContextSwitches: 3 (3)
               - TotalThreadsTotalWallClockTime: 25.999ms
                 - TotalThreadsSysTime: 1.999ms
                 - TotalThreadsUserTime: 2.999ms
               - TotalThreadsVoluntaryContextSwitches: 13 (13)
              Fragment Instance Lifecycle Timings:
                 - ExecTime: 12.999ms
                   - ExecTreeExecTime: 10.999ms
                 - OpenTime: 999.983us
                   - ExecTreeOpenTime: 999.983us
                 - PrepareTime: 20.999ms
                   - ExecTreePrepareTime: 0.000ns
              DataStreamSender (dst_id=1):(Total: 999.983us, non-child: 0.000ns, % non-child: 0.00%)
                 - BytesSent: 11.03 KB (11292)
                 - NetworkThroughput(*): 0.00 /sec
                 - OverallThroughput: 10.77 MB/sec
                 - PeakMemoryUsage: 688.00 B (688)
                 - RowsReturned: 90 (90)
                 - SerializeBatchTime: 999.983us
                 - TransmitDataRPCTime: 0.000ns
                 - UncompressedRowBatchSize: 24.05 KB (24623)
              CodeGen:(Total: 20.999ms, non-child: 0.000ns, % non-child: 0.00%)
                 - CodegenTime: 0.000ns
                 - CompileTime: 0.000ns
                 - LoadTime: 0.000ns
                 - ModuleBitcodeSize: 1.86 MB (1950540)
                 - NumFunctions: 0 (0)
                 - NumInstructions: 0 (0)
                 - OptimizationTime: 0.000ns
                 - PeakMemoryUsage: 0
                 - PrepareTime: 18.999ms
              KUDU_SCAN_NODE (id=0):(Total: 12.999ms, non-child: 0.000ns, % non-child: 0.00%)
                 - BytesRead: 0
                 - CollectionItemsRead: 0 (0)
                 - KuduRemoteScanTokens: 0 (0)
                 - NumScannerThreadsStarted: 3 (3)
                 - PeakMemoryUsage: 1.32 MB (1386496)
                 - RowsRead: 4.00K (4000)
                 - RowsReturned: 90 (90)
                 - RowsReturnedRate: 6.92 K/sec
                 - ScanRangesComplete: 1 (1)
                 - ScannerThreadsInvoluntaryContextSwitches: 3 (3)
                 - ScannerThreadsTotalWallClockTime: 11.999ms
                   - MaterializeTupleTime(*): 10.999ms
                   - ScannerThreadsSysTime: 1.999ms
                   - ScannerThreadsUserTime: 1.999ms
                 - ScannerThreadsVoluntaryContextSwitches: 2 (2)
                 - TotalKuduScanRoundTrips: 1 (1)
                 - TotalReadThroughput: 0.00 /sec
            Instance 4044d47830c1cc98:8a63d27b00000003 (host=impala-boost-static-burst-slave-10ec.vpc.cloudera.com:22001):(Total: 31.999ms, non-child: 0.000ns, % non-child: 0.00%)
              Hdfs split stats (<volume id>:<# splits>/<split lengths>): 
               - AverageThreadTokens: 0.00 
               - BloomFilterBytes: 0
               - PeakMemoryUsage: 1.89 MB (1979056)
               - PeakReservation: 0
               - PeakUsedReservation: 0
               - PerHostPeakMemUsage: 1.89 MB (1979056)
               - RowsProduced: 90 (90)
               - TotalNetworkReceiveTime: 0.000ns
               - TotalNetworkSendTime: 1.000ns
               - TotalStorageWaitTime: 24.999ms
               - TotalThreadsInvoluntaryContextSwitches: 5 (5)
               - TotalThreadsTotalWallClockTime: 33.999ms
                 - TotalThreadsSysTime: 2.000ms
                 - TotalThreadsUserTime: 6.998ms
               - TotalThreadsVoluntaryContextSwitches: 14 (14)
              Fragment Instance Lifecycle Timings:
                 - ExecTime: 10.999ms
                   - ExecTreeExecTime: 9.999ms
                 - OpenTime: 999.984us
                   - ExecTreeOpenTime: 999.984us
                 - PrepareTime: 19.999ms
                   - ExecTreePrepareTime: 0.000ns
              DataStreamSender (dst_id=1):(Total: 1.999ms, non-child: 0.000ns, % non-child: 0.00%)
                 - BytesSent: 10.93 KB (11193)
                 - NetworkThroughput(*): 0.00 /sec
                 - OverallThroughput: 5.34 MB/sec
                 - PeakMemoryUsage: 688.00 B (688)
                 - RowsReturned: 90 (90)
                 - SerializeBatchTime: 999.982us
                 - TransmitDataRPCTime: 0.000ns
                 - UncompressedRowBatchSize: 23.98 KB (24557)
              CodeGen:(Total: 16.999ms, non-child: 0.000ns, % non-child: 0.00%)
                 - CodegenTime: 0.000ns
                 - CompileTime: 0.000ns
                 - LoadTime: 0.000ns
                 - ModuleBitcodeSize: 1.86 MB (1950540)
                 - NumFunctions: 0 (0)
                 - NumInstructions: 0 (0)
                 - OptimizationTime: 0.000ns
                 - PeakMemoryUsage: 0
                 - PrepareTime: 16.999ms
              KUDU_SCAN_NODE (id=0):(Total: 11.999ms, non-child: 0.000ns, % non-child: 0.00%)
                 - BytesRead: 0
                 - CollectionItemsRead: 0 (0)
                 - KuduRemoteScanTokens: 0 (0)
                 - NumScannerThreadsStarted: 3 (3)
                 - PeakMemoryUsage: 1.52 MB (1589248)
                 - RowsRead: 12.00K (12000)
                 - RowsReturned: 90 (90)
                 - RowsReturnedRate: 7.50 K/sec
                 - ScanRangesComplete: 2 (2)
                 - ScannerThreadsInvoluntaryContextSwitches: 2 (2)
                 - ScannerThreadsTotalWallClockTime: 21.999ms
                   - MaterializeTupleTime(*): 9.999ms
                   - ScannerThreadsSysTime: 0.000ns
                   - ScannerThreadsUserTime: 6.998ms
                 - ScannerThreadsVoluntaryContextSwitches: 5 (5)
                 - TotalKuduScanRoundTrips: 3 (3)
                 - TotalReadThroughput: 0.00 /sec
      
      

      Attachments

        Activity

          People

            twmarshall Thomas Tauber-Marshall
            tianyiwang Tianyi Wang
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: