Query (id=5e428bfb76c86974:ba5508400000000): Summary: Session ID: 4e4956f2e17d2888:82cb82a2f64c78ab Session Type: BEESWAX Start Time: 2017-04-12 02:16:55.437220000 End Time: Query Type: QUERY Query State: CREATED Query Status: OK Impala Version: impalad version 2.9.0-SNAPSHOT RELEASE (build 924ddc6e935aa6e6d2a07c4926cbb26ea0df0b4e) User: jenkins Connected User: jenkins Delegated User: Network Address: 127.0.0.1:46309 Default Db: functional_text_lzo Sql Statement: select count(*) from (select distinct * from test_fuzz_alltypes_7a856c89.alltypes) q Coordinator: impala-boost-static-burst-slave-1106.vpc.cloudera.com:22000 Query Options (non default): BATCH_SIZE=16,DISABLE_CODEGEN=1,MEM_LIMIT=536870912 Plan: ---------------- Estimated Per-Host Requirements: Memory=416.00MB VCores=2 WARNING: The following tables are missing relevant table and/or column statistics. test_fuzz_alltypes_7a856c89.alltypes PLAN-ROOT SINK | 06:AGGREGATE [FINALIZE] | output: count:merge(*) | hosts=3 per-host-mem=unavailable | tuple-ids=3 row-size=8B cardinality=1 | 05:EXCHANGE [UNPARTITIONED] | hosts=3 per-host-mem=unavailable | tuple-ids=3 row-size=8B cardinality=1 | 02:AGGREGATE | output: count(*) | hosts=3 per-host-mem=10.00MB | tuple-ids=3 row-size=8B cardinality=1 | 04:AGGREGATE [FINALIZE] | group by: test_fuzz_alltypes_7a856c89.alltypes.id, test_fuzz_alltypes_7a856c89.alltypes.bool_col, test_fuzz_alltypes_7a856c89.alltypes.tinyint_col, test_fuzz_alltypes_7a856c89.alltypes.smallint_col, test_fuzz_alltypes_7a856c89.alltypes.int_col, test_fuzz_alltypes_7a856c89.alltypes.bigint_col, test_fuzz_alltypes_7a856c89.alltypes.float_col, test_fuzz_alltypes_7a856c89.alltypes.double_col, test_fuzz_alltypes_7a856c89.alltypes.date_string_col, test_fuzz_alltypes_7a856c89.alltypes.string_col, test_fuzz_alltypes_7a856c89.alltypes.timestamp_col, test_fuzz_alltypes_7a856c89.alltypes.year, test_fuzz_alltypes_7a856c89.alltypes.month | hosts=3 per-host-mem=128.00MB | tuple-ids=1 row-size=86B cardinality=unavailable | 03:EXCHANGE [HASH(test_fuzz_alltypes_7a856c89.alltypes.id,test_fuzz_alltypes_7a856c89.alltypes.bool_col,test_fuzz_alltypes_7a856c89.alltypes.tinyint_col,test_fuzz_alltypes_7a856c89.alltypes.smallint_col,test_fuzz_alltypes_7a856c89.alltypes.int_col,test_fuzz_alltypes_7a856c89.alltypes.bigint_col,test_fuzz_alltypes_7a856c89.alltypes.float_col,test_fuzz_alltypes_7a856c89.alltypes.double_col,test_fuzz_alltypes_7a856c89.alltypes.date_string_col,test_fuzz_alltypes_7a856c89.alltypes.string_col,test_fuzz_alltypes_7a856c89.alltypes.timestamp_col,test_fuzz_alltypes_7a856c89.alltypes.year,test_fuzz_alltypes_7a856c89.alltypes.month)] | hosts=3 per-host-mem=0B | tuple-ids=1 row-size=86B cardinality=unavailable | 01:AGGREGATE [STREAMING] | group by: test_fuzz_alltypes_7a856c89.alltypes.id, test_fuzz_alltypes_7a856c89.alltypes.bool_col, test_fuzz_alltypes_7a856c89.alltypes.tinyint_col, test_fuzz_alltypes_7a856c89.alltypes.smallint_col, test_fuzz_alltypes_7a856c89.alltypes.int_col, test_fuzz_alltypes_7a856c89.alltypes.bigint_col, test_fuzz_alltypes_7a856c89.alltypes.float_col, test_fuzz_alltypes_7a856c89.alltypes.double_col, test_fuzz_alltypes_7a856c89.alltypes.date_string_col, test_fuzz_alltypes_7a856c89.alltypes.string_col, test_fuzz_alltypes_7a856c89.alltypes.timestamp_col, test_fuzz_alltypes_7a856c89.alltypes.year, test_fuzz_alltypes_7a856c89.alltypes.month | hosts=3 per-host-mem=128.00MB | tuple-ids=1 row-size=86B cardinality=unavailable | 00:SCAN HDFS [test_fuzz_alltypes_7a856c89.alltypes, RANDOM] partitions=24/24 files=24 size=90.01KB table stats: unavailable columns missing stats: id, bool_col, tinyint_col, smallint_col, int_col, bigint_col, float_col, double_col, date_string_col, string_col, timestamp_col hosts=3 per-host-mem=160.00MB tuple-ids=0 row-size=86B cardinality=unavailable ---------------- Estimated Per-Host Mem: 436207616 Estimated Per-Host VCores: 2 Tables Missing Stats: test_fuzz_alltypes_7a856c89.alltypes Request Pool: default-pool Admission result: Admitted immediately Planner Timeline: 3.215ms - Analysis finished: 951.750us (951.750us) - Equivalence classes computed: 1.158ms (206.993us) - Single node plan created: 1.954ms (795.875us) - Runtime filters computed: 1.984ms (30.259us) - Distributed plan created: 2.170ms (185.546us) - Planning finished: 3.215ms (1.044ms) Query Timeline: 61h44m - Query submitted: 0.000ns (0.000ns) - Planning finished: 5.000ms (5.000ms) - Submit for admission: 22.000ms (17.000ms) - Completed admission: 22.000ms (0.000ns) - Ready to start 7 fragment instances: 30.000ms (8.000ms) - All 7 fragment instances started: 330.004ms (300.004ms) - ComputeScanRangeAssignmentTimer: 15.000ms ImpalaServer: - ClientFetchWaitTimer: 0.000ns - RowMaterializationTimer: 0.000ns Execution Profile 5e428bfb76c86974:ba5508400000000:(Total: 308.004ms, non-child: 0.000ns, % non-child: 0.00%) Number of filters: 0 Filter routing table: ID Src. Node Tgt. Node(s) Targets Target type Partition filter Pending (Expected) First arrived Completed Enabled ---------------------------------------------------------------------------------------------------------------------------- Fragment instance start latencies: Count: 7, min / max: 3ms / 298ms, 25th %-ile: 4ms, 50th %-ile: 5ms, 75th %-ile: 6ms, 90th %-ile: 9ms, 95th %-ile: 298ms, 99.9th %-ile: 298ms - FiltersReceived: 0 (0) - FinalizationTimer: 0.000ns Coordinator Fragment F02: Instance 5e428bfb76c86974:ba5508400000000 (host=impala-boost-static-burst-slave-1106.vpc.cloudera.com:22000):(Total: 1.000ms, non-child: 1.000ms, % non-child: 100.00%) MemoryUsage(1h8m): 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB, 12.26 KB - AverageThreadTokens: 0.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 12.26 KB (12552) - PerHostPeakMemUsage: 3.62 MB (3795591) - RowsProduced: 0 (0) - TotalNetworkReceiveTime: 1s275ms - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 0.000ns - TotalThreadsInvoluntaryContextSwitches: 0 (0) - TotalThreadsTotalWallClockTime: 0.000ns - TotalThreadsSysTime: 0.000ns - TotalThreadsUserTime: 0.000ns - TotalThreadsVoluntaryContextSwitches: 0 (0) Fragment Instance Lifecycle Timings: - OpenTime: 0.000ns - ExecTreeOpenTime: 0.000ns - PrepareTime: 1.000ms - ExecTreePrepareTime: 0.000ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 48 (48) - BlocksRecycled: 0 (0) - BufferedPins: 0 (0) - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 409.60 MB (429496736) - PeakMemoryUsage: 512.00 KB (524288) - ScratchBytesRead: 0 - ScratchBytesWritten: 0 - ScratchFileUsedBytes: 0 - ScratchReads: 0 (0) - ScratchWrites: 0 (0) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalReadBlockTime: 0.000ns PLAN_ROOT_SINK: - PeakMemoryUsage: 0 AGGREGATION_NODE (id=6): ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN - BuildTime: 0.000ns - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 12.12 KB (12416) - RowsRepartitioned: 0 (0) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) EXCHANGE_NODE (id=5):(Total: 1s275ms, non-child: 0.000ns, % non-child: 0.00%) BytesReceived(1h8m): 15.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B, 16.00 B - BytesReceived: 16.00 B (16) - ConvertRowBatchTime: 0.000ns - DeserializeRowBatchTimer: 0.000ns - FirstBatchArrivalWaitTime: 1s275ms - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 0 - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns Averaged Fragment F01:(Total: 428.672ms, non-child: 8.666ms, % non-child: 2.02%) split sizes: min: 0, max: 0, avg: 0, stddev: 0 - AverageThreadTokens: 1.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 2.31 MB (2424770) - PerHostPeakMemUsage: 3.67 MB (3850113) - RowsProduced: 0 (0) - TotalNetworkReceiveTime: 554.008ms - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 0.000ns - TotalThreadsInvoluntaryContextSwitches: 0 (0) - TotalThreadsTotalWallClockTime: 421.006ms - TotalThreadsSysTime: 0.000ns - TotalThreadsUserTime: 666.666us - TotalThreadsVoluntaryContextSwitches: 4 (4) Fragment Instance Lifecycle Timings: - ExecTime: 0.000ns - ExecTreeExecTime: 0.000ns - OpenTime: 421.006ms - ExecTreeOpenTime: 418.672ms - PrepareTime: 7.666ms - ExecTreePrepareTime: 1.333ms DataStreamSender (dst_id=5): - BytesSent: 5.00 B (5) - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 16.00 KB (16384) - RowsReturned: 0 (0) - SerializeBatchTime: 0.000ns - TransmitDataRPCTime: 0.000ns - UncompressedRowBatchSize: 5.00 B (5) AGGREGATION_NODE (id=2):(Total: 420.006ms, non-child: 0.000ns, % non-child: 0.00%) - BuildTime: 0.000ns - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 8.04 KB (8234) - RowsRepartitioned: 0 (0) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) AGGREGATION_NODE (id=4):(Total: 420.006ms, non-child: 0.000ns, % non-child: 0.00%) - BuildTime: 333.338us - GetNewBlockTime: 333.338us - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 5.46K (5461) - LargestPartitionPercent: 2 (2) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.27 MB (2379127) - PinTime: 0.000ns - RowsRepartitioned: 0 (0) - RowsReturned: 200 (200) - RowsReturnedRate: 159.00 /sec - SpilledPartitions: 0 (0) - UnpinTime: 0.000ns EXCHANGE_NODE (id=3):(Total: 554.008ms, non-child: 554.008ms, % non-child: 100.00%) - BytesReceived: 20.36 KB (20845) - ConvertRowBatchTime: 0.000ns - DeserializeRowBatchTimer: 0.000ns - FirstBatchArrivalWaitTime: 168.335ms - PeakMemoryUsage: 0 - RowsReturned: 382 (382) - RowsReturnedRate: 1.41 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 48 (48) - BlocksRecycled: 0 (0) - BufferedPins: 0 (0) - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 409.60 MB (429496736) - PeakMemoryUsage: 512.00 KB (524288) - ScratchBytesRead: 0 - ScratchBytesWritten: 0 - ScratchFileUsedBytes: 0 - ScratchReads: 0 (0) - ScratchWrites: 0 (0) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalReadBlockTime: 0.000ns Fragment F01: Instance 5e428bfb76c86974:ba5508400000004 (host=impala-boost-static-burst-slave-1106.vpc.cloudera.com:22002):(Total: 1s283ms, non-child: 25.000ms, % non-child: 1.95%) MemoryUsage(500.000ms): 2.29 MB, 2.29 MB, 2.29 MB ThreadUsage(500.000ms): 1, 1, 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 2.31 MB (2424746) - PerHostPeakMemUsage: 3.72 MB (3901427) - RowsProduced: 1 (1) - TotalNetworkReceiveTime: 1s255ms - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 0.000ns - TotalThreadsInvoluntaryContextSwitches: 0 (0) - TotalThreadsTotalWallClockTime: 1s263ms - TotalThreadsSysTime: 0.000ns - TotalThreadsUserTime: 2.000ms - TotalThreadsVoluntaryContextSwitches: 14 (14) Fragment Instance Lifecycle Timings: - ExecTime: 0.000ns - ExecTreeExecTime: 0.000ns - OpenTime: 1s263ms - ExecTreeOpenTime: 1s256ms - PrepareTime: 20.000ms - ExecTreePrepareTime: 2.000ms DataStreamSender (dst_id=5): - BytesSent: 16.00 B (16) - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 16.00 KB (16384) - RowsReturned: 1 (1) - SerializeBatchTime: 0.000ns - TransmitDataRPCTime: 0.000ns - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=2):(Total: 1s258ms, non-child: 0.000ns, % non-child: 0.00%) ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN - BuildTime: 0.000ns - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 8.12 KB (8320) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) AGGREGATION_NODE (id=4):(Total: 1s258ms, non-child: 3.000ms, % non-child: 0.24%) ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN - BuildTime: 0.000ns - GetNewBlockTime: 1.000ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 16.38K (16384) - LargestPartitionPercent: 7 (7) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.27 MB (2379130) - PinTime: 0.000ns - RowsRepartitioned: 0 (0) - RowsReturned: 602 (602) - RowsReturnedRate: 478.00 /sec - SpilledPartitions: 0 (0) - UnpinTime: 0.000ns EXCHANGE_NODE (id=3):(Total: 1s255ms, non-child: 0.000ns, % non-child: 0.00%) BytesReceived(500.000ms): 16.95 KB, 23.74 KB, 23.74 KB - BytesReceived: 27.75 KB (28412) - ConvertRowBatchTime: 0.000ns - DeserializeRowBatchTimer: 0.000ns - FirstBatchArrivalWaitTime: 98.001ms - PeakMemoryUsage: 0 - RowsReturned: 602 (602) - RowsReturnedRate: 479.00 /sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns Instance 5e428bfb76c86974:ba5508400000005 (host=impala-boost-static-burst-slave-1106.vpc.cloudera.com:22001):(Total: 1.000ms, non-child: 0.000ns, % non-child: 0.00%) MemoryUsage(1h8m): 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB, 2.31 MB ThreadUsage(1h8m): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 2.31 MB (2424801) - PerHostPeakMemUsage: 3.67 MB (3853323) - RowsProduced: 0 (0) - TotalNetworkReceiveTime: 290.004ms - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 0.000ns - TotalThreadsInvoluntaryContextSwitches: 0 (0) - TotalThreadsTotalWallClockTime: 0.000ns - TotalThreadsSysTime: 0.000ns - TotalThreadsUserTime: 0.000ns - TotalThreadsVoluntaryContextSwitches: 0 (0) Fragment Instance Lifecycle Timings: - OpenTime: 0.000ns - ExecTreeOpenTime: 0.000ns - PrepareTime: 1.000ms - ExecTreePrepareTime: 1.000ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 48 (48) - BlocksRecycled: 0 (0) - BufferedPins: 0 (0) - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 409.60 MB (429496736) - PeakMemoryUsage: 512.00 KB (524288) - ScratchBytesRead: 0 - ScratchBytesWritten: 0 - ScratchFileUsedBytes: 0 - ScratchReads: 0 (0) - ScratchWrites: 0 (0) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalReadBlockTime: 0.000ns DataStreamSender (dst_id=5): - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 16.00 KB (16384) - RowsReturned: 0 (0) - SerializeBatchTime: 0.000ns - TransmitDataRPCTime: 0.000ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=2):(Total: 1.000ms, non-child: 0.000ns, % non-child: 0.00%) ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN - BuildTime: 0.000ns - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 8.00 KB (8192) - RowsRepartitioned: 0 (0) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) AGGREGATION_NODE (id=4):(Total: 1.000ms, non-child: 0.000ns, % non-child: 0.00%) ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN - BuildTime: 1.000ms - GetNewBlockTime: 0.000ns - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.27 MB (2379121) - PinTime: 0.000ns - RowsRepartitioned: 0 (0) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 0.000ns EXCHANGE_NODE (id=3):(Total: 290.004ms, non-child: 0.000ns, % non-child: 0.00%) BytesReceived(1h8m): 16.62 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB, 16.63 KB - BytesReceived: 16.63 KB (17025) - ConvertRowBatchTime: 0.000ns - DeserializeRowBatchTimer: 0.000ns - FirstBatchArrivalWaitTime: 290.004ms - PeakMemoryUsage: 0 - RowsReturned: 182 (182) - RowsReturnedRate: 627.00 /sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns Instance 5e428bfb76c86974:ba5508400000006 (host=impala-boost-static-burst-slave-1106.vpc.cloudera.com:22000):(Total: 2.000ms, non-child: 1.000ms, % non-child: 50.00%) MemoryUsage(1h8m): 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB, 2.29 MB ThreadUsage(1h8m): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 2.31 MB (2424764) - PerHostPeakMemUsage: 3.62 MB (3795591) - RowsProduced: 0 (0) - TotalNetworkReceiveTime: 117.001ms - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 0.000ns - TotalThreadsInvoluntaryContextSwitches: 0 (0) - TotalThreadsTotalWallClockTime: 0.000ns - TotalThreadsSysTime: 0.000ns - TotalThreadsUserTime: 0.000ns - TotalThreadsVoluntaryContextSwitches: 0 (0) Fragment Instance Lifecycle Timings: - OpenTime: 0.000ns - ExecTreeOpenTime: 0.000ns - PrepareTime: 2.000ms - ExecTreePrepareTime: 1.000ms DataStreamSender (dst_id=5): - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 16.00 KB (16384) - RowsReturned: 0 (0) - SerializeBatchTime: 0.000ns - TransmitDataRPCTime: 0.000ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=2):(Total: 1.000ms, non-child: 0.000ns, % non-child: 0.00%) ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN - BuildTime: 0.000ns - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 8.00 KB (8192) - RowsRepartitioned: 0 (0) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) AGGREGATION_NODE (id=4):(Total: 1.000ms, non-child: 0.000ns, % non-child: 0.00%) ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN - BuildTime: 0.000ns - GetNewBlockTime: 0.000ns - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.27 MB (2379130) - PinTime: 0.000ns - RowsRepartitioned: 0 (0) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) - UnpinTime: 0.000ns EXCHANGE_NODE (id=3):(Total: 117.001ms, non-child: 0.000ns, % non-child: 0.00%) BytesReceived(1h8m): 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB, 16.70 KB - BytesReceived: 16.70 KB (17099) - ConvertRowBatchTime: 0.000ns - DeserializeRowBatchTimer: 0.000ns - FirstBatchArrivalWaitTime: 117.001ms - PeakMemoryUsage: 0 - RowsReturned: 364 (364) - RowsReturnedRate: 3.11 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns Averaged Fragment F00:(Total: 110.668ms, non-child: 0.000ns, % non-child: 0.00%) split sizes: min: 26.10 KB, max: 37.80 KB, avg: 30.00 KB, stddev: 5.51 KB - AverageThreadTokens: 0.67 - BloomFilterBytes: 0 - PeakMemoryUsage: 1.38 MB (1442080) - PerHostPeakMemUsage: 3.67 MB (3850113) - RowsProduced: 597 (597) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 55.334ms - TotalStorageWaitTime: 599.342ms - TotalThreadsInvoluntaryContextSwitches: 240 (240) - TotalThreadsTotalWallClockTime: 1s271ms - TotalThreadsSysTime: 161.974ms - TotalThreadsUserTime: 38.658ms - TotalThreadsVoluntaryContextSwitches: 83 (83) Fragment Instance Lifecycle Timings: - ExecTime: 90.334ms - ExecTreeExecTime: 422.339ms - OpenTime: 3.333ms - ExecTreeOpenTime: 0.000ns - PrepareTime: 17.000ms - ExecTreePrepareTime: 1.333ms DataStreamSender (dst_id=3):(Total: 333.338us, non-child: 333.338us, % non-child: 100.00%) - BytesSent: 21.74 KB (22259) - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 2.65 MB/sec - PeakMemoryUsage: 44.27 KB (45328) - RowsReturned: 597 (597) - SerializeBatchTime: 0.000ns - TransmitDataRPCTime: 0.000ns - UncompressedRowBatchSize: 47.94 KB (49088) AGGREGATION_NODE (id=1):(Total: 423.672ms, non-child: 5.333ms, % non-child: 1.26%) - GetNewBlockTime: 0.000ns - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 10.92K (10922) - LargestPartitionPercent: 5 (5) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 1.27 MB (1334161) - PinTime: 0.000ns - ReductionFactorEstimate: 0.00 - ReductionFactorThresholdToExpand: 0.00 - RowsPassedThrough: 0 (0) - RowsReturned: 597 (597) - RowsReturnedRate: 5.40 K/sec - StreamingTime: 666.676us - UnpinTime: 0.000ns HDFS_SCAN_NODE (id=0):(Total: 418.339ms, non-child: 418.339ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 1.00 - BytesRead: 32.35 KB (33123) - BytesReadDataNodeCache: 0 - BytesReadLocal: 32.35 KB (33123) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 32.35 KB (33123) - DecompressionTime: 93.334ms - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 3 (3) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 122.12 KB (125048) - PerReadThreadRawHdfsThroughput: 0.00 /sec - RemoteScanRanges: 0 (0) - RowBatchQueueGetWaitTime: 405.672ms - RowBatchQueuePutWaitTime: 0.000ns - RowsRead: 610 (610) - RowsReturned: 610 (610) - RowsReturnedRate: 6.33 K/sec - ScanRangesComplete: 8 (8) - ScannerThreadsInvoluntaryContextSwitches: 241 (241) - ScannerThreadsTotalWallClockTime: 1s177ms - DelimiterParseTime: 666.676us - MaterializeTupleTime(*): 666.676us - ScannerThreadsSysTime: 161.974ms - ScannerThreadsUserTime: 37.659ms - ScannerThreadsVoluntaryContextSwitches: 66 (66) - TotalRawHdfsReadTime(*): 0.000ns - TotalReadThroughput: 667.00 B/sec BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 48 (48) - BlocksRecycled: 0 (0) - BufferedPins: 0 (0) - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 409.60 MB (429496736) - PeakMemoryUsage: 512.00 KB (524288) - ScratchBytesRead: 0 - ScratchBytesWritten: 0 - ScratchFileUsedBytes: 0 - ScratchReads: 0 (0) - ScratchWrites: 0 (0) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalReadBlockTime: 0.000ns Fragment F00: Instance 5e428bfb76c86974:ba5508400000003 (host=impala-boost-static-burst-slave-1106.vpc.cloudera.com:22000):(Total: 287.004ms, non-child: 89.001ms, % non-child: 31.01%) Hdfs split stats (:<# splits>/): 1:4/20.83 KB 2:4/5.28 KB - AverageThreadTokens: 0.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 1.32 MB (1381981) - PerHostPeakMemUsage: 3.62 MB (3795591) - RowsProduced: 0 (0) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 21.000ms - TotalThreadsInvoluntaryContextSwitches: 271 (271) - TotalThreadsTotalWallClockTime: 645.009ms - TotalThreadsSysTime: 222.965ms - TotalThreadsUserTime: 43.991ms - TotalThreadsVoluntaryContextSwitches: 91 (91) Fragment Instance Lifecycle Timings: - ExecTime: 271.003ms - ExecTreeExecTime: 197.002ms - OpenTime: 0.000ns - ExecTreeOpenTime: 0.000ns - PrepareTime: 16.000ms - ExecTreePrepareTime: 1.000ms DataStreamSender (dst_id=3): - BytesSent: 0 - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 4.27 KB (4368) - RowsReturned: 0 (0) - SerializeBatchTime: 0.000ns - TransmitDataRPCTime: 0.000ns - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=1):(Total: 198.002ms, non-child: 3.000ms, % non-child: 1.52%) ExecOption: Streaming Preaggregation, Codegen Disabled: disabled by query option DISABLE_CODEGEN - GetNewBlockTime: 0.000ns - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 1.26 MB (1320728) - PinTime: 0.000ns - ReductionFactorEstimate: 0.00 - ReductionFactorThresholdToExpand: 0.00 - RowsPassedThrough: 0 (0) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - StreamingTime: 0.000ns - UnpinTime: 0.000ns HDFS_SCAN_NODE (id=0):(Total: 195.002ms, non-child: 195.002ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 1:4/20.83 KB 2:4/5.28 KB ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN, Codegen enabled: 0 out of 16 Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% File Formats: TEXT/LZO:8 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 28.46 KB (29141) - BytesReadDataNodeCache: 0 - BytesReadLocal: 28.46 KB (29141) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 28.46 KB (29141) - DecompressionTime: 104.001ms - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 3 (3) - NumScannerThreadsStarted: 2 (2) - PeakMemoryUsage: 63.43 KB (64949) - PerReadThreadRawHdfsThroughput: 0.00 /sec - RemoteScanRanges: 0 (0) - RowBatchQueueGetWaitTime: 194.002ms - RowBatchQueuePutWaitTime: 0.000ns - RowsRead: 0 (0) - RowsReturned: 0 (0) - RowsReturnedRate: 0 - ScanRangesComplete: 8 (8) - ScannerThreadsInvoluntaryContextSwitches: 271 (271) - ScannerThreadsTotalWallClockTime: 374.005ms - DelimiterParseTime: 0.000ns - MaterializeTupleTime(*): 0.000ns - ScannerThreadsSysTime: 222.965ms - ScannerThreadsUserTime: 41.992ms - ScannerThreadsVoluntaryContextSwitches: 48 (48) - TotalRawHdfsReadTime(*): 0.000ns - TotalReadThroughput: 0.00 /sec Instance 5e428bfb76c86974:ba5508400000002 (host=impala-boost-static-burst-slave-1106.vpc.cloudera.com:22001):(Total: 11.000ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 2:2/10.47 KB 1:2/5.74 KB 0:4/9.89 KB MemoryUsage(1h8m): 18.20 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB, 18.04 KB ThreadUsage(1h8m): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 1.36 MB (1428522) - PerHostPeakMemUsage: 3.67 MB (3853323) - RowsProduced: 300 (300) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 1.000ms - TotalStorageWaitTime: 1s749ms - TotalThreadsInvoluntaryContextSwitches: 240 (240) - TotalThreadsTotalWallClockTime: 2s903ms - TotalThreadsSysTime: 187.970ms - TotalThreadsUserTime: 41.992ms - TotalThreadsVoluntaryContextSwitches: 78 (78) Fragment Instance Lifecycle Timings: - ExecTime: 0.000ns - ExecTreeExecTime: 977.014ms - OpenTime: 1.000ms - ExecTreeOpenTime: 0.000ns - PrepareTime: 10.000ms - ExecTreePrepareTime: 2.000ms DataStreamSender (dst_id=3):(Total: 1.000ms, non-child: 1.000ms, % non-child: 100.00%) - BytesSent: 8.14 KB (8340) - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 7.95 MB/sec - PeakMemoryUsage: 40.27 KB (41232) - RowsReturned: 300 (300) - SerializeBatchTime: 0.000ns - TransmitDataRPCTime: 0.000ns - UncompressedRowBatchSize: 19.62 KB (20093) AGGREGATION_NODE (id=1):(Total: 979.014ms, non-child: 1.000ms, % non-child: 0.10%) ExecOption: Streaming Preaggregation, Codegen Disabled: disabled by query option DISABLE_CODEGEN - GetNewBlockTime: 0.000ns - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 16.38K (16384) - LargestPartitionPercent: 8 (8) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 1.28 MB (1340547) - PinTime: 0.000ns - ReductionFactorEstimate: 0.00 - ReductionFactorThresholdToExpand: 0.00 - RowsPassedThrough: 0 (0) - RowsReturned: 300 (300) - RowsReturnedRate: 306.00 /sec - StreamingTime: 0.000ns - UnpinTime: 0.000ns HDFS_SCAN_NODE (id=0):(Total: 978.014ms, non-child: 978.014ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 2:2/10.47 KB 1:2/5.74 KB 0:4/9.89 KB ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN, Codegen enabled: 0 out of 16 Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% File Formats: TEXT/LZO:8 BytesRead(500.000ms): 1.76 KB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 3.00 - BytesRead: 28.44 KB (29126) - BytesReadDataNodeCache: 0 - BytesReadLocal: 28.44 KB (29126) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 28.44 KB (29126) - DecompressionTime: 69.001ms - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 4 (4) - NumScannerThreadsStarted: 4 (4) - PeakMemoryUsage: 108.88 KB (111490) - PerReadThreadRawHdfsThroughput: 0.00 /sec - RemoteScanRanges: 0 (0) - RowBatchQueueGetWaitTime: 955.013ms - RowBatchQueuePutWaitTime: 0.000ns - RowsRead: 300 (300) - RowsReturned: 300 (300) - RowsReturnedRate: 306.00 /sec - ScanRangesComplete: 8 (8) - ScannerThreadsInvoluntaryContextSwitches: 240 (240) - ScannerThreadsTotalWallClockTime: 2s902ms - DelimiterParseTime: 0.000ns - MaterializeTupleTime(*): 1.000ms - ScannerThreadsSysTime: 187.970ms - ScannerThreadsUserTime: 41.992ms - ScannerThreadsVoluntaryContextSwitches: 73 (73) - TotalRawHdfsReadTime(*): 0.000ns - TotalReadThroughput: 1.96 KB/sec Instance 5e428bfb76c86974:ba5508400000001 (host=impala-boost-static-burst-slave-1106.vpc.cloudera.com:22002):(Total: 34.000ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 0:4/20.75 KB 2:4/17.05 KB MemoryUsage(1h8m): 46.08 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB, 46.04 KB ThreadUsage(1h8m): 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 1.45 MB (1515739) - PerHostPeakMemUsage: 3.72 MB (3901427) - RowsProduced: 1.49K (1493) - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 165.002ms - TotalStorageWaitTime: 28.000ms - TotalThreadsInvoluntaryContextSwitches: 211 (211) - TotalThreadsTotalWallClockTime: 266.003ms - TotalThreadsSysTime: 74.987ms - TotalThreadsUserTime: 29.993ms - TotalThreadsVoluntaryContextSwitches: 82 (82) Fragment Instance Lifecycle Timings: - ExecTime: 0.000ns - ExecTreeExecTime: 93.001ms - OpenTime: 9.000ms - ExecTreeOpenTime: 0.000ns - PrepareTime: 25.000ms - ExecTreePrepareTime: 1.000ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 48 (48) - BlocksRecycled: 0 (0) - BufferedPins: 0 (0) - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 409.60 MB (429496736) - PeakMemoryUsage: 512.00 KB (524288) - ScratchBytesRead: 0 - ScratchBytesWritten: 0 - ScratchFileUsedBytes: 0 - ScratchReads: 0 (0) - ScratchWrites: 0 (0) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalReadBlockTime: 0.000ns DataStreamSender (dst_id=3): - BytesSent: 57.07 KB (58437) - NetworkThroughput(*): 0.00 /sec - OverallThroughput: 0.00 /sec - PeakMemoryUsage: 88.27 KB (90384) - RowsReturned: 1.49K (1493) - SerializeBatchTime: 0.000ns - TransmitDataRPCTime: 0.000ns - UncompressedRowBatchSize: 124.19 KB (127172) AGGREGATION_NODE (id=1):(Total: 94.001ms, non-child: 12.000ms, % non-child: 12.77%) ExecOption: Streaming Preaggregation, Codegen Disabled: disabled by query option DISABLE_CODEGEN - GetNewBlockTime: 0.000ns - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 16.38K (16384) - LargestPartitionPercent: 7 (7) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 1.28 MB (1341208) - PinTime: 0.000ns - ReductionFactorEstimate: 0.00 - ReductionFactorThresholdToExpand: 0.00 - RowsPassedThrough: 0 (0) - RowsReturned: 1.49K (1493) - RowsReturnedRate: 15.88 K/sec - StreamingTime: 2.000ms - UnpinTime: 0.000ns HDFS_SCAN_NODE (id=0):(Total: 82.001ms, non-child: 82.001ms, % non-child: 100.00%) Hdfs split stats (:<# splits>/): 0:4/20.75 KB 2:4/17.05 KB ExecOption: Codegen Disabled: disabled by query option DISABLE_CODEGEN, Codegen enabled: 0 out of 16 Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% File Formats: TEXT/LZO:8 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 40.14 KB (41103) - BytesReadDataNodeCache: 0 - BytesReadLocal: 40.14 KB (41103) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 40.14 KB (41103) - DecompressionTime: 107.001ms - MaxCompressedTextFileLength: 0 - NumDisksAccessed: 2 (2) - NumScannerThreadsStarted: 4 (4) - PeakMemoryUsage: 194.05 KB (198707) - PerReadThreadRawHdfsThroughput: 0.00 /sec - RemoteScanRanges: 0 (0) - RowBatchQueueGetWaitTime: 68.000ms - RowBatchQueuePutWaitTime: 0.000ns - RowsRead: 1.53K (1531) - RowsReturned: 1.53K (1531) - RowsReturnedRate: 18.67 K/sec - ScanRangesComplete: 8 (8) - ScannerThreadsInvoluntaryContextSwitches: 212 (212) - ScannerThreadsTotalWallClockTime: 257.003ms - DelimiterParseTime: 2.000ms - MaterializeTupleTime(*): 1.000ms - ScannerThreadsSysTime: 74.987ms - ScannerThreadsUserTime: 28.993ms - ScannerThreadsVoluntaryContextSwitches: 79 (79) - TotalRawHdfsReadTime(*): 0.000ns - TotalReadThroughput: 0.00 /sec