2020-04-29T06:03:12.518000 2346d7f7d36332d2:49fccd8300000000 TRuntimeProfileTree(nodes=[TRuntimeProfileNode(info_strings_display_order=['DEBUG MODE WARNING'], indent=False, name='Query (id=2346d7f7d36332d2:49fccd8300000000)', time_series_counters=None, info_strings={'DEBUG MODE WARNING': 'Query profile created while running a DEBUG build of Impala. Use RELEASE builds to measure query performance.'}, summary_stats_counters=None, node_metadata=None, num_children=3, child_counters_map={}, event_sequences=None, counters=[TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=['Session ID', 'Session Type', 'Start Time', 'End Time', 'Query Type', 'Query State', 'Impala Query State', 'Query Status', 'Impala Version', 'User', 'Connected User', 'Delegated User', 'Network Address', 'Default Db', 'Sql Statement', 'Coordinator', 'Query Options (set by configuration)', 'Query Options (set by configuration and planner)', 'Plan', 'Estimated Per-Host Mem', 'Request Pool', 'Per Host Min Memory Reservation', 'Per Host Number of Fragment Instances', 'Admission result', 'Cluster Memory Admitted', 'Executor Group', 'ExecSummary', 'Errors'], indent=True, name='Summary', time_series_counters=None, info_strings={'Errors': 'Memory limit exceeded: Failed to allocate tuple buffer\nHDFS_SCAN_NODE (id=0) could not allocate 158.00 KB without exceeding limit.\nError occurred on backend impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22002 by fragment 2346d7f7d36332d2:49fccd8300000003\nMemory left in process limit: 11.31 GB\nMemory left in query limit: 6.39 KB\nQuery(2346d7f7d36332d2:49fccd8300000000): Limit=100.00 MB Reservation=64.00 MB ReservationLimit=68.00 MB OtherMemory=35.99 MB Total=99.99 MB Peak=99.99 MB\n Fragment 2346d7f7d36332d2:49fccd8300000003: Reservation=64.00 MB OtherMemory=35.98 MB Total=99.98 MB Peak=99.98 MB\n SORT_NODE (id=1): Total=20.22 MB Peak=20.22 MB\n HDFS_SCAN_NODE (id=0): Reservation=64.00 MB OtherMemory=15.75 MB Total=79.75 MB Peak=79.78 MB\n Queued Batches: Total=11.85 MB Peak=11.89 MB\n KrpcDataStreamSender (dst_id=2): Total=824.00 B Peak=824.00 B\n CodeGen: Total=19.01 KB Peak=1.45 MB (1 of 5 similar)', 'Admission result': 'Admitted immediately', 'Network Address': '::1:48126', 'Impala Version': 'impalad version 4.0.0-SNAPSHOT DEBUG (build f4258b5f971f90390b93aa7a2e76dd0b8a1d8825)', 'Query Options (set by configuration and planner)': "MEM_LIMIT=104857600,MT_DOP=0,DEFAULT_SPILLABLE_BUFFER_SIZE=65536,TIMEZONE=America/Los_Angeles,TOPN_BYTES_LIMIT=0,CLIENT_IDENTIFIER=query_test/test_spilling.py::TestSpillingNoDebugActionDimensions::()::test_spilling_no_debug_action[protocol:beeswax|exec_option:{'mt_dop':0;'default_spillable_buffer_size':'64k'}|table_format:parquet/none]", 'ExecSummary': '\nOperator #Hosts #Inst Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail \n-------------------------------------------------------------------------------------------------------------------------------\nF01:ROOT 1 1 0.000ns 0.000ns 0 0 \n02:MERGING-EXCHANGE 1 1 0.000ns 0.000ns 0 6.00M 0 30.69 MB UNPARTITIONED \nF00:EXCHANGE SENDER 3 3 1.333ms 1.999ms 824.00 B 0 \n01:TOP-N 3 3 124.333ms 217.999ms 0 6.00M 20.72 MB 1.29 GB \n00:SCAN HDFS 3 3 75.333ms 115.999ms 149.50K 6.00M 80.13 MB 1.25 GB tpch_parquet.lineitem', 'Request Pool': 'default-pool', 'Start Time': '2020-04-29 06:03:06.495227000', 'End Time': '2020-04-29 06:03:12.436436000', 'Per Host Min Memory Reservation': 'impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22002(40.00 MB) impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22001(40.00 MB) impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22000(40.00 MB)', 'Plan': '\n----------------\nMax Per-Host Resource Reservation: Memory=40.00MB Threads=3\nPer-Host Resource Estimates: Memory=2.57GB\nAnalyzed query: SELECT * FROM tpch_parquet.lineitem ORDER BY l_orderkey DESC\nLIMIT CAST(6000000 AS INT)\n\nF01:PLAN FRAGMENT [UNPARTITIONED] hosts=1 instances=1\n| Per-Host Resources: mem-estimate=30.69MB mem-reservation=0B thread-reservation=1\nPLAN-ROOT SINK\n| output exprs: l_orderkey, l_partkey, l_suppkey, l_linenumber, l_quantity, l_extendedprice, l_discount, l_tax, l_returnflag, l_linestatus, l_shipdate, l_commitdate, l_receiptdate, l_shipinstruct, l_shipmode, l_comment\n| mem-estimate=0B mem-reservation=0B thread-reservation=0\n|\n02:MERGING-EXCHANGE [UNPARTITIONED]\n| order by: l_orderkey DESC\n| limit: 6000000\n| mem-estimate=30.69MB mem-reservation=0B thread-reservation=0\n| tuple-ids=1 row-size=231B cardinality=6.00M\n| in pipelines: 01(GETNEXT)\n|\nF00:PLAN FRAGMENT [RANDOM] hosts=3 instances=3\nPer-Host Resources: mem-estimate=2.54GB mem-reservation=40.00MB thread-reservation=2\n01:TOP-N [LIMIT=6000000]\n| order by: l_orderkey DESC\n| mem-estimate=1.29GB mem-reservation=0B thread-reservation=0\n| tuple-ids=1 row-size=231B cardinality=6.00M\n| in pipelines: 01(GETNEXT), 00(OPEN)\n|\n00:SCAN HDFS [tpch_parquet.lineitem, RANDOM]\n HDFS partitions=1/1 files=3 size=194.00MB\n stored statistics:\n table: rows=6.00M size=194.00MB\n columns: all\n extrapolated-rows=disabled max-scan-range-rows=2.14M\n mem-estimate=1.25GB mem-reservation=40.00MB thread-reservation=1\n tuple-ids=0 row-size=231B cardinality=6.00M\n in pipelines: 00(GETNEXT)\n----------------', 'Query Type': 'QUERY', 'Connected User': 'jenkins', 'Session ID': '2340c97b9be8b1a7:53aa68d863e8febe', 'Sql Statement': 'select *\nfrom lineitem\norder by l_orderkey desc\nlimit 6000000', 'User': 'jenkins', 'Default Db': 'tpch_parquet', 'Delegated User': '', 'Query State': 'EXCEPTION', 'Per Host Number of Fragment Instances': 'impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22002(1) impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22001(1) impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22000(2)', 'Session Type': 'BEESWAX', 'Cluster Memory Admitted': '300.00 MB', 'Query Status': 'Memory limit exceeded: Error occurred on backend impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22000 by fragment 2346d7f7d36332d2:49fccd8300000002\nMemory left in process limit: 10.92 GB\nMemory left in query limit: -218.43 KB\nQuery(2346d7f7d36332d2:49fccd8300000000): memory limit exceeded. Limit=100.00 MB Reservation=64.00 MB ReservationLimit=68.00 MB OtherMemory=36.21 MB Total=100.21 MB Peak=100.21 MB\n Fragment 2346d7f7d36332d2:49fccd8300000002: Reservation=64.00 MB OtherMemory=36.18 MB Total=100.18 MB Peak=100.18 MB\n SORT_NODE (id=1): Total=20.22 MB Peak=20.22 MB\n HDFS_SCAN_NODE (id=0): Reservation=64.00 MB OtherMemory=15.96 MB Total=79.96 MB Peak=80.12 MB\n Queued Batches: Total=12.08 MB Peak=12.08 MB\n KrpcDataStreamSender (dst_id=2): Total=824.00 B Peak=824.00 B\n CodeGen: Total=19.01 KB Peak=1.45 MB\n Fragment 2346d7f7d36332d2:49fccd8300000000: Reservation=0 OtherMemory=8.00 KB Total=8.00 KB Peak=8.00 KB\n EXCHANGE_NODE (id=2): Reservation=0 OtherMemory=0 Total=0 Peak=0\n KrpcDeferredRpcs: Total=0 Peak=0\n PLAN_ROOT_SINK: Total=0 Peak=0\n CodeGen: Total=2.28 KB Peak=533.00 KB', 'Query Options (set by configuration)': "MEM_LIMIT=104857600,MT_DOP=0,DEFAULT_SPILLABLE_BUFFER_SIZE=65536,TIMEZONE=America/Los_Angeles,TOPN_BYTES_LIMIT=0,CLIENT_IDENTIFIER=query_test/test_spilling.py::TestSpillingNoDebugActionDimensions::()::test_spilling_no_debug_action[protocol:beeswax|exec_option:{'mt_dop':0;'default_spillable_buffer_size':'64k'}|table_format:parquet/none]", 'Coordinator': 'impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22000', 'Estimated Per-Host Mem': '2759024471', 'Executor Group': 'default', 'Impala Query State': 'ERROR'}, summary_stats_counters=None, node_metadata=None, num_children=1, child_counters_map={'': set(['ComputeScanRangeAssignmentTimer', 'AdmissionControlTimeSinceLastUpdate'])}, event_sequences=[TEventSequence(timestamps=[512991, 4014143, 4029512, 4683995, 4973962, 5006864, 5029351, 7215608], labels=['Metadata of all 1 tables cached', 'Analysis finished', 'Authorization finished (noop)', 'Value transfer graph computed', 'Single node plan created', 'Runtime filters computed', 'Distributed plan created', 'Planning finished'], name='Query Compilation'), TEventSequence(timestamps=[2999997, 12999985, 14999982, 21999974, 29999964, 77999907, 5934992905, 5940992898, 5954992881, 5999992827], labels=['Query submitted', 'Planning finished', 'Submit for admission', 'Completed admission', 'Ready to start on 3 backends', 'All 3 execution backends (4 fragment instances) started', 'Execution error', 'Released admission control resources', 'Rows available', 'Unregister query'], name='Query Timeline')], counters=[TCounter(value=32000000, name='AdmissionControlTimeSinceLastUpdate', unit=5), TCounter(value=1999998, name='ComputeScanRangeAssignmentTimer', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Frontend', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set([])}, event_sequences=None, counters=[TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='ImpalaServer', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['NumRowsFetched', 'RowMaterializationTimer', 'ClientFetchWaitTimer', 'NumRowsFetchedFromCache', 'RowMaterializationRate'])}, event_sequences=None, counters=[TCounter(value=0, name='ClientFetchWaitTimer', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='NumRowsFetched', unit=0), TCounter(value=0, name='NumRowsFetchedFromCache', unit=0), TCounter(value=0, name='RowMaterializationRate', unit=1), TCounter(value=0, name='RowMaterializationTimer', unit=5), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=['Number of filters', 'Filter routing table', 'Backend startup latencies', 'Slowest backend to start up', 'Per Node Peak Memory Usage', 'Per Node Bytes Read', 'Per Node User Time', 'Per Node System Time'], indent=True, name='Execution Profile 2346d7f7d36332d2:49fccd8300000000', time_series_counters=None, info_strings={'Filter routing table': '\n ID Src. Node Tgt. Node(s) Target type Partition filter Pending (Expected) First arrived Completed Enabled\n-------------------------------------------------------------------------------------------------------------------', 'Per Node Bytes Read': 'impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22002(50.61 MB) impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22001(0) impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22000(54.38 MB)', 'Per Node User Time': 'impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22002(4s690ms) impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22001(0.000ns) impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22000(5s697ms)', 'Per Node System Time': 'impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22002(52.303ms) impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22001(0.000ns) impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22000(70.721ms)', 'Per Node Peak Memory Usage': 'impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22002(100.49 MB) impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22001(41.46 MB) impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22000(100.21 MB)', 'Backend startup latencies': 'Count: 3, min / max: 26ms / 43ms, 25th %-ile: 26ms, 50th %-ile: 36ms, 75th %-ile: 36ms, 90th %-ile: 43ms, 95th %-ile: 43ms, 99.9th %-ile: 43ms', 'Slowest backend to start up': 'impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22001', 'Number of filters': '0'}, summary_stats_counters=None, node_metadata=None, num_children=5, child_counters_map={'': set(['ExchangeScanRatio', 'NumBackends', 'TotalScanBytesSent', 'TotalCpuTime', 'NumCompletedBackends', 'TotalInnerBytesSent', 'FinalizationTimer', 'FiltersReceived', 'NumFragments', 'InnerNodeSelectivityRatio', 'TotalBytesSent', 'NumFragmentInstances', 'TotalBytesRead'])}, event_sequences=None, counters=[TCounter(value=0, name='ExchangeScanRatio', unit=6), TCounter(value=0, name='FiltersReceived', unit=0), TCounter(value=0, name='FinalizationTimer', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='InnerNodeSelectivityRatio', unit=6), TCounter(value=3, name='NumBackends', unit=0), TCounter(value=2, name='NumCompletedBackends', unit=0), TCounter(value=4, name='NumFragmentInstances', unit=0), TCounter(value=2, name='NumFragments', unit=0), TCounter(value=110096717, name='TotalBytesRead', unit=3), TCounter(value=0, name='TotalBytesSent', unit=3), TCounter(value=10511085000, name='TotalCpuTime', unit=5), TCounter(value=0, name='TotalInnerBytesSent', unit=3), TCounter(value=0, name='TotalScanBytesSent', unit=3), TCounter(value=5930992909, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Per Node Profiles', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=3, child_counters_map={}, event_sequences=None, counters=[TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22002', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=2, child_counters_map={'': set(['TotalEncryptionTime', 'UncompressedScratchBytesWritten', 'AdmissionSlots', 'ScratchBytesRead', 'ScratchFileUsedBytes', 'ScratchWrites', 'BloomFilterBytes', 'ScratchReads', 'TotalReadBlockTime', 'ScratchBytesWritten'])}, event_sequences=None, counters=[TCounter(value=1, name='AdmissionSlots', unit=0), TCounter(value=0, name='BloomFilterBytes', unit=3), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='ScratchBytesRead', unit=3), TCounter(value=0, name='ScratchBytesWritten', unit=3), TCounter(value=0, name='ScratchFileUsedBytes', unit=3), TCounter(value=0, name='ScratchReads', unit=0), TCounter(value=0, name='ScratchWrites', unit=0), TCounter(value=0, name='TotalEncryptionTime', unit=5), TCounter(value=0, name='TotalReadBlockTime', unit=5), TCounter(value=0, name='TotalTime', unit=5), TCounter(value=0, name='UncompressedScratchBytesWritten', unit=3)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Buffer pool', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['ReadIoWaitTime', 'WriteIoOps', 'SystemAllocTime', 'CumulativeAllocations', 'ReadIoOps', 'ReservationLimit', 'WriteIoBytes', 'WriteIoWaitTime', 'EncryptionTime', 'PeakUnpinnedBytes', 'AllocTime', 'CompressionTime', 'ReadIoBytes', 'PeakUsedReservation', 'PeakReservation', 'CumulativeAllocationBytes'])}, event_sequences=None, counters=[TCounter(value=0, name='AllocTime', unit=5), TCounter(value=0, name='CompressionTime', unit=5), TCounter(value=0, name='CumulativeAllocationBytes', unit=3), TCounter(value=0, name='CumulativeAllocations', unit=0), TCounter(value=0, name='EncryptionTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='PeakReservation', unit=3), TCounter(value=0, name='PeakUnpinnedBytes', unit=3), TCounter(value=0, name='PeakUsedReservation', unit=3), TCounter(value=0, name='ReadIoBytes', unit=3), TCounter(value=0, name='ReadIoOps', unit=0), TCounter(value=0, name='ReadIoWaitTime', unit=5), TCounter(value=0, name='ReservationLimit', unit=3), TCounter(value=0, name='SystemAllocTime', unit=5), TCounter(value=0, name='TotalTime', unit=5), TCounter(value=0, name='WriteIoBytes', unit=3), TCounter(value=0, name='WriteIoOps', unit=0), TCounter(value=0, name='WriteIoWaitTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Fragment F00', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=1, child_counters_map={}, event_sequences=None, counters=[TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='CodeGen', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['IrGenerationTime', 'OptimizationTime', 'LoadTime', 'CodegenInvoluntaryContextSwitches', 'CompileTime', 'NumInstructions', 'PeakMemoryUsage', 'ModuleBitcodeSize', 'CodegenVoluntaryContextSwitches', 'CodegenTotalWallClockTime', 'NumFunctions', 'PrepareTime']), 'CodegenTotalWallClockTime': set(['CodegenSysTime', 'CodegenUserTime'])}, event_sequences=None, counters=[TCounter(value=413, name='CodegenInvoluntaryContextSwitches', unit=0), TCounter(value=984000, name='CodegenSysTime', unit=5), TCounter(value=4622994474, name='CodegenTotalWallClockTime', unit=5), TCounter(value=4431656000, name='CodegenUserTime', unit=5), TCounter(value=0, name='CodegenVoluntaryContextSwitches', unit=0), TCounter(value=177999788, name='CompileTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=59999928, name='IrGenerationTime', unit=5), TCounter(value=0, name='LoadTime', unit=5), TCounter(value=2651572, name='ModuleBitcodeSize', unit=3), TCounter(value=82, name='NumFunctions', unit=0), TCounter(value=2976, name='NumInstructions', unit=0), TCounter(value=4059995146, name='OptimizationTime', unit=5), TCounter(value=1523712, name='PeakMemoryUsage', unit=3), TCounter(value=314999624, name='PrepareTime', unit=5), TCounter(value=4622994474, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22001', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=2, child_counters_map={'': set(['TotalEncryptionTime', 'UncompressedScratchBytesWritten', 'AdmissionSlots', 'ScratchBytesRead', 'ScratchFileUsedBytes', 'ScratchWrites', 'BloomFilterBytes', 'ScratchReads', 'TotalReadBlockTime', 'ScratchBytesWritten'])}, event_sequences=None, counters=[TCounter(value=1, name='AdmissionSlots', unit=0), TCounter(value=0, name='BloomFilterBytes', unit=3), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='ScratchBytesRead', unit=3), TCounter(value=0, name='ScratchBytesWritten', unit=3), TCounter(value=0, name='ScratchFileUsedBytes', unit=3), TCounter(value=0, name='ScratchReads', unit=0), TCounter(value=0, name='ScratchWrites', unit=0), TCounter(value=0, name='TotalEncryptionTime', unit=5), TCounter(value=0, name='TotalReadBlockTime', unit=5), TCounter(value=0, name='TotalTime', unit=5), TCounter(value=0, name='UncompressedScratchBytesWritten', unit=3)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Buffer pool', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['ReadIoWaitTime', 'WriteIoOps', 'SystemAllocTime', 'CumulativeAllocations', 'ReadIoOps', 'ReservationLimit', 'WriteIoBytes', 'WriteIoWaitTime', 'EncryptionTime', 'PeakUnpinnedBytes', 'AllocTime', 'CompressionTime', 'ReadIoBytes', 'PeakUsedReservation', 'PeakReservation', 'CumulativeAllocationBytes'])}, event_sequences=None, counters=[TCounter(value=0, name='AllocTime', unit=5), TCounter(value=0, name='CompressionTime', unit=5), TCounter(value=0, name='CumulativeAllocationBytes', unit=3), TCounter(value=0, name='CumulativeAllocations', unit=0), TCounter(value=0, name='EncryptionTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='PeakReservation', unit=3), TCounter(value=0, name='PeakUnpinnedBytes', unit=3), TCounter(value=0, name='PeakUsedReservation', unit=3), TCounter(value=0, name='ReadIoBytes', unit=3), TCounter(value=0, name='ReadIoOps', unit=0), TCounter(value=0, name='ReadIoWaitTime', unit=5), TCounter(value=0, name='ReservationLimit', unit=3), TCounter(value=0, name='SystemAllocTime', unit=5), TCounter(value=0, name='TotalTime', unit=5), TCounter(value=0, name='WriteIoBytes', unit=3), TCounter(value=0, name='WriteIoOps', unit=0), TCounter(value=0, name='WriteIoWaitTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Fragment F00', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=1, child_counters_map={}, event_sequences=None, counters=[TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='CodeGen', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['IrGenerationTime', 'OptimizationTime', 'LoadTime', 'CodegenInvoluntaryContextSwitches', 'CompileTime', 'NumInstructions', 'PeakMemoryUsage', 'ModuleBitcodeSize', 'CodegenVoluntaryContextSwitches', 'CodegenTotalWallClockTime', 'NumFunctions', 'PrepareTime']), 'CodegenTotalWallClockTime': set(['CodegenSysTime', 'CodegenUserTime'])}, event_sequences=None, counters=[TCounter(value=104, name='CodegenInvoluntaryContextSwitches', unit=0), TCounter(value=985000, name='CodegenSysTime', unit=5), TCounter(value=629999247, name='CodegenTotalWallClockTime', unit=5), TCounter(value=500459000, name='CodegenUserTime', unit=5), TCounter(value=0, name='CodegenVoluntaryContextSwitches', unit=0), TCounter(value=0, name='CompileTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=78999906, name='IrGenerationTime', unit=5), TCounter(value=0, name='LoadTime', unit=5), TCounter(value=2651572, name='ModuleBitcodeSize', unit=3), TCounter(value=82, name='NumFunctions', unit=0), TCounter(value=2976, name='NumInstructions', unit=0), TCounter(value=0, name='OptimizationTime', unit=5), TCounter(value=1523712, name='PeakMemoryUsage', unit=3), TCounter(value=550999341, name='PrepareTime', unit=5), TCounter(value=629999247, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22000', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=3, child_counters_map={'': set(['TotalEncryptionTime', 'UncompressedScratchBytesWritten', 'AdmissionSlots', 'ScratchBytesRead', 'ScratchFileUsedBytes', 'ScratchWrites', 'BloomFilterBytes', 'ScratchReads', 'TotalReadBlockTime', 'ScratchBytesWritten'])}, event_sequences=None, counters=[TCounter(value=1, name='AdmissionSlots', unit=0), TCounter(value=0, name='BloomFilterBytes', unit=3), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='ScratchBytesRead', unit=3), TCounter(value=0, name='ScratchBytesWritten', unit=3), TCounter(value=0, name='ScratchFileUsedBytes', unit=3), TCounter(value=0, name='ScratchReads', unit=0), TCounter(value=0, name='ScratchWrites', unit=0), TCounter(value=0, name='TotalEncryptionTime', unit=5), TCounter(value=0, name='TotalReadBlockTime', unit=5), TCounter(value=0, name='TotalTime', unit=5), TCounter(value=0, name='UncompressedScratchBytesWritten', unit=3)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Buffer pool', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['ReadIoWaitTime', 'WriteIoOps', 'SystemAllocTime', 'CumulativeAllocations', 'ReadIoOps', 'ReservationLimit', 'WriteIoBytes', 'WriteIoWaitTime', 'EncryptionTime', 'PeakUnpinnedBytes', 'AllocTime', 'CompressionTime', 'ReadIoBytes', 'PeakUsedReservation', 'PeakReservation', 'CumulativeAllocationBytes'])}, event_sequences=None, counters=[TCounter(value=0, name='AllocTime', unit=5), TCounter(value=0, name='CompressionTime', unit=5), TCounter(value=0, name='CumulativeAllocationBytes', unit=3), TCounter(value=0, name='CumulativeAllocations', unit=0), TCounter(value=0, name='EncryptionTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='PeakReservation', unit=3), TCounter(value=0, name='PeakUnpinnedBytes', unit=3), TCounter(value=0, name='PeakUsedReservation', unit=3), TCounter(value=0, name='ReadIoBytes', unit=3), TCounter(value=0, name='ReadIoOps', unit=0), TCounter(value=0, name='ReadIoWaitTime', unit=5), TCounter(value=0, name='ReservationLimit', unit=3), TCounter(value=0, name='SystemAllocTime', unit=5), TCounter(value=0, name='TotalTime', unit=5), TCounter(value=0, name='WriteIoBytes', unit=3), TCounter(value=0, name='WriteIoOps', unit=0), TCounter(value=0, name='WriteIoWaitTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Fragment F01', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=1, child_counters_map={}, event_sequences=None, counters=[TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='CodeGen', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['IrGenerationTime', 'OptimizationTime', 'LoadTime', 'CodegenInvoluntaryContextSwitches', 'CompileTime', 'NumInstructions', 'PeakMemoryUsage', 'ModuleBitcodeSize', 'CodegenVoluntaryContextSwitches', 'CodegenTotalWallClockTime', 'NumFunctions', 'PrepareTime']), 'CodegenTotalWallClockTime': set(['CodegenSysTime', 'CodegenUserTime'])}, event_sequences=None, counters=[TCounter(value=331, name='CodegenInvoluntaryContextSwitches', unit=0), TCounter(value=1985000, name='CodegenSysTime', unit=5), TCounter(value=2242997318, name='CodegenTotalWallClockTime', unit=5), TCounter(value=2123178000, name='CodegenUserTime', unit=5), TCounter(value=0, name='CodegenVoluntaryContextSwitches', unit=0), TCounter(value=100999879, name='CompileTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=31999962, name='IrGenerationTime', unit=5), TCounter(value=0, name='LoadTime', unit=5), TCounter(value=2651572, name='ModuleBitcodeSize', unit=3), TCounter(value=37, name='NumFunctions', unit=0), TCounter(value=1066, name='NumInstructions', unit=0), TCounter(value=1668998005, name='OptimizationTime', unit=5), TCounter(value=545792, name='PeakMemoryUsage', unit=3), TCounter(value=431999483, name='PrepareTime', unit=5), TCounter(value=2242997318, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Fragment F00', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=1, child_counters_map={}, event_sequences=None, counters=[TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='CodeGen', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['IrGenerationTime', 'OptimizationTime', 'LoadTime', 'CodegenInvoluntaryContextSwitches', 'CompileTime', 'NumInstructions', 'PeakMemoryUsage', 'ModuleBitcodeSize', 'CodegenVoluntaryContextSwitches', 'CodegenTotalWallClockTime', 'NumFunctions', 'PrepareTime']), 'CodegenTotalWallClockTime': set(['CodegenSysTime', 'CodegenUserTime'])}, event_sequences=None, counters=[TCounter(value=376, name='CodegenInvoluntaryContextSwitches', unit=0), TCounter(value=1993000, name='CodegenSysTime', unit=5), TCounter(value=5529993389, name='CodegenTotalWallClockTime', unit=5), TCounter(value=5424579000, name='CodegenUserTime', unit=5), TCounter(value=0, name='CodegenVoluntaryContextSwitches', unit=0), TCounter(value=208999750, name='CompileTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=87999894, name='IrGenerationTime', unit=5), TCounter(value=0, name='LoadTime', unit=5), TCounter(value=2651572, name='ModuleBitcodeSize', unit=3), TCounter(value=82, name='NumFunctions', unit=0), TCounter(value=2976, name='NumInstructions', unit=0), TCounter(value=4857994192, name='OptimizationTime', unit=5), TCounter(value=1523712, name='PeakMemoryUsage', unit=3), TCounter(value=365999563, name='PrepareTime', unit=5), TCounter(value=5529993389, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=['split sizes', 'completion times', 'execution rates', 'num instances'], indent=True, name='Averaged Fragment F01', time_series_counters=None, info_strings={'completion times': 'min:5s880ms max:5s880ms mean: 5s880ms stddev:0.000ns', 'split sizes': ' min: 0, max: 0, avg: 0, stddev: 0', 'execution rates': 'min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec', 'num instances': '1'}, summary_stats_counters=None, node_metadata=None, num_children=3, child_counters_map={'': set(['ExchangeScanRatio', 'TotalNetworkSendTime', 'PerHostPeakMemUsage', 'AverageThreadTokens', 'PeakMemoryUsage', 'TotalStorageWaitTime', 'TotalThreadsInvoluntaryContextSwitches', 'TotalThreadsTotalWallClockTime', 'RowsProduced', 'TotalThreadsVoluntaryContextSwitches', 'TotalNetworkReceiveTime', 'PeakReservation', 'PeakUsedReservation']), 'TotalThreadsTotalWallClockTime': set(['TotalThreadsUserTime', 'TotalThreadsSysTime'])}, event_sequences=None, counters=[TCounter(value=0, name='AverageThreadTokens', unit=6), TCounter(value=0, name='ExchangeScanRatio', unit=6), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=8192, name='PeakMemoryUsage', unit=3), TCounter(value=0, name='PeakReservation', unit=3), TCounter(value=0, name='PeakUsedReservation', unit=3), TCounter(value=105081271, name='PerHostPeakMemUsage', unit=3), TCounter(value=0, name='RowsProduced', unit=0), TCounter(value=0, name='TotalNetworkReceiveTime', unit=5), TCounter(value=0, name='TotalNetworkSendTime', unit=5), TCounter(value=0, name='TotalStorageWaitTime', unit=5), TCounter(value=0, name='TotalThreadsInvoluntaryContextSwitches', unit=0), TCounter(value=0, name='TotalThreadsSysTime', unit=5), TCounter(value=0, name='TotalThreadsTotalWallClockTime', unit=5), TCounter(value=0, name='TotalThreadsUserTime', unit=5), TCounter(value=0, name='TotalThreadsVoluntaryContextSwitches', unit=0), TCounter(value=8999989, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Fragment Instance Lifecycle Timings', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['OpenTime', 'PrepareTime']), 'OpenTime': set(['ExecTreeOpenTime']), 'PrepareTime': set(['ExecTreePrepareTime'])}, event_sequences=None, counters=[TCounter(value=0, name='ExecTreeOpenTime', unit=5), TCounter(value=4999994, name='ExecTreePrepareTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='OpenTime', unit=5), TCounter(value=6999992, name='PrepareTime', unit=5), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='PLAN_ROOT_SINK', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=TRuntimeProfileNodeMetadata(data_sink_id=0, plan_node_id=None), num_children=0, child_counters_map={'': set(['RowsSentRate', 'RowsSent', 'PeakMemoryUsage'])}, event_sequences=None, counters=[TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='PeakMemoryUsage', unit=3), TCounter(value=0, name='RowsSent', unit=0), TCounter(value=0, name='RowsSentRate', unit=1), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='EXCHANGE_NODE (id=2)', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=TRuntimeProfileNodeMetadata(data_sink_id=None, plan_node_id=2), num_children=3, child_counters_map={'': set(['ConvertRowBatchTime', 'PeakMemoryUsage', 'RowsReturnedRate', 'RowsReturned', 'MergeGetNextBatch', 'MergeGetNext'])}, event_sequences=None, counters=[TCounter(value=0, name='ConvertRowBatchTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='MergeGetNext', unit=5), TCounter(value=0, name='MergeGetNextBatch', unit=5), TCounter(value=0, name='PeakMemoryUsage', unit=3), TCounter(value=0, name='RowsReturned', unit=0), TCounter(value=0, name='RowsReturnedRate', unit=1), TCounter(value=0, name='TotalTime', unit=5)], metadata=2), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Buffer pool', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['ReadIoWaitTime', 'WriteIoOps', 'SystemAllocTime', 'CumulativeAllocations', 'ReadIoOps', 'WriteIoBytes', 'WriteIoWaitTime', 'EncryptionTime', 'PeakUnpinnedBytes', 'AllocTime', 'CompressionTime', 'ReadIoBytes', 'PeakUsedReservation', 'PeakReservation', 'CumulativeAllocationBytes'])}, event_sequences=None, counters=[TCounter(value=0, name='AllocTime', unit=5), TCounter(value=0, name='CompressionTime', unit=5), TCounter(value=0, name='CumulativeAllocationBytes', unit=3), TCounter(value=0, name='CumulativeAllocations', unit=0), TCounter(value=0, name='EncryptionTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='PeakReservation', unit=3), TCounter(value=0, name='PeakUnpinnedBytes', unit=3), TCounter(value=0, name='PeakUsedReservation', unit=3), TCounter(value=0, name='ReadIoBytes', unit=3), TCounter(value=0, name='ReadIoOps', unit=0), TCounter(value=0, name='ReadIoWaitTime', unit=5), TCounter(value=0, name='SystemAllocTime', unit=5), TCounter(value=0, name='TotalTime', unit=5), TCounter(value=0, name='WriteIoBytes', unit=3), TCounter(value=0, name='WriteIoOps', unit=0), TCounter(value=0, name='WriteIoWaitTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Dequeue', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['FirstBatchWaitTime', 'TotalGetBatchTime', 'TotalBytesDequeued']), 'TotalGetBatchTime': set(['DataWaitTime'])}, event_sequences=None, counters=[TCounter(value=0, name='DataWaitTime', unit=5), TCounter(value=0, name='FirstBatchWaitTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='TotalBytesDequeued', unit=3), TCounter(value=0, name='TotalGetBatchTime', unit=5), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Enqueue', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['TotalBatchesEnqueued', 'TotalHasDeferredRPCsTime', 'TotalEosReceived', 'DeserializeRowBatchTime', 'TotalRPCsDeferred', 'TotalBytesReceived', 'TotalEarlySenders', 'TotalBatchesReceived'])}, event_sequences=None, counters=[TCounter(value=0, name='DeserializeRowBatchTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='TotalBatchesEnqueued', unit=0), TCounter(value=0, name='TotalBatchesReceived', unit=0), TCounter(value=0, name='TotalBytesReceived', unit=3), TCounter(value=0, name='TotalEarlySenders', unit=0), TCounter(value=0, name='TotalEosReceived', unit=0), TCounter(value=0, name='TotalHasDeferredRPCsTime', unit=5), TCounter(value=0, name='TotalRPCsDeferred', unit=0), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Coordinator Fragment F01', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=1, child_counters_map={}, event_sequences=None, counters=[TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=['Last report received time'], indent=True, name='Instance 2346d7f7d36332d2:49fccd8300000000 (host=impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22000)', time_series_counters=[TTimeSeriesCounter(start_index=0, values=[8192, 8192, 8192, 8192, 8192, 8192, 8192, 8192, 8192, 8192, 8192, 8192], name='MemoryUsage', unit=3, period_ms=500), TTimeSeriesCounter(start_index=0, values=[], name='ThreadUsage', unit=0, period_ms=500)], info_strings={'Last report received time': '2020-04-29 06:03:12.426'}, summary_stats_counters=None, node_metadata=None, num_children=3, child_counters_map={'': set(['ExchangeScanRatio', 'TotalNetworkSendTime', 'PerHostPeakMemUsage', 'AverageThreadTokens', 'PeakMemoryUsage', 'TotalStorageWaitTime', 'TotalThreadsInvoluntaryContextSwitches', 'TotalThreadsTotalWallClockTime', 'RowsProduced', 'TotalThreadsVoluntaryContextSwitches', 'TotalNetworkReceiveTime', 'PeakReservation', 'PeakUsedReservation']), 'TotalThreadsTotalWallClockTime': set(['TotalThreadsUserTime', 'TotalThreadsSysTime'])}, event_sequences=[TEventSequence(timestamps=[26999968], labels=['Prepare Finished'], name='Fragment Instance Lifecycle Event Timeline')], counters=[TCounter(value=0, name='AverageThreadTokens', unit=6), TCounter(value=0, name='ExchangeScanRatio', unit=6), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=8192, name='PeakMemoryUsage', unit=3), TCounter(value=0, name='PeakReservation', unit=3), TCounter(value=0, name='PeakUsedReservation', unit=3), TCounter(value=105081271, name='PerHostPeakMemUsage', unit=3), TCounter(value=0, name='RowsProduced', unit=0), TCounter(value=0, name='TotalNetworkReceiveTime', unit=5), TCounter(value=0, name='TotalNetworkSendTime', unit=5), TCounter(value=0, name='TotalStorageWaitTime', unit=5), TCounter(value=0, name='TotalThreadsInvoluntaryContextSwitches', unit=0), TCounter(value=0, name='TotalThreadsSysTime', unit=5), TCounter(value=0, name='TotalThreadsTotalWallClockTime', unit=5), TCounter(value=0, name='TotalThreadsUserTime', unit=5), TCounter(value=0, name='TotalThreadsVoluntaryContextSwitches', unit=0), TCounter(value=8999989, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Fragment Instance Lifecycle Timings', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['OpenTime', 'PrepareTime']), 'OpenTime': set(['ExecTreeOpenTime']), 'PrepareTime': set(['ExecTreePrepareTime'])}, event_sequences=None, counters=[TCounter(value=0, name='ExecTreeOpenTime', unit=5), TCounter(value=4999994, name='ExecTreePrepareTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='OpenTime', unit=5), TCounter(value=6999992, name='PrepareTime', unit=5), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='PLAN_ROOT_SINK', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=TRuntimeProfileNodeMetadata(data_sink_id=0, plan_node_id=None), num_children=0, child_counters_map={'': set(['RowsSentRate', 'RowsSent', 'PeakMemoryUsage'])}, event_sequences=None, counters=[TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='PeakMemoryUsage', unit=3), TCounter(value=0, name='RowsSent', unit=0), TCounter(value=0, name='RowsSentRate', unit=1), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=['ExecOption'], indent=True, name='EXCHANGE_NODE (id=2)', time_series_counters=None, info_strings={'ExecOption': 'Codegen Enabled'}, summary_stats_counters=None, node_metadata=TRuntimeProfileNodeMetadata(data_sink_id=None, plan_node_id=2), num_children=3, child_counters_map={'': set(['ConvertRowBatchTime', 'PeakMemoryUsage', 'RowsReturnedRate', 'RowsReturned', 'MergeGetNextBatch', 'MergeGetNext'])}, event_sequences=[TEventSequence(timestamps=[2271997284], labels=['Open Started'], name='Node Lifecycle Event Timeline')], counters=[TCounter(value=0, name='ConvertRowBatchTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='MergeGetNext', unit=5), TCounter(value=0, name='MergeGetNextBatch', unit=5), TCounter(value=0, name='PeakMemoryUsage', unit=3), TCounter(value=0, name='RowsReturned', unit=0), TCounter(value=0, name='RowsReturnedRate', unit=1), TCounter(value=0, name='TotalTime', unit=5)], metadata=2), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Buffer pool', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['ReadIoWaitTime', 'WriteIoOps', 'SystemAllocTime', 'CumulativeAllocations', 'ReadIoOps', 'WriteIoBytes', 'WriteIoWaitTime', 'EncryptionTime', 'PeakUnpinnedBytes', 'AllocTime', 'CompressionTime', 'ReadIoBytes', 'PeakUsedReservation', 'PeakReservation', 'CumulativeAllocationBytes'])}, event_sequences=None, counters=[TCounter(value=0, name='AllocTime', unit=5), TCounter(value=0, name='CompressionTime', unit=5), TCounter(value=0, name='CumulativeAllocationBytes', unit=3), TCounter(value=0, name='CumulativeAllocations', unit=0), TCounter(value=0, name='EncryptionTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='PeakReservation', unit=3), TCounter(value=0, name='PeakUnpinnedBytes', unit=3), TCounter(value=0, name='PeakUsedReservation', unit=3), TCounter(value=0, name='ReadIoBytes', unit=3), TCounter(value=0, name='ReadIoOps', unit=0), TCounter(value=0, name='ReadIoWaitTime', unit=5), TCounter(value=0, name='SystemAllocTime', unit=5), TCounter(value=0, name='TotalTime', unit=5), TCounter(value=0, name='WriteIoBytes', unit=3), TCounter(value=0, name='WriteIoOps', unit=0), TCounter(value=0, name='WriteIoWaitTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Dequeue', time_series_counters=[TTimeSeriesCounter(start_index=0, values=[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], name='BytesDequeued', unit=3, period_ms=500)], info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['FirstBatchWaitTime', 'TotalGetBatchTime', 'TotalBytesDequeued']), 'TotalGetBatchTime': set(['DataWaitTime'])}, event_sequences=None, counters=[TCounter(value=0, name='DataWaitTime', unit=5), TCounter(value=0, name='FirstBatchWaitTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='TotalBytesDequeued', unit=3), TCounter(value=0, name='TotalGetBatchTime', unit=5), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Enqueue', time_series_counters=[TTimeSeriesCounter(start_index=0, values=[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], name='BytesReceived', unit=3, period_ms=500), TTimeSeriesCounter(start_index=0, values=[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], name='DeferredQueueSize', unit=0, period_ms=500)], info_strings={}, summary_stats_counters=[TSummaryStatsCounter(total_num_values=0, name='DispatchTime', max_value=-9223372036854775808L, sum=0, min_value=9223372036854775807L, unit=5)], node_metadata=None, num_children=0, child_counters_map={'': set(['TotalBatchesEnqueued', 'TotalHasDeferredRPCsTime', 'TotalEosReceived', 'DeserializeRowBatchTime', 'TotalRPCsDeferred', 'TotalBytesReceived', 'TotalEarlySenders', 'TotalBatchesReceived'])}, event_sequences=None, counters=[TCounter(value=0, name='DeserializeRowBatchTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='TotalBatchesEnqueued', unit=0), TCounter(value=0, name='TotalBatchesReceived', unit=0), TCounter(value=0, name='TotalBytesReceived', unit=3), TCounter(value=0, name='TotalEarlySenders', unit=0), TCounter(value=0, name='TotalEosReceived', unit=0), TCounter(value=0, name='TotalHasDeferredRPCsTime', unit=5), TCounter(value=0, name='TotalRPCsDeferred', unit=0), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=['split sizes', 'completion times', 'execution rates', 'num instances'], indent=True, name='Averaged Fragment F00', time_series_counters=None, info_strings={'completion times': 'min:5s048ms max:5s867ms mean: 5s594ms stddev:385.609ms', 'split sizes': ' min: 55.81 MB, max: 69.24 MB, avg: 64.67 MB, stddev: 6.26 MB', 'execution rates': 'min:11.05 MB/sec max:11.80 MB/sec mean:11.54 MB/sec stddev:349.91 KB/sec', 'num instances': '3'}, summary_stats_counters=None, node_metadata=None, num_children=3, child_counters_map={'': set(['ExchangeScanRatio', 'TotalNetworkSendTime', 'PerHostPeakMemUsage', 'AverageThreadTokens', 'PeakMemoryUsage', 'TotalStorageWaitTime', 'TotalThreadsInvoluntaryContextSwitches', 'TotalThreadsTotalWallClockTime', 'RowsProduced', 'TotalThreadsVoluntaryContextSwitches', 'TotalNetworkReceiveTime', 'PeakReservation', 'PeakUsedReservation']), 'TotalThreadsTotalWallClockTime': set(['TotalThreadsUserTime', 'TotalThreadsSysTime'])}, event_sequences=None, counters=[TCounter(value=4607182418800017408, name='AverageThreadTokens', unit=6), TCounter(value=0, name='ExchangeScanRatio', unit=6), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=70138721, name='PeakMemoryUsage', unit=3), TCounter(value=44739242, name='PeakReservation', unit=3), TCounter(value=0, name='PeakUsedReservation', unit=3), TCounter(value=84644126, name='PerHostPeakMemUsage', unit=3), TCounter(value=0, name='RowsProduced', unit=0), TCounter(value=0, name='TotalNetworkReceiveTime', unit=5), TCounter(value=0, name='TotalNetworkSendTime', unit=5), TCounter(value=10333321, name='TotalStorageWaitTime', unit=5), TCounter(value=269, name='TotalThreadsInvoluntaryContextSwitches', unit=0), TCounter(value=41008000, name='TotalThreadsSysTime', unit=5), TCounter(value=3789995469, name='TotalThreadsTotalWallClockTime', unit=5), TCounter(value=3462687000, name='TotalThreadsUserTime', unit=5), TCounter(value=180, name='TotalThreadsVoluntaryContextSwitches', unit=0), TCounter(value=3589329042, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Fragment Instance Lifecycle Timings', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['OpenTime', 'PrepareTime']), 'OpenTime': set(['ExecTreeOpenTime']), 'PrepareTime': set(['ExecTreePrepareTime'])}, event_sequences=None, counters=[TCounter(value=289999653, name='ExecTreeOpenTime', unit=5), TCounter(value=4999994, name='ExecTreePrepareTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=3578995721, name='OpenTime', unit=5), TCounter(value=8666656, name='PrepareTime', unit=5), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='KrpcDataStreamSender (dst_id=2)', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=TRuntimeProfileNodeMetadata(data_sink_id=1, plan_node_id=None), num_children=0, child_counters_map={'': set(['SerializeBatchTime', 'UncompressedRowBatchSize', 'RpcFailure', 'PeakMemoryUsage', 'RpcRetry', 'EosSent', 'TotalBytesSent', 'RowsSent'])}, event_sequences=None, counters=[TCounter(value=0, name='EosSent', unit=0), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=824, name='PeakMemoryUsage', unit=3), TCounter(value=0, name='RowsSent', unit=0), TCounter(value=0, name='RpcFailure', unit=0), TCounter(value=0, name='RpcRetry', unit=0), TCounter(value=0, name='SerializeBatchTime', unit=5), TCounter(value=0, name='TotalBytesSent', unit=3), TCounter(value=1333331, name='TotalTime', unit=5), TCounter(value=0, name='UncompressedRowBatchSize', unit=3)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='SORT_NODE (id=1)', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=TRuntimeProfileNodeMetadata(data_sink_id=None, plan_node_id=1), num_children=1, child_counters_map={'': set(['InsertBatchTime', 'RowsReturnedRate', 'RowsReturned', 'PeakMemoryUsage', 'TuplePoolReclamations'])}, event_sequences=None, counters=[TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=119666523, name='InsertBatchTime', unit=5), TCounter(value=14310052, name='PeakMemoryUsage', unit=3), TCounter(value=0, name='RowsReturned', unit=0), TCounter(value=0, name='RowsReturnedRate', unit=1), TCounter(value=198333096, name='TotalTime', unit=5), TCounter(value=0, name='TuplePoolReclamations', unit=0)], metadata=1), TRuntimeProfileNode(info_strings_display_order=[], indent=False, name='HDFS_SCAN_NODE (id=0)', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=TRuntimeProfileNodeMetadata(data_sink_id=None, plan_node_id=0), num_children=1, child_counters_map={'': set(['CachedFileHandlesHitCount', 'NumPages', 'PeakScannerThreadConcurrency', 'RemoteScanRanges', 'ScanRangesComplete', 'NumStatsFilteredRowGroups', 'ScannerThreadWorklessLoops', 'RowsReturned', 'ScannerIoWaitTime', 'TotalReadThroughput', 'NumRowGroupsWithPageIndex', 'CachedFileHandlesMissCount', 'NumColumns', 'ScannerThreadsInvoluntaryContextSwitches', 'NumDisksAccessed', 'DataCacheMissBytes', 'RowBatchQueueGetWaitTime', 'RowsReturnedRate', 'RowBatchesEnqueued', 'MaterializeTupleTime', 'ScannerThreadsTotalWallClockTime', 'CollectionItemsRead', 'NumScannersWithNoReads', 'NumScannerThreadMemUnavailable', 'NumStatsFilteredPages', 'TotalRawHdfsOpenFileTime', 'NumDictFilteredRowGroups', 'AverageHdfsReadThreadConcurrency', 'NumScannerThreadReservationsDenied', 'ScannerThreadsVoluntaryContextSwitches', 'TotalRawHdfsReadTime', 'AverageScannerThreadConcurrency', 'RowBatchBytesEnqueued', 'DataCacheHitCount', 'NumScannerThreadsStarted', 'DataCachePartialHitCount', 'DataCacheHitBytes', 'BytesReadLocal', 'DecompressionTime', 'NumRowGroups', 'DataCacheMissCount', 'BytesReadRemoteUnexpected', 'MaxCompressedTextFileLength', 'PeakMemoryUsage', 'RowBatchQueuePutWaitTime', 'PerReadThreadRawHdfsThroughput', 'RowBatchQueuePeakMemoryUsage', 'BytesReadShortCircuit', 'RowsRead', 'BytesRead', 'BytesReadDataNodeCache']), 'ScannerThreadsTotalWallClockTime': set(['ScannerThreadsUserTime', 'ScannerThreadsSysTime'])}, event_sequences=None, counters=[TCounter(value=0, name='AverageHdfsReadThreadConcurrency', unit=6), TCounter(value=4607182418800017408, name='AverageScannerThreadConcurrency', unit=6), TCounter(value=36698905, name='BytesRead', unit=3), TCounter(value=0, name='BytesReadDataNodeCache', unit=3), TCounter(value=55048358, name='BytesReadLocal', unit=3), TCounter(value=0, name='BytesReadRemoteUnexpected', unit=3), TCounter(value=55048358, name='BytesReadShortCircuit', unit=3), TCounter(value=18, name='CachedFileHandlesHitCount', unit=0), TCounter(value=0, name='CachedFileHandlesMissCount', unit=0), TCounter(value=0, name='CollectionItemsRead', unit=0), TCounter(value=0, name='DataCacheHitBytes', unit=3), TCounter(value=0, name='DataCacheHitCount', unit=0), TCounter(value=0, name='DataCacheMissBytes', unit=3), TCounter(value=0, name='DataCacheMissCount', unit=0), TCounter(value=0, name='DataCachePartialHitCount', unit=0), TCounter(value=9499990, name='DecompressionTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=91666556, name='MaterializeTupleTime', unit=5), TCounter(value=0, name='MaxCompressedTextFileLength', unit=3), TCounter(value=16, name='NumColumns', unit=0), TCounter(value=0, name='NumDictFilteredRowGroups', unit=0), TCounter(value=1, name='NumDisksAccessed', unit=0), TCounter(value=103, name='NumPages', unit=0), TCounter(value=1, name='NumRowGroups', unit=0), TCounter(value=1, name='NumRowGroupsWithPageIndex', unit=0), TCounter(value=0, name='NumScannerThreadMemUnavailable', unit=0), TCounter(value=0, name='NumScannerThreadReservationsDenied', unit=0), TCounter(value=0, name='NumScannerThreadsStarted', unit=0), TCounter(value=0, name='NumScannersWithNoReads', unit=0), TCounter(value=0, name='NumStatsFilteredPages', unit=0), TCounter(value=0, name='NumStatsFilteredRowGroups', unit=0), TCounter(value=55889338, name='PeakMemoryUsage', unit=3), TCounter(value=1, name='PeakScannerThreadConcurrency', unit=0), TCounter(value=230657681, name='PerReadThreadRawHdfsThroughput', unit=4), TCounter(value=0, name='RemoteScanRanges', unit=0), TCounter(value=18073849, name='RowBatchBytesEnqueued', unit=3), TCounter(value=60999927, name='RowBatchQueueGetWaitTime', unit=5), TCounter(value=9678769, name='RowBatchQueuePeakMemoryUsage', unit=3), TCounter(value=29333298, name='RowBatchQueuePutWaitTime', unit=5), TCounter(value=90, name='RowBatchesEnqueued', unit=0), TCounter(value=91136, name='RowsRead', unit=0), TCounter(value=49834, name='RowsReturned', unit=0), TCounter(value=461074, name='RowsReturnedRate', unit=1), TCounter(value=1, name='ScanRangesComplete', unit=0), TCounter(value=15499981, name='ScannerIoWaitTime', unit=5), TCounter(value=0, name='ScannerThreadWorklessLoops', unit=0), TCounter(value=4, name='ScannerThreadsInvoluntaryContextSwitches', unit=0), TCounter(value=23832000, name='ScannerThreadsSysTime', unit=5), TCounter(value=210999747, name='ScannerThreadsTotalWallClockTime', unit=5), TCounter(value=109106666, name='ScannerThreadsUserTime', unit=5), TCounter(value=130, name='ScannerThreadsVoluntaryContextSwitches', unit=0), TCounter(value=0, name='TotalRawHdfsOpenFileTime', unit=5), TCounter(value=256499692, name='TotalRawHdfsReadTime', unit=5), TCounter(value=6684376, name='TotalReadThroughput', unit=4), TCounter(value=75333244, name='TotalTime', unit=5)], metadata=0), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Buffer pool', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['ReadIoWaitTime', 'WriteIoOps', 'SystemAllocTime', 'CumulativeAllocations', 'ReadIoOps', 'WriteIoBytes', 'WriteIoWaitTime', 'EncryptionTime', 'PeakUnpinnedBytes', 'AllocTime', 'CompressionTime', 'ReadIoBytes', 'PeakUsedReservation', 'PeakReservation', 'CumulativeAllocationBytes'])}, event_sequences=None, counters=[TCounter(value=20999974, name='AllocTime', unit=5), TCounter(value=0, name='CompressionTime', unit=5), TCounter(value=63700992, name='CumulativeAllocationBytes', unit=3), TCounter(value=18, name='CumulativeAllocations', unit=0), TCounter(value=0, name='EncryptionTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=67108864, name='PeakReservation', unit=3), TCounter(value=0, name='PeakUnpinnedBytes', unit=3), TCounter(value=63569920, name='PeakUsedReservation', unit=3), TCounter(value=0, name='ReadIoBytes', unit=3), TCounter(value=0, name='ReadIoOps', unit=0), TCounter(value=0, name='ReadIoWaitTime', unit=5), TCounter(value=20999974, name='SystemAllocTime', unit=5), TCounter(value=0, name='TotalTime', unit=5), TCounter(value=0, name='WriteIoBytes', unit=3), TCounter(value=0, name='WriteIoOps', unit=0), TCounter(value=0, name='WriteIoWaitTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Fragment F00', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=3, child_counters_map={}, event_sequences=None, counters=[TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=['Last report received time', 'Hdfs split stats (:<# splits>/)'], indent=True, name='Instance 2346d7f7d36332d2:49fccd8300000002 (host=impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22000)', time_series_counters=[TTimeSeriesCounter(start_index=0, values=[9016, 9016, 9016, 9016, 9016, 9016, 9016, 9016, 9016, 9016, 9016], name='MemoryUsage', unit=3, period_ms=500), TTimeSeriesCounter(start_index=0, values=[1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1], name='ThreadUsage', unit=0, period_ms=500)], info_strings={'Hdfs split stats (:<# splits>/)': '0:1/68.96 MB', 'Last report received time': '2020-04-29 06:03:12.427'}, summary_stats_counters=None, node_metadata=None, num_children=3, child_counters_map={'': set(['ExchangeScanRatio', 'TotalNetworkSendTime', 'PerHostPeakMemUsage', 'AverageThreadTokens', 'PeakMemoryUsage', 'TotalStorageWaitTime', 'TotalThreadsInvoluntaryContextSwitches', 'TotalThreadsTotalWallClockTime', 'RowsProduced', 'TotalThreadsVoluntaryContextSwitches', 'TotalNetworkReceiveTime', 'PeakReservation', 'PeakUsedReservation']), 'TotalThreadsTotalWallClockTime': set(['TotalThreadsUserTime', 'TotalThreadsSysTime'])}, event_sequences=[TEventSequence(timestamps=[12999985, 5852993003], labels=['Prepare Finished', 'ExecInternal Finished'], name='Fragment Instance Lifecycle Event Timeline')], counters=[TCounter(value=4607182418800017408, name='AverageThreadTokens', unit=6), TCounter(value=0, name='ExchangeScanRatio', unit=6), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=105051277, name='PeakMemoryUsage', unit=3), TCounter(value=67108864, name='PeakReservation', unit=3), TCounter(value=0, name='PeakUsedReservation', unit=3), TCounter(value=105081271, name='PerHostPeakMemUsage', unit=3), TCounter(value=0, name='RowsProduced', unit=0), TCounter(value=0, name='TotalNetworkReceiveTime', unit=5), TCounter(value=0, name='TotalNetworkSendTime', unit=5), TCounter(value=999999, name='TotalStorageWaitTime', unit=5), TCounter(value=379, name='TotalThreadsInvoluntaryContextSwitches', unit=0), TCounter(value=70721000, name='TotalThreadsSysTime', unit=5), TCounter(value=6054992761, name='TotalThreadsTotalWallClockTime', unit=5), TCounter(value=5697504000, name='TotalThreadsUserTime', unit=5), TCounter(value=325, name='TotalThreadsVoluntaryContextSwitches', unit=0), TCounter(value=5794993072, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Fragment Instance Lifecycle Timings', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['OpenTime', 'PrepareTime']), 'OpenTime': set(['ExecTreeOpenTime']), 'PrepareTime': set(['ExecTreePrepareTime'])}, event_sequences=None, counters=[TCounter(value=249999701, name='ExecTreeOpenTime', unit=5), TCounter(value=5999993, name='ExecTreePrepareTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=5782993086, name='OpenTime', unit=5), TCounter(value=9999988, name='PrepareTime', unit=5), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='KrpcDataStreamSender (dst_id=2)', time_series_counters=[TTimeSeriesCounter(start_index=0, values=[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0], name='BytesSent', unit=3, period_ms=500)], info_strings={}, summary_stats_counters=[TSummaryStatsCounter(total_num_values=0, name='NetworkThroughput', max_value=-9223372036854775808L, sum=0, min_value=9223372036854775807L, unit=4), TSummaryStatsCounter(total_num_values=0, name='RpcNetworkTime', max_value=-9223372036854775808L, sum=0, min_value=9223372036854775807L, unit=5), TSummaryStatsCounter(total_num_values=0, name='RpcRecvrTime', max_value=-9223372036854775808L, sum=0, min_value=9223372036854775807L, unit=5)], node_metadata=TRuntimeProfileNodeMetadata(data_sink_id=1, plan_node_id=None), num_children=0, child_counters_map={'': set(['SerializeBatchTime', 'UncompressedRowBatchSize', 'RpcFailure', 'PeakMemoryUsage', 'RpcRetry', 'EosSent', 'TotalBytesSent', 'RowsSent'])}, event_sequences=None, counters=[TCounter(value=0, name='EosSent', unit=0), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=824, name='PeakMemoryUsage', unit=3), TCounter(value=0, name='RowsSent', unit=0), TCounter(value=0, name='RpcFailure', unit=0), TCounter(value=0, name='RpcRetry', unit=0), TCounter(value=0, name='SerializeBatchTime', unit=5), TCounter(value=0, name='TotalBytesSent', unit=3), TCounter(value=999999, name='TotalTime', unit=5), TCounter(value=0, name='UncompressedRowBatchSize', unit=3)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=['SortType', 'ExecOption'], indent=True, name='SORT_NODE (id=1)', time_series_counters=None, info_strings={'ExecOption': 'Codegen Enabled', 'SortType': 'TopN'}, summary_stats_counters=None, node_metadata=TRuntimeProfileNodeMetadata(data_sink_id=None, plan_node_id=1), num_children=1, child_counters_map={'': set(['InsertBatchTime', 'RowsReturnedRate', 'RowsReturned', 'PeakMemoryUsage', 'TuplePoolReclamations'])}, event_sequences=[TEventSequence(timestamps=[5545993370, 5795993071, 5851993004], labels=['Open Started', 'Open Finished', 'Closed'], name='Node Lifecycle Event Timeline')], counters=[TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=147999823, name='InsertBatchTime', unit=5), TCounter(value=21202921, name='PeakMemoryUsage', unit=3), TCounter(value=0, name='RowsReturned', unit=0), TCounter(value=0, name='RowsReturnedRate', unit=1), TCounter(value=255999694, name='TotalTime', unit=5), TCounter(value=0, name='TuplePoolReclamations', unit=0)], metadata=1), TRuntimeProfileNode(info_strings_display_order=['Table Name', 'Hdfs split stats (:<# splits>/)', 'ExecOption', 'Hdfs Read Thread Concurrency Bucket', 'File Formats'], indent=False, name='HDFS_SCAN_NODE (id=0)', time_series_counters=[TTimeSeriesCounter(start_index=0, values=[0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 57024694], name='BytesReadSeries', unit=3, period_ms=500)], info_strings={'Hdfs Read Thread Concurrency Bucket': '0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0%', 'ExecOption': 'PARQUET Codegen Enabled, Codegen enabled: 1 out of 1', 'Table Name': 'tpch_parquet.lineitem', 'File Formats': 'PARQUET/SNAPPY:1', 'Hdfs split stats (:<# splits>/)': '0:1/68.96 MB'}, summary_stats_counters=[TSummaryStatsCounter(total_num_values=1, name='FooterProcessingTime', max_value=999999, sum=999999, min_value=999999, unit=5), TSummaryStatsCounter(total_num_values=1, name='InitialRangeActualReservation', max_value=41943040, sum=41943040, min_value=41943040, unit=3), TSummaryStatsCounter(total_num_values=1, name='InitialRangeIdealReservation', max_value=131072, sum=131072, min_value=131072, unit=3), TSummaryStatsCounter(total_num_values=0, name='PageIndexProcessingTime', max_value=-9223372036854775808L, sum=0, min_value=9223372036854775807L, unit=5), TSummaryStatsCounter(total_num_values=16, name='ParquetCompressedBytesReadPerColumn', max_value=1324084, sum=4431800, min_value=41816, unit=3), TSummaryStatsCounter(total_num_values=103, name='ParquetCompressedPageSize', max_value=79921, sum=4431800, min_value=14972, unit=3), TSummaryStatsCounter(total_num_values=1, name='ParquetRowGroupActualReservation', max_value=67108864, sum=67108864, min_value=67108864, unit=3), TSummaryStatsCounter(total_num_values=1, name='ParquetRowGroupIdealReservation', max_value=89653248, sum=89653248, min_value=89653248, unit=3), TSummaryStatsCounter(total_num_values=16, name='ParquetUncompressedBytesReadPerColumn', max_value=3030292, sum=6616074, min_value=63383, unit=3), TSummaryStatsCounter(total_num_values=103, name='ParquetUncompressedPageSize', max_value=80711, sum=6616074, min_value=14967, unit=3)], node_metadata=TRuntimeProfileNodeMetadata(data_sink_id=None, plan_node_id=0), num_children=1, child_counters_map={'': set(['CachedFileHandlesHitCount', 'NumPages', 'PeakScannerThreadConcurrency', 'RemoteScanRanges', 'ScanRangesComplete', 'NumStatsFilteredRowGroups', 'ScannerThreadWorklessLoops', 'RowsReturned', 'ScannerIoWaitTime', 'TotalReadThroughput', 'NumRowGroupsWithPageIndex', 'CachedFileHandlesMissCount', 'NumColumns', 'ScannerThreadsInvoluntaryContextSwitches', 'NumDisksAccessed', 'DataCacheMissBytes', 'RowBatchQueueGetWaitTime', 'RowsReturnedRate', 'RowBatchesEnqueued', 'MaterializeTupleTime', 'ScannerThreadsTotalWallClockTime', 'CollectionItemsRead', 'NumScannersWithNoReads', 'NumScannerThreadMemUnavailable', 'NumStatsFilteredPages', 'TotalRawHdfsOpenFileTime', 'NumDictFilteredRowGroups', 'AverageHdfsReadThreadConcurrency', 'NumScannerThreadReservationsDenied', 'ScannerThreadsVoluntaryContextSwitches', 'TotalRawHdfsReadTime', 'AverageScannerThreadConcurrency', 'RowBatchBytesEnqueued', 'DataCacheHitCount', 'NumScannerThreadsStarted', 'DataCachePartialHitCount', 'DataCacheHitBytes', 'BytesReadLocal', 'DecompressionTime', 'NumRowGroups', 'DataCacheMissCount', 'BytesReadRemoteUnexpected', 'MaxCompressedTextFileLength', 'PeakMemoryUsage', 'RowBatchQueuePutWaitTime', 'PerReadThreadRawHdfsThroughput', 'RowBatchQueuePeakMemoryUsage', 'BytesReadShortCircuit', 'RowsRead', 'BytesRead', 'BytesReadDataNodeCache']), 'ScannerThreadsTotalWallClockTime': set(['ScannerThreadsUserTime', 'ScannerThreadsSysTime'])}, event_sequences=[TEventSequence(timestamps=[5546993369, 5550993364, 5550993364, 5629993270, 5851993004], labels=['Open Started', 'Open Finished', 'First Batch Requested', 'First Batch Returned', 'Closed'], name='Node Lifecycle Event Timeline')], counters=[TCounter(value=0, name='AverageHdfsReadThreadConcurrency', unit=6), TCounter(value=4607182418800017408, name='AverageScannerThreadConcurrency', unit=6), TCounter(value=57024694, name='BytesRead', unit=3), TCounter(value=0, name='BytesReadDataNodeCache', unit=3), TCounter(value=57024694, name='BytesReadLocal', unit=3), TCounter(value=0, name='BytesReadRemoteUnexpected', unit=3), TCounter(value=57024694, name='BytesReadShortCircuit', unit=3), TCounter(value=18, name='CachedFileHandlesHitCount', unit=0), TCounter(value=0, name='CachedFileHandlesMissCount', unit=0), TCounter(value=0, name='CollectionItemsRead', unit=0), TCounter(value=0, name='DataCacheHitBytes', unit=3), TCounter(value=0, name='DataCacheHitCount', unit=0), TCounter(value=0, name='DataCacheMissBytes', unit=3), TCounter(value=0, name='DataCacheMissCount', unit=0), TCounter(value=0, name='DataCachePartialHitCount', unit=0), TCounter(value=7999992, name='DecompressionTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=94999886, name='MaterializeTupleTime', unit=5), TCounter(value=0, name='MaxCompressedTextFileLength', unit=3), TCounter(value=16, name='NumColumns', unit=0), TCounter(value=0, name='NumDictFilteredRowGroups', unit=0), TCounter(value=1, name='NumDisksAccessed', unit=0), TCounter(value=103, name='NumPages', unit=0), TCounter(value=1, name='NumRowGroups', unit=0), TCounter(value=1, name='NumRowGroupsWithPageIndex', unit=0), TCounter(value=0, name='NumScannerThreadMemUnavailable', unit=0), TCounter(value=0, name='NumScannerThreadReservationsDenied', unit=0), TCounter(value=1, name='NumScannerThreadsStarted', unit=0), TCounter(value=0, name='NumScannersWithNoReads', unit=0), TCounter(value=0, name='NumStatsFilteredPages', unit=0), TCounter(value=0, name='NumStatsFilteredRowGroups', unit=0), TCounter(value=84017516, name='PeakMemoryUsage', unit=3), TCounter(value=1, name='PeakScannerThreadConcurrency', unit=0), TCounter(value=295465092, name='PerReadThreadRawHdfsThroughput', unit=4), TCounter(value=0, name='RemoteScanRanges', unit=0), TCounter(value=27106943, name='RowBatchBytesEnqueued', unit=3), TCounter(value=77999907, name='RowBatchQueueGetWaitTime', unit=5), TCounter(value=14713000, name='RowBatchQueuePeakMemoryUsage', unit=3), TCounter(value=39999951, name='RowBatchQueuePutWaitTime', unit=5), TCounter(value=135, name='RowBatchesEnqueued', unit=0), TCounter(value=136192, name='RowsRead', unit=0), TCounter(value=73728, name='RowsReturned', unit=0), TCounter(value=729981, name='RowsReturnedRate', unit=1), TCounter(value=1, name='ScanRangesComplete', unit=0), TCounter(value=999999, name='ScannerIoWaitTime', unit=5), TCounter(value=0, name='ScannerThreadWorklessLoops', unit=0), TCounter(value=1, name='ScannerThreadsInvoluntaryContextSwitches', unit=0), TCounter(value=44805000, name='ScannerThreadsSysTime', unit=5), TCounter(value=271999675, name='ScannerThreadsTotalWallClockTime', unit=5), TCounter(value=164241000, name='ScannerThreadsUserTime', unit=5), TCounter(value=235, name='ScannerThreadsVoluntaryContextSwitches', unit=0), TCounter(value=0, name='TotalRawHdfsOpenFileTime', unit=5), TCounter(value=192999767, name='TotalRawHdfsReadTime', unit=5), TCounter(value=9466250, name='TotalReadThroughput', unit=4), TCounter(value=100999881, name='TotalTime', unit=5)], metadata=0), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Buffer pool', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['ReadIoWaitTime', 'WriteIoOps', 'SystemAllocTime', 'CumulativeAllocations', 'ReadIoOps', 'WriteIoBytes', 'WriteIoWaitTime', 'EncryptionTime', 'PeakUnpinnedBytes', 'AllocTime', 'CompressionTime', 'ReadIoBytes', 'PeakUsedReservation', 'PeakReservation', 'CumulativeAllocationBytes'])}, event_sequences=None, counters=[TCounter(value=28999964, name='AllocTime', unit=5), TCounter(value=0, name='CompressionTime', unit=5), TCounter(value=64618496, name='CumulativeAllocationBytes', unit=3), TCounter(value=18, name='CumulativeAllocations', unit=0), TCounter(value=0, name='EncryptionTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=67108864, name='PeakReservation', unit=3), TCounter(value=0, name='PeakUnpinnedBytes', unit=3), TCounter(value=64487424, name='PeakUsedReservation', unit=3), TCounter(value=0, name='ReadIoBytes', unit=3), TCounter(value=0, name='ReadIoOps', unit=0), TCounter(value=0, name='ReadIoWaitTime', unit=5), TCounter(value=28999964, name='SystemAllocTime', unit=5), TCounter(value=0, name='TotalTime', unit=5), TCounter(value=0, name='WriteIoBytes', unit=3), TCounter(value=0, name='WriteIoOps', unit=0), TCounter(value=0, name='WriteIoWaitTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=['Last report received time', 'Hdfs split stats (:<# splits>/)'], indent=True, name='Instance 2346d7f7d36332d2:49fccd8300000003 (host=impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22002)', time_series_counters=[TTimeSeriesCounter(start_index=0, values=[9016, 9016, 9016, 9016, 9016, 9016, 9016, 9016, 9016], name='MemoryUsage', unit=3, period_ms=500), TTimeSeriesCounter(start_index=0, values=[1, 1, 1, 1, 1, 1, 1, 1, 1], name='ThreadUsage', unit=0, period_ms=500)], info_strings={'Hdfs split stats (:<# splits>/)': '0:1/55.81 MB', 'Last report received time': '2020-04-29 06:03:11.612'}, summary_stats_counters=None, node_metadata=None, num_children=3, child_counters_map={'': set(['ExchangeScanRatio', 'TotalNetworkSendTime', 'PerHostPeakMemUsage', 'AverageThreadTokens', 'PeakMemoryUsage', 'TotalStorageWaitTime', 'TotalThreadsInvoluntaryContextSwitches', 'TotalThreadsTotalWallClockTime', 'RowsProduced', 'TotalThreadsVoluntaryContextSwitches', 'TotalNetworkReceiveTime', 'PeakReservation', 'PeakUsedReservation']), 'TotalThreadsTotalWallClockTime': set(['TotalThreadsUserTime', 'TotalThreadsSysTime'])}, event_sequences=[TEventSequence(timestamps=[15999981, 5031993985], labels=['Prepare Finished', 'ExecInternal Finished'], name='Fragment Instance Lifecycle Event Timeline')], counters=[TCounter(value=4607182418800017408, name='AverageThreadTokens', unit=6), TCounter(value=0, name='ExchangeScanRatio', unit=6), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=105355872, name='PeakMemoryUsage', unit=3), TCounter(value=67108864, name='PeakReservation', unit=3), TCounter(value=0, name='PeakUsedReservation', unit=3), TCounter(value=105375340, name='PerHostPeakMemUsage', unit=3), TCounter(value=0, name='RowsProduced', unit=0), TCounter(value=0, name='TotalNetworkReceiveTime', unit=5), TCounter(value=0, name='TotalNetworkSendTime', unit=5), TCounter(value=29999964, name='TotalStorageWaitTime', unit=5), TCounter(value=429, name='TotalThreadsInvoluntaryContextSwitches', unit=0), TCounter(value=52303000, name='TotalThreadsSysTime', unit=5), TCounter(value=5314993646, name='TotalThreadsTotalWallClockTime', unit=5), TCounter(value=4690557000, name='TotalThreadsUserTime', unit=5), TCounter(value=216, name='TotalThreadsVoluntaryContextSwitches', unit=0), TCounter(value=4961994068, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Fragment Instance Lifecycle Timings', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['OpenTime', 'PrepareTime']), 'OpenTime': set(['ExecTreeOpenTime']), 'PrepareTime': set(['ExecTreePrepareTime'])}, event_sequences=None, counters=[TCounter(value=329999605, name='ExecTreeOpenTime', unit=5), TCounter(value=3999995, name='ExecTreePrepareTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=4953994078, name='OpenTime', unit=5), TCounter(value=6999991, name='PrepareTime', unit=5), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='KrpcDataStreamSender (dst_id=2)', time_series_counters=[TTimeSeriesCounter(start_index=0, values=[0, 0, 0, 0, 0, 0, 0, 0, 0], name='BytesSent', unit=3, period_ms=500)], info_strings={}, summary_stats_counters=[TSummaryStatsCounter(total_num_values=0, name='NetworkThroughput', max_value=-9223372036854775808L, sum=0, min_value=9223372036854775807L, unit=4), TSummaryStatsCounter(total_num_values=0, name='RpcNetworkTime', max_value=-9223372036854775808L, sum=0, min_value=9223372036854775807L, unit=5), TSummaryStatsCounter(total_num_values=0, name='RpcRecvrTime', max_value=-9223372036854775808L, sum=0, min_value=9223372036854775807L, unit=5)], node_metadata=TRuntimeProfileNodeMetadata(data_sink_id=1, plan_node_id=None), num_children=0, child_counters_map={'': set(['SerializeBatchTime', 'UncompressedRowBatchSize', 'RpcFailure', 'PeakMemoryUsage', 'RpcRetry', 'EosSent', 'TotalBytesSent', 'RowsSent'])}, event_sequences=None, counters=[TCounter(value=0, name='EosSent', unit=0), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=824, name='PeakMemoryUsage', unit=3), TCounter(value=0, name='RowsSent', unit=0), TCounter(value=0, name='RpcFailure', unit=0), TCounter(value=0, name='RpcRetry', unit=0), TCounter(value=0, name='SerializeBatchTime', unit=5), TCounter(value=0, name='TotalBytesSent', unit=3), TCounter(value=999998, name='TotalTime', unit=5), TCounter(value=0, name='UncompressedRowBatchSize', unit=3)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=['SortType', 'ExecOption'], indent=True, name='SORT_NODE (id=1)', time_series_counters=None, info_strings={'ExecOption': 'Codegen Enabled', 'SortType': 'TopN'}, summary_stats_counters=None, node_metadata=TRuntimeProfileNodeMetadata(data_sink_id=None, plan_node_id=1), num_children=1, child_counters_map={'': set(['InsertBatchTime', 'RowsReturnedRate', 'RowsReturned', 'PeakMemoryUsage', 'TuplePoolReclamations'])}, event_sequences=[TEventSequence(timestamps=[4639994454, 4969994059, 5031993985], labels=['Open Started', 'Open Finished', 'Closed'], name='Node Lifecycle Event Timeline')], counters=[TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=210999748, name='InsertBatchTime', unit=5), TCounter(value=21727235, name='PeakMemoryUsage', unit=3), TCounter(value=0, name='RowsReturned', unit=0), TCounter(value=0, name='RowsReturnedRate', unit=1), TCounter(value=333999600, name='TotalTime', unit=5), TCounter(value=0, name='TuplePoolReclamations', unit=0)], metadata=1), TRuntimeProfileNode(info_strings_display_order=['Table Name', 'Hdfs split stats (:<# splits>/)', 'ExecOption', 'Hdfs Read Thread Concurrency Bucket', 'File Formats'], indent=False, name='HDFS_SCAN_NODE (id=0)', time_series_counters=[TTimeSeriesCounter(start_index=0, values=[0, 0, 0, 0, 0, 0, 0, 0, 0, 53072023], name='BytesReadSeries', unit=3, period_ms=500)], info_strings={'Hdfs Read Thread Concurrency Bucket': '0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0%', 'ExecOption': 'PARQUET Codegen Enabled, Codegen enabled: 1 out of 1', 'Table Name': 'tpch_parquet.lineitem', 'File Formats': 'PARQUET/SNAPPY:1', 'Hdfs split stats (:<# splits>/)': '0:1/55.81 MB'}, summary_stats_counters=[TSummaryStatsCounter(total_num_values=1, name='FooterProcessingTime', max_value=999999, sum=999999, min_value=999999, unit=5), TSummaryStatsCounter(total_num_values=1, name='InitialRangeActualReservation', max_value=41943040, sum=41943040, min_value=41943040, unit=3), TSummaryStatsCounter(total_num_values=1, name='InitialRangeIdealReservation', max_value=131072, sum=131072, min_value=131072, unit=3), TSummaryStatsCounter(total_num_values=0, name='PageIndexProcessingTime', max_value=-9223372036854775808L, sum=0, min_value=9223372036854775807L, unit=5), TSummaryStatsCounter(total_num_values=16, name='ParquetCompressedBytesReadPerColumn', max_value=1322269, sum=4425940, min_value=41546, unit=3), TSummaryStatsCounter(total_num_values=103, name='ParquetCompressedPageSize', max_value=76134, sum=4425940, min_value=14796, unit=3), TSummaryStatsCounter(total_num_values=1, name='ParquetRowGroupActualReservation', max_value=67108864, sum=67108864, min_value=67108864, unit=3), TSummaryStatsCounter(total_num_values=1, name='ParquetRowGroupIdealReservation', max_value=78381056, sum=78381056, min_value=78381056, unit=3), TSummaryStatsCounter(total_num_values=16, name='ParquetUncompressedBytesReadPerColumn', max_value=3030346, sum=6615891, min_value=63394, unit=3), TSummaryStatsCounter(total_num_values=103, name='ParquetUncompressedPageSize', max_value=80814, sum=6615891, min_value=14791, unit=3)], node_metadata=TRuntimeProfileNodeMetadata(data_sink_id=None, plan_node_id=0), num_children=1, child_counters_map={'': set(['CachedFileHandlesHitCount', 'NumPages', 'PeakScannerThreadConcurrency', 'RemoteScanRanges', 'ScanRangesComplete', 'NumStatsFilteredRowGroups', 'ScannerThreadWorklessLoops', 'RowsReturned', 'ScannerIoWaitTime', 'TotalReadThroughput', 'NumRowGroupsWithPageIndex', 'CachedFileHandlesMissCount', 'NumColumns', 'ScannerThreadsInvoluntaryContextSwitches', 'NumDisksAccessed', 'DataCacheMissBytes', 'RowBatchQueueGetWaitTime', 'RowsReturnedRate', 'RowBatchesEnqueued', 'MaterializeTupleTime', 'ScannerThreadsTotalWallClockTime', 'CollectionItemsRead', 'NumScannersWithNoReads', 'NumScannerThreadMemUnavailable', 'NumStatsFilteredPages', 'TotalRawHdfsOpenFileTime', 'NumDictFilteredRowGroups', 'AverageHdfsReadThreadConcurrency', 'NumScannerThreadReservationsDenied', 'ScannerThreadsVoluntaryContextSwitches', 'TotalRawHdfsReadTime', 'AverageScannerThreadConcurrency', 'RowBatchBytesEnqueued', 'DataCacheHitCount', 'NumScannerThreadsStarted', 'DataCachePartialHitCount', 'DataCacheHitBytes', 'BytesReadLocal', 'DecompressionTime', 'NumRowGroups', 'DataCacheMissCount', 'BytesReadRemoteUnexpected', 'MaxCompressedTextFileLength', 'PeakMemoryUsage', 'RowBatchQueuePutWaitTime', 'PerReadThreadRawHdfsThroughput', 'RowBatchQueuePeakMemoryUsage', 'BytesReadShortCircuit', 'RowsRead', 'BytesRead', 'BytesReadDataNodeCache']), 'ScannerThreadsTotalWallClockTime': set(['ScannerThreadsUserTime', 'ScannerThreadsSysTime'])}, event_sequences=[TEventSequence(timestamps=[4640994452, 4643994449, 4643994449, 4728994347, 5031993985], labels=['Open Started', 'Open Finished', 'First Batch Requested', 'First Batch Returned', 'Closed'], name='Node Lifecycle Event Timeline')], counters=[TCounter(value=0, name='AverageHdfsReadThreadConcurrency', unit=6), TCounter(value=4607182418800017408, name='AverageScannerThreadConcurrency', unit=6), TCounter(value=53072023, name='BytesRead', unit=3), TCounter(value=0, name='BytesReadDataNodeCache', unit=3), TCounter(value=53072023, name='BytesReadLocal', unit=3), TCounter(value=0, name='BytesReadRemoteUnexpected', unit=3), TCounter(value=53072023, name='BytesReadShortCircuit', unit=3), TCounter(value=19, name='CachedFileHandlesHitCount', unit=0), TCounter(value=0, name='CachedFileHandlesMissCount', unit=0), TCounter(value=0, name='CollectionItemsRead', unit=0), TCounter(value=0, name='DataCacheHitBytes', unit=3), TCounter(value=0, name='DataCacheHitCount', unit=0), TCounter(value=0, name='DataCacheMissBytes', unit=3), TCounter(value=0, name='DataCacheMissCount', unit=0), TCounter(value=0, name='DataCachePartialHitCount', unit=0), TCounter(value=10999988, name='DecompressionTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=179999782, name='MaterializeTupleTime', unit=5), TCounter(value=0, name='MaxCompressedTextFileLength', unit=3), TCounter(value=16, name='NumColumns', unit=0), TCounter(value=0, name='NumDictFilteredRowGroups', unit=0), TCounter(value=1, name='NumDisksAccessed', unit=0), TCounter(value=103, name='NumPages', unit=0), TCounter(value=1, name='NumRowGroups', unit=0), TCounter(value=1, name='NumRowGroupsWithPageIndex', unit=0), TCounter(value=0, name='NumScannerThreadMemUnavailable', unit=0), TCounter(value=0, name='NumScannerThreadReservationsDenied', unit=0), TCounter(value=1, name='NumScannerThreadsStarted', unit=0), TCounter(value=0, name='NumScannersWithNoReads', unit=0), TCounter(value=0, name='NumStatsFilteredPages', unit=0), TCounter(value=0, name='NumStatsFilteredRowGroups', unit=0), TCounter(value=83650498, name='PeakMemoryUsage', unit=3), TCounter(value=1, name='PeakScannerThreadConcurrency', unit=0), TCounter(value=165850270, name='PerReadThreadRawHdfsThroughput', unit=4), TCounter(value=0, name='RemoteScanRanges', unit=0), TCounter(value=27114604, name='RowBatchBytesEnqueued', unit=3), TCounter(value=104999874, name='RowBatchQueueGetWaitTime', unit=5), TCounter(value=14323309, name='RowBatchQueuePeakMemoryUsage', unit=3), TCounter(value=47999943, name='RowBatchQueuePutWaitTime', unit=5), TCounter(value=136, name='RowBatchesEnqueued', unit=0), TCounter(value=137216, name='RowsRead', unit=0), TCounter(value=75776, name='RowsReturned', unit=0), TCounter(value=653242, name='RowsReturnedRate', unit=1), TCounter(value=1, name='ScanRangesComplete', unit=0), TCounter(value=29999964, name='ScannerIoWaitTime', unit=5), TCounter(value=0, name='ScannerThreadWorklessLoops', unit=0), TCounter(value=11, name='ScannerThreadsInvoluntaryContextSwitches', unit=0), TCounter(value=26691000, name='ScannerThreadsSysTime', unit=5), TCounter(value=360999568, name='ScannerThreadsTotalWallClockTime', unit=5), TCounter(value=163079000, name='ScannerThreadsUserTime', unit=5), TCounter(value=155, name='ScannerThreadsVoluntaryContextSwitches', unit=0), TCounter(value=0, name='TotalRawHdfsOpenFileTime', unit=5), TCounter(value=319999617, name='TotalRawHdfsReadTime', unit=5), TCounter(value=10586878, name='TotalReadThroughput', unit=4), TCounter(value=115999863, name='TotalTime', unit=5)], metadata=0), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Buffer pool', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['ReadIoWaitTime', 'WriteIoOps', 'SystemAllocTime', 'CumulativeAllocations', 'ReadIoOps', 'WriteIoBytes', 'WriteIoWaitTime', 'EncryptionTime', 'PeakUnpinnedBytes', 'AllocTime', 'CompressionTime', 'ReadIoBytes', 'PeakUsedReservation', 'PeakReservation', 'CumulativeAllocationBytes'])}, event_sequences=None, counters=[TCounter(value=12999985, name='AllocTime', unit=5), TCounter(value=0, name='CompressionTime', unit=5), TCounter(value=62783488, name='CumulativeAllocationBytes', unit=3), TCounter(value=19, name='CumulativeAllocations', unit=0), TCounter(value=0, name='EncryptionTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=67108864, name='PeakReservation', unit=3), TCounter(value=0, name='PeakUnpinnedBytes', unit=3), TCounter(value=62652416, name='PeakUsedReservation', unit=3), TCounter(value=0, name='ReadIoBytes', unit=3), TCounter(value=0, name='ReadIoOps', unit=0), TCounter(value=0, name='ReadIoWaitTime', unit=5), TCounter(value=12999985, name='SystemAllocTime', unit=5), TCounter(value=0, name='TotalTime', unit=5), TCounter(value=0, name='WriteIoBytes', unit=3), TCounter(value=0, name='WriteIoOps', unit=0), TCounter(value=0, name='WriteIoWaitTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=['Last report received time', 'Hdfs split stats (:<# splits>/)'], indent=True, name='Instance 2346d7f7d36332d2:49fccd8300000001 (host=impala-ec2-centos74-r5-4xlarge-ondemand-0f30.vpc.cloudera.com:22001)', time_series_counters=[TTimeSeriesCounter(start_index=0, values=[9016, 9016, 9016, 9016, 9016, 9016, 9016, 9016, 9016, 9016], name='MemoryUsage', unit=3, period_ms=500), TTimeSeriesCounter(start_index=0, values=[1, 1, 1, 1, 1, 1, 1, 1, 1, 1], name='ThreadUsage', unit=0, period_ms=500)], info_strings={'Hdfs split stats (:<# splits>/)': '0:1/69.24 MB', 'Last report received time': '2020-04-29 06:03:11.617'}, summary_stats_counters=None, node_metadata=None, num_children=3, child_counters_map={'': set(['ExchangeScanRatio', 'TotalNetworkSendTime', 'PerHostPeakMemUsage', 'AverageThreadTokens', 'PeakMemoryUsage', 'TotalStorageWaitTime', 'TotalThreadsInvoluntaryContextSwitches', 'TotalThreadsTotalWallClockTime', 'RowsProduced', 'TotalThreadsVoluntaryContextSwitches', 'TotalNetworkReceiveTime', 'PeakReservation', 'PeakUsedReservation']), 'TotalThreadsTotalWallClockTime': set(['TotalThreadsUserTime', 'TotalThreadsSysTime'])}, event_sequences=[TEventSequence(timestamps=[28999965], labels=['Prepare Finished'], name='Fragment Instance Lifecycle Event Timeline')], counters=[TCounter(value=4607182418800017408, name='AverageThreadTokens', unit=6), TCounter(value=0, name='ExchangeScanRatio', unit=6), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=9016, name='PeakMemoryUsage', unit=3), TCounter(value=0, name='PeakReservation', unit=3), TCounter(value=0, name='PeakUsedReservation', unit=3), TCounter(value=43475768, name='PerHostPeakMemUsage', unit=3), TCounter(value=0, name='RowsProduced', unit=0), TCounter(value=0, name='TotalNetworkReceiveTime', unit=5), TCounter(value=0, name='TotalNetworkSendTime', unit=5), TCounter(value=0, name='TotalStorageWaitTime', unit=5), TCounter(value=0, name='TotalThreadsInvoluntaryContextSwitches', unit=0), TCounter(value=0, name='TotalThreadsSysTime', unit=5), TCounter(value=0, name='TotalThreadsTotalWallClockTime', unit=5), TCounter(value=0, name='TotalThreadsUserTime', unit=5), TCounter(value=0, name='TotalThreadsVoluntaryContextSwitches', unit=0), TCounter(value=10999986, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='Fragment Instance Lifecycle Timings', time_series_counters=None, info_strings={}, summary_stats_counters=None, node_metadata=None, num_children=0, child_counters_map={'': set(['OpenTime', 'PrepareTime']), 'PrepareTime': set(['ExecTreePrepareTime'])}, event_sequences=None, counters=[TCounter(value=4999994, name='ExecTreePrepareTime', unit=5), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='OpenTime', unit=5), TCounter(value=8999989, name='PrepareTime', unit=5), TCounter(value=0, name='TotalTime', unit=5)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=[], indent=True, name='KrpcDataStreamSender (dst_id=2)', time_series_counters=[TTimeSeriesCounter(start_index=0, values=[0, 0, 0, 0, 0, 0, 0, 0, 0, 0], name='BytesSent', unit=3, period_ms=500)], info_strings={}, summary_stats_counters=[TSummaryStatsCounter(total_num_values=0, name='NetworkThroughput', max_value=-9223372036854775808L, sum=0, min_value=9223372036854775807L, unit=4), TSummaryStatsCounter(total_num_values=0, name='RpcNetworkTime', max_value=-9223372036854775808L, sum=0, min_value=9223372036854775807L, unit=5), TSummaryStatsCounter(total_num_values=0, name='RpcRecvrTime', max_value=-9223372036854775808L, sum=0, min_value=9223372036854775807L, unit=5)], node_metadata=TRuntimeProfileNodeMetadata(data_sink_id=1, plan_node_id=None), num_children=0, child_counters_map={'': set(['SerializeBatchTime', 'UncompressedRowBatchSize', 'RpcFailure', 'PeakMemoryUsage', 'RpcRetry', 'EosSent', 'TotalBytesSent', 'RowsSent'])}, event_sequences=None, counters=[TCounter(value=0, name='EosSent', unit=0), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=824, name='PeakMemoryUsage', unit=3), TCounter(value=0, name='RowsSent', unit=0), TCounter(value=0, name='RpcFailure', unit=0), TCounter(value=0, name='RpcRetry', unit=0), TCounter(value=0, name='SerializeBatchTime', unit=5), TCounter(value=0, name='TotalBytesSent', unit=3), TCounter(value=1999997, name='TotalTime', unit=5), TCounter(value=0, name='UncompressedRowBatchSize', unit=3)], metadata=-1), TRuntimeProfileNode(info_strings_display_order=['SortType'], indent=True, name='SORT_NODE (id=1)', time_series_counters=None, info_strings={'SortType': 'TopN'}, summary_stats_counters=None, node_metadata=TRuntimeProfileNodeMetadata(data_sink_id=None, plan_node_id=1), num_children=1, child_counters_map={'': set(['InsertBatchTime', 'RowsReturnedRate', 'RowsReturned', 'PeakMemoryUsage', 'TuplePoolReclamations'])}, event_sequences=[TEventSequence(timestamps=[], labels=[], name='Node Lifecycle Event Timeline')], counters=[TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='InsertBatchTime', unit=5), TCounter(value=0, name='PeakMemoryUsage', unit=3), TCounter(value=0, name='RowsReturned', unit=0), TCounter(value=0, name='RowsReturnedRate', unit=1), TCounter(value=4999994, name='TotalTime', unit=5), TCounter(value=0, name='TuplePoolReclamations', unit=0)], metadata=1), TRuntimeProfileNode(info_strings_display_order=['Table Name', 'Hdfs split stats (:<# splits>/)'], indent=False, name='HDFS_SCAN_NODE (id=0)', time_series_counters=[TTimeSeriesCounter(start_index=0, values=[0, 0, 0, 0, 0, 0, 0, 0, 0, 0], name='BytesReadSeries', unit=3, period_ms=500)], info_strings={'Hdfs split stats (:<# splits>/)': '0:1/69.24 MB', 'Table Name': 'tpch_parquet.lineitem'}, summary_stats_counters=None, node_metadata=TRuntimeProfileNodeMetadata(data_sink_id=None, plan_node_id=0), num_children=0, child_counters_map={'': set(['NumScannerThreadsStarted', 'RowBatchQueuePutWaitTime', 'RowsReturned', 'NumScannerThreadMemUnavailable', 'RowBatchesEnqueued', 'PeakMemoryUsage', 'NumScannerThreadReservationsDenied', 'ScannerThreadWorklessLoops', 'ScannerThreadsVoluntaryContextSwitches', 'RowBatchQueueGetWaitTime', 'RowsReturnedRate', 'ScannerThreadsTotalWallClockTime', 'RowBatchQueuePeakMemoryUsage', 'MaterializeTupleTime', 'TotalReadThroughput', 'BytesRead', 'ScannerThreadsInvoluntaryContextSwitches', 'RowBatchBytesEnqueued', 'RowsRead']), 'ScannerThreadsTotalWallClockTime': set(['ScannerThreadsUserTime', 'ScannerThreadsSysTime'])}, event_sequences=[TEventSequence(timestamps=[], labels=[], name='Node Lifecycle Event Timeline')], counters=[TCounter(value=0, name='BytesRead', unit=3), TCounter(value=0, name='InactiveTotalTime', unit=5), TCounter(value=0, name='MaterializeTupleTime', unit=5), TCounter(value=0, name='NumScannerThreadMemUnavailable', unit=0), TCounter(value=0, name='NumScannerThreadReservationsDenied', unit=0), TCounter(value=0, name='NumScannerThreadsStarted', unit=0), TCounter(value=0, name='PeakMemoryUsage', unit=3), TCounter(value=0, name='RowBatchBytesEnqueued', unit=3), TCounter(value=0, name='RowBatchQueueGetWaitTime', unit=5), TCounter(value=0, name='RowBatchQueuePeakMemoryUsage', unit=3), TCounter(value=0, name='RowBatchQueuePutWaitTime', unit=5), TCounter(value=0, name='RowBatchesEnqueued', unit=0), TCounter(value=0, name='RowsRead', unit=0), TCounter(value=0, name='RowsReturned', unit=0), TCounter(value=0, name='RowsReturnedRate', unit=1), TCounter(value=0, name='ScannerThreadWorklessLoops', unit=0), TCounter(value=0, name='ScannerThreadsInvoluntaryContextSwitches', unit=0), TCounter(value=0, name='ScannerThreadsSysTime', unit=5), TCounter(value=0, name='ScannerThreadsTotalWallClockTime', unit=5), TCounter(value=0, name='ScannerThreadsUserTime', unit=5), TCounter(value=0, name='ScannerThreadsVoluntaryContextSwitches', unit=0), TCounter(value=0, name='TotalReadThroughput', unit=4), TCounter(value=8999989, name='TotalTime', unit=5)], metadata=0)], exec_summary=TExecSummary(status=None, is_queued=None, queued_reason=None, error_logs=None, state=0, progress=None, nodes=None, exch_to_sender_map=None))