Query (id=1f4d282fbb90c626:5e0e124353e007a3): Summary: Session ID: e5499476db360fb0:6fd0898bd868689c Session Type: BEESWAX Start Time: 2016-02-16 13:00:14.326468000 End Time: 2016-02-16 13:00:15.859549000 Query Type: QUERY Query State: FINISHED Query Status: OK Impala Version: impalad version 2.5.0-cdh5-INTERNAL RELEASE (build 6e414261d589ed73c58aad9dfe299288703b9730) User: mmokhtar Connected User: mmokhtar Delegated User: Network Address: 10.20.122.102:53271 Default Db: tpch_1000_decimal_parquet Sql Statement: select count(*) from customer, nation n1, region where c_nationkey = n1.n_nationkey and n1.n_regionkey = r_regionkey and r_name = 'AMERICA' Coordinator: d2402.halxg.cloudera.com:22000 Query Options (non default): EXPLAIN_LEVEL=2,NUM_SCANNER_THREADS=24,ENABLE_RUNTIME_FILTER_PROPAGATION=1,RUNTIME_FILTER_WAIT_TIME_MS=10000000 Plan: ---------------- Estimated Per-Host Requirements: Memory=98.00MB VCores=3 09:AGGREGATE [FINALIZE] | output: count:merge(*) | hosts=20 per-host-mem=unavailable | tuple-ids=3 row-size=8B cardinality=1 | 08:EXCHANGE [UNPARTITIONED] | hosts=20 per-host-mem=unavailable | tuple-ids=3 row-size=8B cardinality=1 | 05:AGGREGATE | output: count(*) | hosts=20 per-host-mem=10.00MB | tuple-ids=3 row-size=8B cardinality=1 | 04:HASH JOIN [INNER JOIN, BROADCAST] | hash predicates: n1.n_regionkey = r_regionkey | runtime filters: RF000 <- r_regionkey | hosts=20 per-host-mem=34B | tuple-ids=0,1,2 row-size=55B cardinality=30000000 | |--07:EXCHANGE [BROADCAST] | | hosts=1 per-host-mem=0B | | tuple-ids=2 row-size=31B cardinality=1 | | | 02:SCAN HDFS [tpch_1000_decimal_parquet.region, RANDOM] | partitions=1/1 files=1 size=910B | predicates: r_name = 'AMERICA' | table stats: 5 rows total | column stats: all | hosts=1 per-host-mem=32.00MB | tuple-ids=2 row-size=31B cardinality=1 | 03:HASH JOIN [INNER JOIN, BROADCAST] | hash predicates: c_nationkey = n1.n_nationkey | runtime filters: RF001 <- n1.n_nationkey | hosts=20 per-host-mem=441B | tuple-ids=0,1 row-size=24B cardinality=150000000 | |--06:EXCHANGE [BROADCAST] | | hosts=1 per-host-mem=0B | | tuple-ids=1 row-size=16B cardinality=25 | | | 01:SCAN HDFS [tpch_1000_decimal_parquet.nation n1, RANDOM] | partitions=1/1 files=1 size=2.19KB | runtime filters: RF000 -> n1.n_regionkey | table stats: 25 rows total | column stats: all | hosts=1 per-host-mem=32.00MB | tuple-ids=1 row-size=16B cardinality=25 | 00:SCAN HDFS [tpch_1000_decimal_parquet.customer, RANDOM] partitions=1/1 files=60 size=11.72GB runtime filters: RF001 -> c_nationkey table stats: 150000000 rows total column stats: all hosts=20 per-host-mem=88.00MB tuple-ids=0 row-size=8B cardinality=150000000 ---------------- Estimated Per-Host Mem: 102760923 Estimated Per-Host VCores: 3 Request Pool: default-pool ExecSummary: Operator #Hosts Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail ------------------------------------------------------------------------------------------------------------------------------ 09:AGGREGATE 1 187.071ms 187.071ms 1 1 92.00 KB -1.00 B FINALIZE 08:EXCHANGE 1 162.308us 162.308us 20 1 0 -1.00 B UNPARTITIONED 05:AGGREGATE 20 191.499ms 243.602ms 20 1 252.00 KB 10.00 MB 04:HASH JOIN 20 128.119ms 194.987ms 30.00M 30.00M 2.03 MB 34.00 B INNER JOIN, BROADCAST |--07:EXCHANGE 20 10.180us 19.074us 1 1 0 0 BROADCAST | 02:SCAN HDFS 1 5.410ms 5.410ms 1 1 55.00 KB 32.00 MB tpch_1000_decimal_parquet.r... 03:HASH JOIN 20 297.774ms 462.084ms 150.00M 150.00M 2.02 MB 441.00 B INNER JOIN, BROADCAST |--06:EXCHANGE 20 8.883us 13.628us 25 25 0 0 BROADCAST | 01:SCAN HDFS 1 4.814ms 4.814ms 25 25 46.00 KB 32.00 MB tpch_1000_decimal_parquet.n... 00:SCAN HDFS 20 34.240ms 64.555ms 150.00M 150.00M 13.96 MB 88.00 MB tpch_1000_decimal_parquet.c... Planner Timeline: 16.661ms - Analysis finished: 3.663ms (3.663ms) - Equivalence classes computed: 3.984ms (320.419us) - Single node plan created: 9.695ms (5.711ms) - Runtime filters computed: 9.917ms (221.986us) - Distributed plan created: 13.057ms (3.140ms) - Lineage info computed: 13.805ms (747.745us) - Planning finished: 16.661ms (2.855ms) Query Timeline: 1s544ms - Start execution: 53.708us (53.708us) - Planning finished: 19.433ms (19.379ms) - Ready to start 22 remote fragments: 206.849ms (187.416ms) - All 22 remote fragments started: 209.703ms (2.853ms) - First dynamic filter received: 859.296ms (649.592ms) - Rows available: 1s465ms (606.127ms) - First row fetched: 1s528ms (62.883ms) - Unregister query: 1s533ms (4.789ms) ImpalaServer: - ClientFetchWaitTimer: 64.345ms - RowMaterializationTimer: 18.204us Execution Profile 1f4d282fbb90c626:5e0e124353e007a3:(Total: 1s448ms, non-child: 0.000ns, % non-child: 0.00%) Number of filters: 2 Filter routing table: ------ Filter routing table ------ id: 1 src: 3 dst: 0 num. destinations: 20 num. pending: 1 id: 0 src: 4 dst: 1 num. destinations: 1 num. pending: 1 Fragment start latencies: Count: 22, 25th %-ile: 1ms, 50th %-ile: 1ms, 75th %-ile: 1ms, 90th %-ile: 1ms, 95th %-ile: 1ms, 99.9th %-ile: 2ms Final filter table: ------ Filter routing table ------ id: 1 src: 3 dst: 0 num. destinations: 20 num. pending: 0 id: 0 src: 4 dst: 1 num. destinations: 1 num. pending: 0 Per Node Peak Memory Usage: d2415.halxg.cloudera.com:22000(14.27 MB) d2408.halxg.cloudera.com:22000(15.36 MB) d2421.halxg.cloudera.com:22000(17.45 MB) d2403.halxg.cloudera.com:22000(15.70 MB) d2413.halxg.cloudera.com:22000(13.30 MB) d2406.halxg.cloudera.com:22000(15.31 MB) d2409.halxg.cloudera.com:22000(15.36 MB) d2419.halxg.cloudera.com:22000(15.95 MB) d2416.halxg.cloudera.com:22000(17.46 MB) d2414.halxg.cloudera.com:22000(16.45 MB) d2405.halxg.cloudera.com:22000(15.34 MB) d2412.halxg.cloudera.com:22000(15.34 MB) d2407.halxg.cloudera.com:22000(14.27 MB) d2418.halxg.cloudera.com:22000(15.34 MB) d2404.halxg.cloudera.com:22000(14.28 MB) d2420.halxg.cloudera.com:22000(14.27 MB) d2410.halxg.cloudera.com:22000(14.27 MB) d2411.halxg.cloudera.com:22000(15.31 MB) d2402.halxg.cloudera.com:22000(17.47 MB) d2417.halxg.cloudera.com:22000(14.28 MB) - FiltersReceived: 2 (2) - FinalizationTimer: 0.000ns Coordinator Fragment F03:(Total: 1s142ms, non-child: 0.000ns, % non-child: 0.00%) MemoryUsage(500.000ms): 0, 12.00 KB, 12.00 KB, 12.00 KB ThreadUsage(500.000ms): 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 100.02 KB (102416) - PerHostPeakMemUsage: 0 - PrepareTime: 186.085ms - RowsProduced: 1 (1) - TotalCpuTime: 553.336ms - TotalNetworkReceiveTime: 955.281ms - TotalNetworkSendTime: 0.000ns - TotalStorageWaitTime: 0.000ns BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 484.124ms, non-child: 484.124ms, % non-child: 100.00%) - CodegenTime: 593.240us - CompileTime: 2.780ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 295.787ms - PrepareTime: 183.745ms AGGREGATION_NODE (id=9):(Total: 1s142ms, non-child: 187.071ms, % non-child: 16.38%) ExecOption: Codegen Enabled - BuildTime: 11.618us - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 92.00 KB (94208) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 0 - SpilledPartitions: 0 (0) EXCHANGE_NODE (id=8):(Total: 955.338ms, non-child: 162.308us, % non-child: 0.02%) BytesReceived(500.000ms): 0, 0 - BytesReceived: 320.00 B (320) - ConvertRowBatchTime: 20.384us - DeserializeRowBatchTimer: 78.188us - FirstBatchArrivalWaitTime: 539.306ms - PeakMemoryUsage: 0 - RowsReturned: 20 (20) - RowsReturnedRate: 20.00 /sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns Averaged Fragment F00:(Total: 652.438ms, non-child: 0.000ns, % non-child: 0.00%) split sizes: min: 343.69 MB, max: 863.74 MB, avg: 600.14 MB, stddev: 112.06 MB completion times: min:840.698ms max:1s256ms mean: 1s065ms stddev:110.940ms execution rates: min:408.82 MB/sec max:687.86 MB/sec mean:560.21 MB/sec stddev:64.97 MB/sec num instances: 20 - AverageThreadTokens: 1.95 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 12.34 MB (12937462) - PerHostPeakMemUsage: 15.34 MB (16084419) - PrepareTime: 191.068ms - RowsProduced: 1 (1) - TotalCpuTime: 2s166ms - TotalNetworkReceiveTime: 6.918us - TotalNetworkSendTime: 263.482us - TotalStorageWaitTime: 22.796ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 596.175ms, non-child: 596.175ms, % non-child: 100.00%) - CodegenTime: 188.221us - CompileTime: 63.395ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 346.774ms - PrepareTime: 184.260ms DataStreamSender (dst_id=8):(Total: 35.629us, non-child: 35.629us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 92.92 KB/sec - OverallThroughput: 461.77 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 12.490us - ThriftTransmitTime(*): 174.875us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 651.639ms, non-child: 191.499ms, % non-child: 29.39%) - BuildTime: 6.158ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 219.22 KB (224486) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 460.140ms, non-child: 128.119ms, % non-child: 27.84%) - BuildPartitionTime: 3.220us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 3.545us - GetNewBlockTime: 222.935us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 7.50M (7500000) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 115.659ms - RowsReturned: 1.50M (1499792) - RowsReturnedRate: 3.32 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.263us EXCHANGE_NODE (id=7):(Total: 10.180us, non-child: 10.180us, % non-child: 100.00%) - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 1.175us - DeserializeRowBatchTimer: 6.028us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 101.99 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 332.024ms, non-child: 297.774ms, % non-child: 89.68%) - BuildPartitionTime: 3.550us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 6.392us - GetNewBlockTime: 75.342us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 7.50M (7500000) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 268.434ms - RowsReturned: 7.50M (7500000) - RowsReturnedRate: 23.18 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.117us EXCHANGE_NODE (id=6):(Total: 8.883us, non-child: 8.883us, % non-child: 100.00%) - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.527us - DeserializeRowBatchTimer: 10.208us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 2.86 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 34.240ms, non-child: 34.240ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 1.77 - BytesRead: 4.78 MB (5013211) - BytesReadDataNodeCache: 0 - BytesReadLocal: 4.78 MB (5013211) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 4.78 MB (5013211) - DecompressionTime: 1.481ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 3 (3) - NumRowGroups: 3 (3) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 11.85 MB (12420715) - PerReadThreadRawHdfsThroughput: 1.57 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 7.50M (7500000) - RowsReturned: 7.50M (7500000) - RowsReturnedRate: 225.05 M/sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 99 (99) - ScannerThreadsTotalWallClockTime: 1s087ms - MaterializeTupleTime(*): 1s059ms - ScannerThreadsSysTime: 7.847ms - ScannerThreadsUserTime: 394.188ms - ScannerThreadsVoluntaryContextSwitches: 6.92K (6922) - TotalRawHdfsReadTime(*): 3.288ms - TotalReadThroughput: 3.40 MB/sec Filter 1: - Rows processed: 49.15K (49149) - Rows rejected: 0 (0) - Rows total: 49.15K (49152) Averaged Fragment F02:(Total: 8.044ms, non-child: 2.501ms, % non-child: 31.10%) split sizes: min: 910.00 B, max: 910.00 B, avg: 910.00 B, stddev: 0 completion times: min:247.125ms max:247.125ms mean: 247.125ms stddev:0.000ns execution rates: min:3.60 KB/sec max:3.60 KB/sec mean:3.60 KB/sec stddev:0.00 /sec num instances: 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 143.00 KB (146432) - PerHostPeakMemUsage: 144.20 KB (147664) - PrepareTime: 102.952us - RowsProduced: 1 (1) - TotalCpuTime: 14.157ms - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 232.823ms - TotalStorageWaitTime: 4.876ms DataStreamSender (dst_id=7):(Total: 132.180us, non-child: 132.180us, % non-child: 100.00%) - BytesSent: 640.00 B (640) - NetworkThroughput(*): 177.00 B/sec - OverallThroughput: 4.62 MB/sec - PeakMemoryUsage: 80.00 KB (81920) - SerializeBatchTime: 14.740us - ThriftTransmitTime(*): 3s615ms - UncompressedRowBatchSize: 940.00 B (940) HDFS_SCAN_NODE (id=2):(Total: 5.410ms, non-child: 5.410ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 1.05 KB (1078) - BytesReadDataNodeCache: 0 - BytesReadLocal: 1.05 KB (1078) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 1.05 KB (1078) - DecompressionTime: 2.102us - MaxCompressedTextFileLength: 0 - NumColumns: 2 (2) - NumDisksAccessed: 1 (1) - NumRowGroups: 1 (1) - NumScannerThreadsStarted: 1 (1) - PeakMemoryUsage: 55.00 KB (56320) - PerReadThreadRawHdfsThroughput: 52.39 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 5 (5) - RowsReturned: 1 (1) - RowsReturnedRate: 184.00 /sec - ScanRangesComplete: 1 (1) - ScannerThreadsInvoluntaryContextSwitches: 0 (0) - ScannerThreadsTotalWallClockTime: 5.159ms - MaterializeTupleTime(*): 11.692us - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 0.000ns - ScannerThreadsVoluntaryContextSwitches: 8 (8) - TotalRawHdfsReadTime(*): 19.624us - TotalReadThroughput: 0.00 /sec Averaged Fragment F01:(Total: 8.311ms, non-child: 3.397ms, % non-child: 40.87%) split sizes: min: 2.19 KB, max: 2.19 KB, avg: 2.19 KB, stddev: 0 completion times: min:240.956ms max:240.956ms mean: 240.956ms stddev:0.000ns execution rates: min:9.09 KB/sec max:9.09 KB/sec mean:9.09 KB/sec stddev:0.00 /sec num instances: 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 160.56 KB (164416) - PerHostPeakMemUsage: 160.56 KB (164416) - PrepareTime: 88.664us - RowsProduced: 25 (25) - TotalCpuTime: 17.907ms - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 222.741ms - TotalStorageWaitTime: 4.283ms DataStreamSender (dst_id=6):(Total: 99.626us, non-child: 99.626us, % non-child: 100.00%) - BytesSent: 5.64 KB (5780) - NetworkThroughput(*): 1.59 KB/sec - OverallThroughput: 55.33 MB/sec - PeakMemoryUsage: 106.56 KB (109120) - SerializeBatchTime: 18.880us - ThriftTransmitTime(*): 3s547ms - UncompressedRowBatchSize: 13.75 KB (14080) HDFS_SCAN_NODE (id=1):(Total: 4.814ms, non-child: 4.814ms, % non-child: 100.00%) - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 2.44 KB (2497) - BytesReadDataNodeCache: 0 - BytesReadLocal: 2.44 KB (2497) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 2.44 KB (2497) - DecompressionTime: 2.738us - MaxCompressedTextFileLength: 0 - NumColumns: 2 (2) - NumDisksAccessed: 1 (1) - NumRowGroups: 1 (1) - NumScannerThreadsStarted: 1 (1) - PeakMemoryUsage: 46.00 KB (47104) - PerReadThreadRawHdfsThroughput: 121.34 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 25 (25) - RowsReturned: 25 (25) - RowsReturnedRate: 5.19 K/sec - ScanRangesComplete: 1 (1) - ScannerThreadsInvoluntaryContextSwitches: 0 (0) - ScannerThreadsTotalWallClockTime: 4.543ms - MaterializeTupleTime(*): 9.536us - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 0.000ns - ScannerThreadsVoluntaryContextSwitches: 8 (8) - TotalRawHdfsReadTime(*): 19.626us - TotalReadThroughput: 0.00 /sec Filter 0: - Rows processed: 25 (25) - Rows rejected: 0 (0) - Rows total: 25 (25) Fragment F00: Instance 1f4d282fbb90c626:5e0e124353e007b6 (host=d2421.halxg.cloudera.com:22000):(Total: 846.654ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 9:1/252.21 MB 1:1/252.18 MB 6:1/107.16 MB 2:1/252.20 MB MemoryUsage(500.000ms): 0, 14.28 MB, 13.16 MB ThreadUsage(500.000ms): 1, 5, 4 - AverageThreadTokens: 3.33 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 14.45 MB (15152168) - PerHostPeakMemUsage: 17.45 MB (18297896) - PrepareTime: 188.645ms - RowsProduced: 1 (1) - TotalCpuTime: 3s408ms - TotalNetworkReceiveTime: 6.740us - TotalNetworkSendTime: 324.092us - TotalStorageWaitTime: 29.356ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 590.147ms, non-child: 590.147ms, % non-child: 100.00%) - CodegenTime: 172.356us - CompileTime: 62.232ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 344.208ms - PrepareTime: 181.978ms DataStreamSender (dst_id=8):(Total: 26.924us, non-child: 26.924us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 69.44 KB/sec - OverallThroughput: 580.34 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 7.618us - ThriftTransmitTime(*): 225.014us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 845.843ms, non-child: 192.434ms, % non-child: 22.75%) ExecOption: Codegen Enabled - BuildTime: 8.769ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 236.00 KB (241664) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 653.409ms, non-child: 194.987ms, % non-child: 29.84%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.164us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 4.040us - GetNewBlockTime: 207.238us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 10.80M (10795660) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 177.140ms - RowsReturned: 2.16M (2156926) - RowsReturnedRate: 3.30 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.260us EXCHANGE_NODE (id=7):(Total: 10.004us, non-child: 10.004us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B, 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 1.084us - DeserializeRowBatchTimer: 5.704us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 99.96 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 458.425ms, non-child: 407.920ms, % non-child: 88.98%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.876us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 6.546us - GetNewBlockTime: 70.934us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 10.80M (10795660) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 375.102ms - RowsReturned: 10.80M (10795660) - RowsReturnedRate: 23.55 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.058us EXCHANGE_NODE (id=6):(Total: 8.430us, non-child: 8.430us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B, 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.384us - DeserializeRowBatchTimer: 10.132us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 2.97 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 50.497ms, non-child: 50.497ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 4 Hdfs split stats (:<# splits>/): 9:1/252.21 MB 1:1/252.18 MB 6:1/107.16 MB 2:1/252.20 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:4 BytesRead(500.000ms): 6.85 MB, 6.85 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 3.50 - BytesRead: 6.85 MB (7183483) - BytesReadDataNodeCache: 0 - BytesReadLocal: 6.85 MB (7183483) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 6.85 MB (7183483) - DecompressionTime: 2.036ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 4 (4) - NumRowGroups: 4 (4) - NumScannerThreadsStarted: 4 (4) - PeakMemoryUsage: 13.96 MB (14639128) - PerReadThreadRawHdfsThroughput: 1.14 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 10.80M (10795660) - RowsReturned: 10.80M (10795660) - RowsReturnedRate: 213.79 M/sec - ScanRangesComplete: 4 (4) - ScannerThreadsInvoluntaryContextSwitches: 169 (169) - ScannerThreadsTotalWallClockTime: 2s151ms - MaterializeTupleTime(*): 2s114ms - ScannerThreadsSysTime: 7.996ms - ScannerThreadsUserTime: 580.911ms - ScannerThreadsVoluntaryContextSwitches: 10.30K (10297) - TotalRawHdfsReadTime(*): 5.858ms - TotalReadThroughput: 6.85 MB/sec Filter 1: - Rows processed: 65.53K (65532) - Rows rejected: 0 (0) - Rows total: 65.54K (65536) Instance 1f4d282fbb90c626:5e0e124353e007b2 (host=d2419.halxg.cloudera.com:22000):(Total: 843.297ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 2:1/252.24 MB 0:1/116.02 MB 7:1/252.17 MB 8:1/51.50 MB MemoryUsage(500.000ms): 0, 60.20 KB, 11.13 MB ThreadUsage(500.000ms): 1, 1, 3 - AverageThreadTokens: 1.67 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 12.95 MB (13579280) - PerHostPeakMemUsage: 15.95 MB (16725008) - PrepareTime: 188.982ms - RowsProduced: 1 (1) - TotalCpuTime: 2s990ms - TotalNetworkReceiveTime: 6.216us - TotalNetworkSendTime: 205.664us - TotalStorageWaitTime: 28.429ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 594.691ms, non-child: 594.691ms, % non-child: 100.00%) - CodegenTime: 174.984us - CompileTime: 65.565ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 345.434ms - PrepareTime: 181.923ms DataStreamSender (dst_id=8):(Total: 49.434us, non-child: 49.434us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 91.16 KB/sec - OverallThroughput: 316.08 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 29.624us - ThriftTransmitTime(*): 171.406us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 842.578ms, non-child: 190.546ms, % non-child: 22.61%) ExecOption: Codegen Enabled - BuildTime: 6.811ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 236.00 KB (241664) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 652.031ms, non-child: 149.600ms, % non-child: 22.94%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 2.848us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 2.866us - GetNewBlockTime: 198.924us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 8.39M (8392999) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 135.961ms - RowsReturned: 1.68M (1679469) - RowsReturnedRate: 2.58 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.322us EXCHANGE_NODE (id=7):(Total: 8.606us, non-child: 8.606us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B, 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 1.152us - DeserializeRowBatchTimer: 5.448us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 116.20 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 502.434ms, non-child: 462.084ms, % non-child: 91.97%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.532us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 6.190us - GetNewBlockTime: 69.758us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 8.39M (8392999) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 434.912ms - RowsReturned: 8.39M (8392999) - RowsReturnedRate: 16.70 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.092us EXCHANGE_NODE (id=6):(Total: 8.726us, non-child: 8.726us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B, 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.240us - DeserializeRowBatchTimer: 9.340us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 2.87 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 40.341ms, non-child: 40.341ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 4 Hdfs split stats (:<# splits>/): 2:1/252.24 MB 0:1/116.02 MB 7:1/252.17 MB 8:1/51.50 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:4 BytesRead(500.000ms): 0, 5.41 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 2.00 - BytesRead: 5.41 MB (5676037) - BytesReadDataNodeCache: 0 - BytesReadLocal: 5.41 MB (5676037) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 5.41 MB (5676037) - DecompressionTime: 1.531ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 4 (4) - NumRowGroups: 4 (4) - NumScannerThreadsStarted: 4 (4) - PeakMemoryUsage: 12.46 MB (13066240) - PerReadThreadRawHdfsThroughput: 1.70 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 8.39M (8392999) - RowsReturned: 8.39M (8392999) - RowsReturnedRate: 208.05 M/sec - ScanRangesComplete: 4 (4) - ScannerThreadsInvoluntaryContextSwitches: 139 (139) - ScannerThreadsTotalWallClockTime: 1s730ms - MaterializeTupleTime(*): 1s696ms - ScannerThreadsSysTime: 8.996ms - ScannerThreadsUserTime: 565.912ms - ScannerThreadsVoluntaryContextSwitches: 7.96K (7957) - TotalRawHdfsReadTime(*): 3.116ms - TotalReadThroughput: 5.41 MB/sec Filter 1: - Rows processed: 65.53K (65532) - Rows rejected: 0 (0) - Rows total: 65.54K (65536) Instance 1f4d282fbb90c626:5e0e124353e007ae (host=d2414.halxg.cloudera.com:22000):(Total: 816.505ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 8:1/252.22 MB 6:1/95.31 MB 7:1/96.54 MB 2:1/252.16 MB MemoryUsage(500.000ms): 60.20 KB, 13.37 MB, 28.00 KB ThreadUsage(500.000ms): 1, 5, 1 - AverageThreadTokens: 2.33 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 13.45 MB (14103568) - PerHostPeakMemUsage: 16.45 MB (17249296) - PrepareTime: 188.820ms - RowsProduced: 1 (1) - TotalCpuTime: 2s986ms - TotalNetworkReceiveTime: 6.872us - TotalNetworkSendTime: 284.266us - TotalStorageWaitTime: 24.938ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 589.699ms, non-child: 589.699ms, % non-child: 100.00%) - CodegenTime: 181.014us - CompileTime: 62.204ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 343.733ms - PrepareTime: 181.979ms DataStreamSender (dst_id=8):(Total: 29.324us, non-child: 29.324us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 75.73 KB/sec - OverallThroughput: 532.84 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 9.276us - ThriftTransmitTime(*): 206.318us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 815.667ms, non-child: 189.745ms, % non-child: 23.26%) ExecOption: Codegen Enabled - BuildTime: 6.811ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 236.00 KB (241664) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 625.921ms, non-child: 137.899ms, % non-child: 22.03%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 2.848us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 2.788us - GetNewBlockTime: 218.474us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 8.70M (8696966) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 124.161ms - RowsReturned: 1.74M (1740333) - RowsReturnedRate: 2.78 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.162us EXCHANGE_NODE (id=7):(Total: 8.704us, non-child: 8.704us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B, 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 912.000ns - DeserializeRowBatchTimer: 4.916us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 114.89 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 488.025ms, non-child: 449.189ms, % non-child: 92.04%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.612us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 6.040us - GetNewBlockTime: 62.862us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 8.70M (8696966) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 421.211ms - RowsReturned: 8.70M (8696966) - RowsReturnedRate: 17.82 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.210us EXCHANGE_NODE (id=6):(Total: 9.364us, non-child: 9.364us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B, 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.536us - DeserializeRowBatchTimer: 9.168us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 2.67 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 38.826ms, non-child: 38.826ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 4 Hdfs split stats (:<# splits>/): 8:1/252.22 MB 6:1/95.31 MB 7:1/96.54 MB 2:1/252.16 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:4 BytesRead(500.000ms): 0, 5.59 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 4.00 - BytesRead: 5.59 MB (5866746) - BytesReadDataNodeCache: 0 - BytesReadLocal: 5.59 MB (5866746) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 5.59 MB (5866746) - DecompressionTime: 1.680ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 4 (4) - NumRowGroups: 4 (4) - NumScannerThreadsStarted: 4 (4) - PeakMemoryUsage: 12.96 MB (13590528) - PerReadThreadRawHdfsThroughput: 1.82 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 8.70M (8696966) - RowsReturned: 8.70M (8696966) - RowsReturnedRate: 224.00 M/sec - ScanRangesComplete: 4 (4) - ScannerThreadsInvoluntaryContextSwitches: 175 (175) - ScannerThreadsTotalWallClockTime: 1s754ms - MaterializeTupleTime(*): 1s722ms - ScannerThreadsSysTime: 10.996ms - ScannerThreadsUserTime: 616.904ms - ScannerThreadsVoluntaryContextSwitches: 8.19K (8190) - TotalRawHdfsReadTime(*): 3.010ms - TotalReadThroughput: 5.59 MB/sec Filter 1: - Rows processed: 65.53K (65532) - Rows rejected: 0 (0) - Rows total: 65.54K (65536) Instance 1f4d282fbb90c626:5e0e124353e007ad (host=d2402.halxg.cloudera.com:22000):(Total: 800.891ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 6:1/252.19 MB 8:1/252.20 MB 4:1/140.66 MB 1:1/96.47 MB MemoryUsage(500.000ms): 60.20 KB, 14.36 MB ThreadUsage(500.000ms): 1, 5 - AverageThreadTokens: 3.00 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 14.45 MB (15152144) - PerHostPeakMemUsage: 17.47 MB (18322456) - PrepareTime: 191.331ms - RowsProduced: 1 (1) - TotalCpuTime: 2s923ms - TotalNetworkReceiveTime: 9.382us - TotalNetworkSendTime: 153.094us - TotalStorageWaitTime: 98.190ms CodeGen:(Total: 610.635ms, non-child: 610.635ms, % non-child: 100.00%) - CodegenTime: 179.672us - CompileTime: 66.867ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 357.647ms - PrepareTime: 184.407ms DataStreamSender (dst_id=8):(Total: 25.590us, non-child: 25.590us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 121.63 KB/sec - OverallThroughput: 610.59 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 8.122us - ThriftTransmitTime(*): 128.460us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 800.181ms, non-child: 193.645ms, % non-child: 24.20%) ExecOption: Codegen Enabled - BuildTime: 7.806ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 236.00 KB (241664) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 606.536ms, non-child: 155.723ms, % non-child: 25.67%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 4.562us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 4.672us - GetNewBlockTime: 176.626us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 9.26M (9264909) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 141.227ms - RowsReturned: 1.85M (1852441) - RowsReturnedRate: 3.05 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.730us EXCHANGE_NODE (id=7):(Total: 13.854us, non-child: 13.854us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B, 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 1.456us - DeserializeRowBatchTimer: 8.284us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 72.18 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 450.816ms, non-child: 386.251ms, % non-child: 85.68%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.358us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 7.928us - GetNewBlockTime: 60.522us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 9.26M (9264909) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 308.294ms - RowsReturned: 9.26M (9264909) - RowsReturnedRate: 20.55 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.432us EXCHANGE_NODE (id=6):(Total: 9.478us, non-child: 9.478us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B, 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.810us - DeserializeRowBatchTimer: 11.724us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 2.64 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 64.555ms, non-child: 64.555ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 4 Hdfs split stats (:<# splits>/): 6:1/252.19 MB 8:1/252.20 MB 4:1/140.66 MB 1:1/96.47 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:4 BytesRead(500.000ms): 0, 5.93 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 4.00 - BytesRead: 5.93 MB (6223065) - BytesReadDataNodeCache: 0 - BytesReadLocal: 5.93 MB (6223065) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 5.93 MB (6223065) - DecompressionTime: 1.798ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 4 (4) - NumRowGroups: 4 (4) - NumScannerThreadsStarted: 4 (4) - PeakMemoryUsage: 13.96 MB (14639104) - PerReadThreadRawHdfsThroughput: 656.13 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 9.26M (9264909) - RowsReturned: 9.26M (9264909) - RowsReturnedRate: 143.52 M/sec - ScanRangesComplete: 4 (4) - ScannerThreadsInvoluntaryContextSwitches: 164 (164) - ScannerThreadsTotalWallClockTime: 1s652ms - MaterializeTupleTime(*): 1s539ms - ScannerThreadsSysTime: 2.998ms - ScannerThreadsUserTime: 455.930ms - ScannerThreadsVoluntaryContextSwitches: 8.79K (8788) - TotalRawHdfsReadTime(*): 9.045ms - TotalReadThroughput: 5.93 MB/sec Filter 1: - Rows processed: 65.53K (65532) - Rows rejected: 0 (0) - Rows total: 65.54K (65536) Instance 1f4d282fbb90c626:5e0e124353e007b0 (host=d2416.halxg.cloudera.com:22000):(Total: 732.053ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 7:1/252.21 MB 1:1/96.08 MB 2:1/150.93 MB 10:1/252.17 MB MemoryUsage(500.000ms): 60.20 KB, 14.33 MB ThreadUsage(500.000ms): 1, 5 - AverageThreadTokens: 3.00 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 14.46 MB (15160336) - PerHostPeakMemUsage: 17.46 MB (18306064) - PrepareTime: 188.309ms - RowsProduced: 1 (1) - TotalCpuTime: 2s715ms - TotalNetworkReceiveTime: 6.062us - TotalNetworkSendTime: 324.796us - TotalStorageWaitTime: 25.361ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 588.157ms, non-child: 588.157ms, % non-child: 100.00%) - CodegenTime: 182.106us - CompileTime: 62.682ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 342.106ms - PrepareTime: 181.599ms DataStreamSender (dst_id=8):(Total: 29.880us, non-child: 29.880us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 76.23 KB/sec - OverallThroughput: 522.92 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 9.326us - ThriftTransmitTime(*): 204.960us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 731.186ms, non-child: 190.371ms, % non-child: 26.04%) ExecOption: Codegen Enabled - BuildTime: 7.425ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 236.00 KB (241664) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 540.815ms, non-child: 161.425ms, % non-child: 29.85%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.040us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 2.896us - GetNewBlockTime: 182.018us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 9.39M (9390116) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 147.237ms - RowsReturned: 1.88M (1877490) - RowsReturnedRate: 3.47 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.232us EXCHANGE_NODE (id=7):(Total: 8.702us, non-child: 8.702us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B, 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 1.032us - DeserializeRowBatchTimer: 8.294us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 114.92 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 379.392ms, non-child: 342.046ms, % non-child: 90.16%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.398us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 6.414us - GetNewBlockTime: 59.918us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 9.39M (9390116) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 313.447ms - RowsReturned: 9.39M (9390116) - RowsReturnedRate: 24.75 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.274us EXCHANGE_NODE (id=6):(Total: 8.912us, non-child: 8.912us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B, 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.236us - DeserializeRowBatchTimer: 9.986us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 2.81 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 37.337ms, non-child: 37.337ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 4 Hdfs split stats (:<# splits>/): 7:1/252.21 MB 1:1/96.08 MB 2:1/150.93 MB 10:1/252.17 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:4 BytesRead(500.000ms): 0, 6.01 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 4.00 - BytesRead: 6.01 MB (6301640) - BytesReadDataNodeCache: 0 - BytesReadLocal: 6.01 MB (6301640) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 6.01 MB (6301640) - DecompressionTime: 1.849ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 4 (4) - NumRowGroups: 4 (4) - NumScannerThreadsStarted: 4 (4) - PeakMemoryUsage: 13.96 MB (14639104) - PerReadThreadRawHdfsThroughput: 1.86 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 9.39M (9390116) - RowsReturned: 9.39M (9390116) - RowsReturnedRate: 251.50 M/sec - ScanRangesComplete: 4 (4) - ScannerThreadsInvoluntaryContextSwitches: 142 (142) - ScannerThreadsTotalWallClockTime: 1s569ms - MaterializeTupleTime(*): 1s538ms - ScannerThreadsSysTime: 8.996ms - ScannerThreadsUserTime: 466.927ms - ScannerThreadsVoluntaryContextSwitches: 8.89K (8890) - TotalRawHdfsReadTime(*): 3.163ms - TotalReadThroughput: 6.01 MB/sec Filter 1: - Rows processed: 65.53K (65532) - Rows rejected: 0 (0) - Rows total: 65.54K (65536) Instance 1f4d282fbb90c626:5e0e124353e007ab (host=d2412.halxg.cloudera.com:22000):(Total: 720.257ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 9:1/252.19 MB 3:1/94.89 MB 10:1/252.21 MB MemoryUsage(500.000ms): 60.20 KB, 11.13 MB ThreadUsage(500.000ms): 1, 3 - AverageThreadTokens: 2.00 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 12.34 MB (12944424) - PerHostPeakMemUsage: 15.34 MB (16090152) - PrepareTime: 188.714ms - RowsProduced: 1 (1) - TotalCpuTime: 2s349ms - TotalNetworkReceiveTime: 6.193us - TotalNetworkSendTime: 274.388us - TotalStorageWaitTime: 20.826ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 590.015ms, non-child: 590.015ms, % non-child: 100.00%) - CodegenTime: 184.571us - CompileTime: 63.541ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 342.658ms - PrepareTime: 182.029ms DataStreamSender (dst_id=8):(Total: 40.997us, non-child: 40.997us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 85.78 KB/sec - OverallThroughput: 381.12 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 20.500us - ThriftTransmitTime(*): 182.145us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 719.362ms, non-child: 189.534ms, % non-child: 26.35%) ExecOption: Codegen Enabled - BuildTime: 5.839ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 188.00 KB (192512) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 529.828ms, non-child: 164.544ms, % non-child: 31.06%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 2.663us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 3.692us - GetNewBlockTime: 118.817us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 7.49M (7489300) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 151.929ms - RowsReturned: 1.50M (1497895) - RowsReturnedRate: 2.83 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.271us EXCHANGE_NODE (id=7):(Total: 9.559us, non-child: 9.559us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B, 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 1.122us - DeserializeRowBatchTimer: 5.208us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 104.61 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 365.287ms, non-child: 336.056ms, % non-child: 92.00%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 2.517us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 5.353us - GetNewBlockTime: 45.370us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 7.49M (7489300) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 310.386ms - RowsReturned: 7.49M (7489300) - RowsReturnedRate: 20.50 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 957.000ns EXCHANGE_NODE (id=6):(Total: 6.496us, non-child: 6.496us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B, 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.378us - DeserializeRowBatchTimer: 9.511us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 3.85 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 29.225ms, non-child: 29.225ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 3 Hdfs split stats (:<# splits>/): 9:1/252.19 MB 3:1/94.89 MB 10:1/252.21 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:3 BytesRead(500.000ms): 0, 4.77 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 2.00 - BytesRead: 4.77 MB (5006504) - BytesReadDataNodeCache: 0 - BytesReadLocal: 4.77 MB (5006504) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 4.77 MB (5006504) - DecompressionTime: 1.773ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 3 (3) - NumRowGroups: 3 (3) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 11.87 MB (12447768) - PerReadThreadRawHdfsThroughput: 1.53 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 7.49M (7489300) - RowsReturned: 7.49M (7489300) - RowsReturnedRate: 256.26 M/sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 93 (93) - ScannerThreadsTotalWallClockTime: 1s215ms - MaterializeTupleTime(*): 1s190ms - ScannerThreadsSysTime: 7.997ms - ScannerThreadsUserTime: 437.932ms - ScannerThreadsVoluntaryContextSwitches: 6.86K (6857) - TotalRawHdfsReadTime(*): 3.046ms - TotalReadThroughput: 4.77 MB/sec Filter 1: - Rows processed: 49.15K (49149) - Rows rejected: 0 (0) - Rows total: 49.15K (49152) Instance 1f4d282fbb90c626:5e0e124353e007a8 (host=d2410.halxg.cloudera.com:22000):(Total: 688.046ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 6:1/252.19 MB 7:1/252.17 MB MemoryUsage(500.000ms): 0, 60.20 KB, 11.18 MB ThreadUsage(500.000ms): 1, 1, 3 - AverageThreadTokens: 1.67 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 11.27 MB (11818000) - PerHostPeakMemUsage: 14.27 MB (14963728) - PrepareTime: 189.393ms - RowsProduced: 1 (1) - TotalCpuTime: 2s043ms - TotalNetworkReceiveTime: 6.222us - TotalNetworkSendTime: 270.112us - TotalStorageWaitTime: 11.558ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 593.390ms, non-child: 593.390ms, % non-child: 100.00%) - CodegenTime: 185.316us - CompileTime: 63.468ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 345.661ms - PrepareTime: 182.575ms DataStreamSender (dst_id=8):(Total: 45.992us, non-child: 45.992us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 85.50 KB/sec - OverallThroughput: 339.73 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 26.952us - ThriftTransmitTime(*): 182.744us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 687.224ms, non-child: 188.254ms, % non-child: 27.39%) ExecOption: Codegen Enabled - BuildTime: 5.067ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 188.00 KB (192512) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 498.969ms, non-child: 105.973ms, % non-child: 21.24%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 2.516us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 2.780us - GetNewBlockTime: 271.312us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 6.31M (6306797) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 94.816ms - RowsReturned: 1.26M (1261860) - RowsReturnedRate: 2.53 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.094us EXCHANGE_NODE (id=7):(Total: 8.296us, non-child: 8.296us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B, 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 992.000ns - DeserializeRowBatchTimer: 5.384us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 120.54 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 392.999ms, non-child: 363.815ms, % non-child: 92.57%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.712us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 6.128us - GetNewBlockTime: 60.778us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 6.31M (6306797) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 334.957ms - RowsReturned: 6.31M (6306797) - RowsReturnedRate: 16.05 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.168us EXCHANGE_NODE (id=6):(Total: 9.304us, non-child: 9.304us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B, 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.642us - DeserializeRowBatchTimer: 8.336us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 2.69 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 29.175ms, non-child: 29.175ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 2 Hdfs split stats (:<# splits>/): 6:1/252.19 MB 7:1/252.17 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:2 BytesRead(500.000ms): 0, 3.97 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 2.00 - BytesRead: 3.97 MB (4162046) - BytesReadDataNodeCache: 0 - BytesReadLocal: 3.97 MB (4162046) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 3.97 MB (4162046) - DecompressionTime: 1.309ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 2 (2) - NumRowGroups: 2 (2) - NumScannerThreadsStarted: 2 (2) - PeakMemoryUsage: 10.78 MB (11304960) - PerReadThreadRawHdfsThroughput: 2.08 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 6.31M (6306797) - RowsReturned: 6.31M (6306797) - RowsReturnedRate: 216.17 M/sec - ScanRangesComplete: 2 (2) - ScannerThreadsInvoluntaryContextSwitches: 96 (96) - ScannerThreadsTotalWallClockTime: 916.625ms - MaterializeTupleTime(*): 902.482ms - ScannerThreadsSysTime: 5.998ms - ScannerThreadsUserTime: 485.925ms - ScannerThreadsVoluntaryContextSwitches: 5.70K (5703) - TotalRawHdfsReadTime(*): 1.862ms - TotalReadThroughput: 3.97 MB/sec Filter 1: - Rows processed: 32.77K (32766) - Rows rejected: 0 (0) - Rows total: 32.77K (32768) Instance 1f4d282fbb90c626:5e0e124353e007af (host=d2405.halxg.cloudera.com:22000):(Total: 652.043ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 5:1/252.17 MB 8:1/105.57 MB 0:1/252.20 MB MemoryUsage(500.000ms): 60.20 KB, 11.05 MB ThreadUsage(500.000ms): 1, 3 - AverageThreadTokens: 2.00 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 12.34 MB (12944400) - PerHostPeakMemUsage: 15.34 MB (16090128) - PrepareTime: 188.984ms - RowsProduced: 1 (1) - TotalCpuTime: 2s123ms - TotalNetworkReceiveTime: 6.182us - TotalNetworkSendTime: 567.482us - TotalStorageWaitTime: 19.588ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 591.290ms, non-child: 591.290ms, % non-child: 100.00%) - CodegenTime: 179.008us - CompileTime: 62.444ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 344.887ms - PrepareTime: 182.142ms DataStreamSender (dst_id=8):(Total: 29.918us, non-child: 29.918us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 86.70 KB/sec - OverallThroughput: 522.26 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 9.084us - ThriftTransmitTime(*): 180.224us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 651.273ms, non-child: 189.314ms, % non-child: 29.07%) ExecOption: Codegen Enabled - BuildTime: 6.027ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 252.00 KB (258048) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 461.959ms, non-child: 135.941ms, % non-child: 29.43%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 2.472us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 2.824us - GetNewBlockTime: 177.164us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 7.62M (7623639) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 123.181ms - RowsReturned: 1.52M (1523883) - RowsReturnedRate: 3.30 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 998.000ns EXCHANGE_NODE (id=7):(Total: 8.109us, non-child: 8.109us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B, 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 850.000ns - DeserializeRowBatchTimer: 5.396us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 123.30 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 326.020ms, non-child: 297.730ms, % non-child: 91.32%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.570us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 6.202us - GetNewBlockTime: 62.296us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 7.62M (7623639) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 269.385ms - RowsReturned: 7.62M (7623639) - RowsReturnedRate: 23.38 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.020us EXCHANGE_NODE (id=6):(Total: 8.896us, non-child: 8.896us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B, 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.442us - DeserializeRowBatchTimer: 9.430us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 2.81 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 28.281ms, non-child: 28.281ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 3 Hdfs split stats (:<# splits>/): 5:1/252.17 MB 8:1/105.57 MB 0:1/252.20 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:3 BytesRead(500.000ms): 0, 4.85 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 2.00 - BytesRead: 4.85 MB (5090776) - BytesReadDataNodeCache: 0 - BytesReadLocal: 4.85 MB (5090776) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 4.85 MB (5090776) - DecompressionTime: 1.624ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 3 (3) - NumRowGroups: 3 (3) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 11.85 MB (12423168) - PerReadThreadRawHdfsThroughput: 1.83 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 7.62M (7623639) - RowsReturned: 7.62M (7623639) - RowsReturnedRate: 269.56 M/sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 75 (75) - ScannerThreadsTotalWallClockTime: 1s048ms - MaterializeTupleTime(*): 1s024ms - ScannerThreadsSysTime: 4.997ms - ScannerThreadsUserTime: 379.941ms - ScannerThreadsVoluntaryContextSwitches: 7.09K (7095) - TotalRawHdfsReadTime(*): 2.587ms - TotalReadThroughput: 4.85 MB/sec Filter 1: - Rows processed: 49.15K (49149) - Rows rejected: 0 (0) - Rows total: 49.15K (49152) Instance 1f4d282fbb90c626:5e0e124353e007b1 (host=d2409.halxg.cloudera.com:22000):(Total: 651.509ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 4:1/252.18 MB 8:1/129.95 MB 5:1/252.19 MB MemoryUsage(500.000ms): 0, 60.20 KB ThreadUsage(500.000ms): 1, 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 12.36 MB (12960784) - PerHostPeakMemUsage: 15.36 MB (16106512) - PrepareTime: 187.370ms - RowsProduced: 1 (1) - TotalCpuTime: 2s209ms - TotalNetworkReceiveTime: 6.234us - TotalNetworkSendTime: 273.860us - TotalStorageWaitTime: 13.611ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 585.157ms, non-child: 585.157ms, % non-child: 100.00%) - CodegenTime: 186.982us - CompileTime: 61.923ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 340.829ms - PrepareTime: 180.683ms DataStreamSender (dst_id=8):(Total: 27.110us, non-child: 27.110us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 142.64 KB/sec - OverallThroughput: 576.36 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 7.338us - ThriftTransmitTime(*): 109.538us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 650.792ms, non-child: 189.006ms, % non-child: 29.04%) ExecOption: Codegen Enabled - BuildTime: 6.661ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 252.00 KB (258048) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 461.786ms, non-child: 135.863ms, % non-child: 29.42%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.590us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 3.660us - GetNewBlockTime: 241.836us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 7.93M (7928024) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 123.247ms - RowsReturned: 1.59M (1588056) - RowsReturnedRate: 3.44 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.046us EXCHANGE_NODE (id=7):(Total: 9.676us, non-child: 9.676us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 1.116us - DeserializeRowBatchTimer: 5.166us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 103.35 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 325.925ms, non-child: 296.042ms, % non-child: 90.83%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.440us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 6.032us - GetNewBlockTime: 73.170us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 7.93M (7928024) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 268.629ms - RowsReturned: 7.93M (7928024) - RowsReturnedRate: 24.32 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 902.000ns EXCHANGE_NODE (id=6):(Total: 8.308us, non-child: 8.308us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.376us - DeserializeRowBatchTimer: 9.850us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 3.01 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 29.875ms, non-child: 29.875ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 3 Hdfs split stats (:<# splits>/): 4:1/252.18 MB 8:1/129.95 MB 5:1/252.19 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:3 BytesRead(500.000ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 5.04 MB (5281756) - BytesReadDataNodeCache: 0 - BytesReadLocal: 5.04 MB (5281756) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 5.04 MB (5281756) - DecompressionTime: 1.621ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 3 (3) - NumRowGroups: 3 (3) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 11.86 MB (12431360) - PerReadThreadRawHdfsThroughput: 1.63 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 7.93M (7928024) - RowsReturned: 7.93M (7928024) - RowsReturnedRate: 265.37 M/sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 111 (111) - ScannerThreadsTotalWallClockTime: 1s133ms - MaterializeTupleTime(*): 1s115ms - ScannerThreadsSysTime: 5.998ms - ScannerThreadsUserTime: 389.939ms - ScannerThreadsVoluntaryContextSwitches: 7.42K (7424) - TotalRawHdfsReadTime(*): 3.023ms - TotalReadThroughput: 0.00 /sec Filter 1: - Rows processed: 49.15K (49149) - Rows rejected: 0 (0) - Rows total: 49.15K (49152) Instance 1f4d282fbb90c626:5e0e124353e007a7 (host=d2420.halxg.cloudera.com:22000):(Total: 628.387ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 2:1/252.20 MB 3:1/252.15 MB Filter 1 arrival: 693ms MemoryUsage(500.000ms): 0, 60.20 KB ThreadUsage(500.000ms): 1, 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 11.27 MB (11818000) - PerHostPeakMemUsage: 14.27 MB (14963728) - PrepareTime: 245.486ms - RowsProduced: 1 (1) - TotalCpuTime: 1s778ms - TotalNetworkReceiveTime: 12.626us - TotalNetworkSendTime: 278.574us - TotalStorageWaitTime: 21.905ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 681.136ms, non-child: 681.136ms, % non-child: 100.00%) - CodegenTime: 237.414us - CompileTime: 64.467ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 377.332ms - PrepareTime: 237.203ms DataStreamSender (dst_id=8):(Total: 33.422us, non-child: 33.422us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 81.83 KB/sec - OverallThroughput: 467.51 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 11.300us - ThriftTransmitTime(*): 190.940us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 627.165ms, non-child: 243.602ms, % non-child: 38.84%) ExecOption: Codegen Enabled - BuildTime: 5.577ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 188.00 KB (192512) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 383.563ms, non-child: 111.689ms, % non-child: 29.12%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 5.210us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 6.584us - GetNewBlockTime: 304.854us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 6.31M (6306758) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 99.898ms - RowsReturned: 1.26M (1260817) - RowsReturnedRate: 3.29 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 2.464us EXCHANGE_NODE (id=7):(Total: 19.074us, non-child: 19.074us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 2.228us - DeserializeRowBatchTimer: 10.438us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 52.43 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 271.879ms, non-child: 245.375ms, % non-child: 90.25%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 4.948us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 10.580us - GetNewBlockTime: 357.600us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 6.31M (6306758) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 219.929ms - RowsReturned: 6.31M (6306758) - RowsReturnedRate: 23.20 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.988us EXCHANGE_NODE (id=6):(Total: 13.628us, non-child: 13.628us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 2.706us - DeserializeRowBatchTimer: 16.668us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 1.83 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 26.490ms, non-child: 26.490ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 2 Hdfs split stats (:<# splits>/): 2:1/252.20 MB 3:1/252.15 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:2 BytesRead(500.000ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 3.97 MB (4162021) - BytesReadDataNodeCache: 0 - BytesReadLocal: 3.97 MB (4162021) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 3.97 MB (4162021) - DecompressionTime: 1.300ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 2 (2) - NumRowGroups: 2 (2) - NumScannerThreadsStarted: 2 (2) - PeakMemoryUsage: 10.78 MB (11304960) - PerReadThreadRawHdfsThroughput: 944.79 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 6.31M (6306758) - RowsReturned: 6.31M (6306758) - RowsReturnedRate: 238.08 M/sec - ScanRangesComplete: 2 (2) - ScannerThreadsInvoluntaryContextSwitches: 74 (74) - ScannerThreadsTotalWallClockTime: 697.361ms - MaterializeTupleTime(*): 672.287ms - ScannerThreadsSysTime: 10.998ms - ScannerThreadsUserTime: 316.950ms - ScannerThreadsVoluntaryContextSwitches: 5.32K (5316) - TotalRawHdfsReadTime(*): 4.201ms - TotalReadThroughput: 0.00 /sec Filter 1: - Rows processed: 32.77K (32766) - Rows rejected: 0 (0) - Rows total: 32.77K (32768) Instance 1f4d282fbb90c626:5e0e124353e007a5 (host=d2411.halxg.cloudera.com:22000):(Total: 624.715ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 4:1/125.17 MB 9:1/252.18 MB 7:1/252.20 MB MemoryUsage(500.000ms): 60.20 KB, 12.22 MB ThreadUsage(500.000ms): 1, 4 - AverageThreadTokens: 2.50 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 12.31 MB (12903440) - PerHostPeakMemUsage: 15.31 MB (16049168) - PrepareTime: 186.796ms - RowsProduced: 1 (1) - TotalCpuTime: 2s087ms - TotalNetworkReceiveTime: 6.914us - TotalNetworkSendTime: 271.592us - TotalStorageWaitTime: 18.206ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 588.347ms, non-child: 588.347ms, % non-child: 100.00%) - CodegenTime: 212.946us - CompileTime: 61.839ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 344.659ms - PrepareTime: 180.131ms DataStreamSender (dst_id=8):(Total: 38.546us, non-child: 38.546us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 81.27 KB/sec - OverallThroughput: 405.36 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 9.748us - ThriftTransmitTime(*): 192.264us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 623.899ms, non-child: 187.139ms, % non-child: 30.00%) ExecOption: Codegen Enabled - BuildTime: 6.058ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 188.49 KB (193016) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 436.760ms, non-child: 126.401ms, % non-child: 28.94%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 2.826us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 2.948us - GetNewBlockTime: 258.851us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 7.87M (7867707) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 113.649ms - RowsReturned: 1.57M (1573953) - RowsReturnedRate: 3.60 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.342us EXCHANGE_NODE (id=7):(Total: 8.704us, non-child: 8.704us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B, 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 926.000ns - DeserializeRowBatchTimer: 5.248us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 114.89 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 310.362ms, non-child: 272.609ms, % non-child: 87.84%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.600us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 6.244us - GetNewBlockTime: 59.892us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 7.87M (7867707) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 246.343ms - RowsReturned: 7.87M (7867707) - RowsReturnedRate: 25.35 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.090us EXCHANGE_NODE (id=6):(Total: 9.214us, non-child: 9.214us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B, 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.360us - DeserializeRowBatchTimer: 9.926us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 2.71 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 37.743ms, non-child: 37.743ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 3 Hdfs split stats (:<# splits>/): 4:1/125.17 MB 9:1/252.18 MB 7:1/252.20 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:3 BytesRead(500.000ms): 0, 5.00 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 3.00 - BytesRead: 5.00 MB (5243894) - BytesReadDataNodeCache: 0 - BytesReadLocal: 5.00 MB (5243894) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 5.00 MB (5243894) - DecompressionTime: 1.452ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 3 (3) - NumRowGroups: 3 (3) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 11.81 MB (12382208) - PerReadThreadRawHdfsThroughput: 2.22 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 7.87M (7867707) - RowsReturned: 7.87M (7867707) - RowsReturnedRate: 208.45 M/sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 95 (95) - ScannerThreadsTotalWallClockTime: 1s040ms - MaterializeTupleTime(*): 1s018ms - ScannerThreadsSysTime: 10.998ms - ScannerThreadsUserTime: 379.941ms - ScannerThreadsVoluntaryContextSwitches: 7.40K (7396) - TotalRawHdfsReadTime(*): 2.201ms - TotalReadThroughput: 5.00 MB/sec Filter 1: - Rows processed: 49.15K (49149) - Rows rejected: 0 (0) - Rows total: 49.15K (49152) Instance 1f4d282fbb90c626:5e0e124353e007b7 (host=d2408.halxg.cloudera.com:22000):(Total: 622.200ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 3:1/130.67 MB 2:1/252.16 MB 8:1/252.16 MB MemoryUsage(500.000ms): 0, 60.20 KB ThreadUsage(500.000ms): 1, 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 12.36 MB (12960784) - PerHostPeakMemUsage: 15.36 MB (16106512) - PrepareTime: 185.377ms - RowsProduced: 1 (1) - TotalCpuTime: 2s076ms - TotalNetworkReceiveTime: 6.216us - TotalNetworkSendTime: 261.468us - TotalStorageWaitTime: 21.462ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 586.540ms, non-child: 586.540ms, % non-child: 100.00%) - CodegenTime: 172.484us - CompileTime: 62.500ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 343.446ms - PrepareTime: 178.974ms DataStreamSender (dst_id=8):(Total: 46.264us, non-child: 46.264us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 88.29 KB/sec - OverallThroughput: 337.74 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 7.844us - ThriftTransmitTime(*): 176.968us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 621.472ms, non-child: 186.068ms, % non-child: 29.94%) ExecOption: Codegen Enabled - BuildTime: 6.233ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 236.00 KB (241664) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 435.403ms, non-child: 129.143ms, % non-child: 29.66%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.516us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 3.712us - GetNewBlockTime: 249.990us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 7.94M (7937730) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 116.647ms - RowsReturned: 1.59M (1587509) - RowsReturnedRate: 3.65 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.264us EXCHANGE_NODE (id=7):(Total: 10.424us, non-child: 10.424us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 1.032us - DeserializeRowBatchTimer: 6.186us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 95.93 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 306.264ms, non-child: 272.711ms, % non-child: 89.04%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.332us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 5.986us - GetNewBlockTime: 54.818us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 7.94M (7937730) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 245.756ms - RowsReturned: 7.94M (7937730) - RowsReturnedRate: 25.92 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.068us EXCHANGE_NODE (id=6):(Total: 8.392us, non-child: 8.392us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.538us - DeserializeRowBatchTimer: 11.400us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 2.98 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 33.544ms, non-child: 33.544ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 3 Hdfs split stats (:<# splits>/): 3:1/130.67 MB 2:1/252.16 MB 8:1/252.16 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:3 BytesRead(500.000ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 5.04 MB (5287843) - BytesReadDataNodeCache: 0 - BytesReadLocal: 5.04 MB (5287843) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 5.04 MB (5287843) - DecompressionTime: 1.671ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 3 (3) - NumRowGroups: 3 (3) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 11.86 MB (12431360) - PerReadThreadRawHdfsThroughput: 1.82 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 7.94M (7937730) - RowsReturned: 7.94M (7937730) - RowsReturnedRate: 236.63 M/sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 104 (104) - ScannerThreadsTotalWallClockTime: 1s036ms - MaterializeTupleTime(*): 1s011ms - ScannerThreadsSysTime: 7.997ms - ScannerThreadsUserTime: 371.942ms - ScannerThreadsVoluntaryContextSwitches: 7.38K (7378) - TotalRawHdfsReadTime(*): 2.712ms - TotalReadThroughput: 0.00 /sec Filter 1: - Rows processed: 49.15K (49149) - Rows rejected: 0 (0) - Rows total: 49.15K (49152) Instance 1f4d282fbb90c626:5e0e124353e007b5 (host=d2403.halxg.cloudera.com:22000):(Total: 617.852ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 6:1/76.31 MB 5:1/31.25 MB 3:1/252.18 MB 0:1/252.19 MB MemoryUsage(500.000ms): 0, 60.20 KB ThreadUsage(500.000ms): 1, 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 12.70 MB (13317136) - PerHostPeakMemUsage: 15.70 MB (16462864) - PrepareTime: 192.173ms - RowsProduced: 1 (1) - TotalCpuTime: 2s071ms - TotalNetworkReceiveTime: 6.752us - TotalNetworkSendTime: 184.160us - TotalStorageWaitTime: 16.796ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 600.228ms, non-child: 600.228ms, % non-child: 100.00%) - CodegenTime: 242.664us - CompileTime: 62.853ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 350.706ms - PrepareTime: 184.969ms DataStreamSender (dst_id=8):(Total: 41.220us, non-child: 41.220us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 100.41 KB/sec - OverallThroughput: 379.06 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 23.284us - ThriftTransmitTime(*): 155.612us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 617.095ms, non-child: 191.688ms, % non-child: 31.06%) ExecOption: Codegen Enabled - BuildTime: 5.991ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 188.00 KB (192512) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 425.406ms, non-child: 123.161ms, % non-child: 28.95%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.308us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 3.550us - GetNewBlockTime: 243.884us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 7.64M (7641418) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 110.854ms - RowsReturned: 1.53M (1528194) - RowsReturnedRate: 3.59 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.190us EXCHANGE_NODE (id=7):(Total: 9.676us, non-child: 9.676us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 1.396us - DeserializeRowBatchTimer: 6.934us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 103.35 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 302.248ms, non-child: 267.013ms, % non-child: 88.34%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.658us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 5.890us - GetNewBlockTime: 55.414us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 7.64M (7641418) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 239.691ms - RowsReturned: 7.64M (7641418) - RowsReturnedRate: 25.28 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.082us EXCHANGE_NODE (id=6):(Total: 8.360us, non-child: 8.360us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.424us - DeserializeRowBatchTimer: 7.236us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 2.99 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 35.226ms, non-child: 35.226ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 4 Hdfs split stats (:<# splits>/): 6:1/76.31 MB 5:1/31.25 MB 3:1/252.18 MB 0:1/252.19 MB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:4 BytesRead(500.000ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 4.96 MB (5204491) - BytesReadDataNodeCache: 0 - BytesReadLocal: 4.96 MB (5204491) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 4.96 MB (5204491) - DecompressionTime: 1.435ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 4 (4) - NumRowGroups: 4 (4) - NumScannerThreadsStarted: 4 (4) - PeakMemoryUsage: 12.21 MB (12804096) - PerReadThreadRawHdfsThroughput: 1.72 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 7.64M (7641418) - RowsReturned: 7.64M (7641418) - RowsReturnedRate: 216.92 M/sec - ScanRangesComplete: 4 (4) - ScannerThreadsInvoluntaryContextSwitches: 100 (100) - ScannerThreadsTotalWallClockTime: 1s021ms - MaterializeTupleTime(*): 999.029ms - ScannerThreadsSysTime: 8.996ms - ScannerThreadsUserTime: 375.940ms - ScannerThreadsVoluntaryContextSwitches: 7.22K (7218) - TotalRawHdfsReadTime(*): 2.813ms - TotalReadThroughput: 0.00 /sec Filter 1: - Rows processed: 65.53K (65532) - Rows rejected: 0 (0) - Rows total: 65.54K (65536) Instance 1f4d282fbb90c626:5e0e124353e007b3 (host=d2406.halxg.cloudera.com:22000):(Total: 611.835ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 4:1/252.16 MB 6:1/252.18 MB 7:1/94.20 MB MemoryUsage(500.000ms): 60.20 KB, 12.23 MB ThreadUsage(500.000ms): 1, 4 - AverageThreadTokens: 2.50 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 12.31 MB (12903440) - PerHostPeakMemUsage: 15.31 MB (16049168) - PrepareTime: 188.227ms - RowsProduced: 1 (1) - TotalCpuTime: 1s997ms - TotalNetworkReceiveTime: 6.796us - TotalNetworkSendTime: 187.836us - TotalStorageWaitTime: 16.648ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 595.099ms, non-child: 595.099ms, % non-child: 100.00%) - CodegenTime: 197.382us - CompileTime: 66.115ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 345.595ms - PrepareTime: 181.618ms DataStreamSender (dst_id=8):(Total: 49.538us, non-child: 49.538us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 97.58 KB/sec - OverallThroughput: 315.41 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 7.532us - ThriftTransmitTime(*): 160.126us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 611.117ms, non-child: 188.890ms, % non-child: 30.91%) ExecOption: Codegen Enabled - BuildTime: 5.789ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 188.00 KB (192512) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 422.226ms, non-child: 127.700ms, % non-child: 30.24%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.196us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 3.382us - GetNewBlockTime: 246.634us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 7.48M (7480240) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 115.568ms - RowsReturned: 1.50M (1495104) - RowsReturnedRate: 3.54 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.366us EXCHANGE_NODE (id=7):(Total: 10.462us, non-child: 10.462us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B, 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 1.160us - DeserializeRowBatchTimer: 5.192us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 95.58 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 294.530ms, non-child: 259.585ms, % non-child: 88.14%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.664us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 6.242us - GetNewBlockTime: 55.326us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 7.48M (7480240) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 234.004ms - RowsReturned: 7.48M (7480240) - RowsReturnedRate: 25.40 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.220us EXCHANGE_NODE (id=6):(Total: 8.141us, non-child: 8.141us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B, 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.354us - DeserializeRowBatchTimer: 11.364us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 3.07 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 34.936ms, non-child: 34.936ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 3 Hdfs split stats (:<# splits>/): 4:1/252.16 MB 6:1/252.18 MB 7:1/94.20 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:3 BytesRead(500.000ms): 0, 4.77 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 3.00 - BytesRead: 4.77 MB (5000823) - BytesReadDataNodeCache: 0 - BytesReadLocal: 4.77 MB (5000823) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 4.77 MB (5000823) - DecompressionTime: 1.517ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 3 (3) - NumRowGroups: 3 (3) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 11.81 MB (12382256) - PerReadThreadRawHdfsThroughput: 1.74 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 7.48M (7480240) - RowsReturned: 7.48M (7480240) - RowsReturnedRate: 214.11 M/sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 91 (91) - ScannerThreadsTotalWallClockTime: 956.740ms - MaterializeTupleTime(*): 936.593ms - ScannerThreadsSysTime: 14.996ms - ScannerThreadsUserTime: 349.945ms - ScannerThreadsVoluntaryContextSwitches: 6.94K (6938) - TotalRawHdfsReadTime(*): 2.677ms - TotalReadThroughput: 4.77 MB/sec Filter 1: - Rows processed: 49.15K (49149) - Rows rejected: 0 (0) - Rows total: 49.15K (49152) Instance 1f4d282fbb90c626:5e0e124353e007a9 (host=d2418.halxg.cloudera.com:22000):(Total: 595.263ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 10:1/252.18 MB 2:1/85.17 MB 9:1/252.21 MB MemoryUsage(500.000ms): 0, 373.02 KB ThreadUsage(500.000ms): 1, 3 - AverageThreadTokens: 2.00 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 12.34 MB (12944400) - PerHostPeakMemUsage: 15.34 MB (16090128) - PrepareTime: 185.575ms - RowsProduced: 1 (1) - TotalCpuTime: 1s941ms - TotalNetworkReceiveTime: 6.140us - TotalNetworkSendTime: 249.042us - TotalStorageWaitTime: 20.193ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 585.816ms, non-child: 585.816ms, % non-child: 100.00%) - CodegenTime: 181.590us - CompileTime: 63.479ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 341.719ms - PrepareTime: 179.009ms DataStreamSender (dst_id=8):(Total: 38.620us, non-child: 38.620us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 75.04 KB/sec - OverallThroughput: 404.58 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 7.834us - ThriftTransmitTime(*): 208.206us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 594.526ms, non-child: 185.585ms, % non-child: 31.22%) ExecOption: Codegen Enabled - BuildTime: 5.599ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 236.00 KB (241664) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 408.940ms, non-child: 121.308ms, % non-child: 29.66%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.260us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 3.906us - GetNewBlockTime: 269.568us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 7.37M (7365818) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 108.803ms - RowsReturned: 1.47M (1470779) - RowsReturnedRate: 3.60 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.210us EXCHANGE_NODE (id=7):(Total: 11.260us, non-child: 11.260us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 1.144us - DeserializeRowBatchTimer: 4.986us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 88.81 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 287.636ms, non-child: 253.724ms, % non-child: 88.21%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.254us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 5.894us - GetNewBlockTime: 58.666us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 7.37M (7365818) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 229.413ms - RowsReturned: 7.37M (7365818) - RowsReturnedRate: 25.61 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.046us EXCHANGE_NODE (id=6):(Total: 7.848us, non-child: 7.848us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.644us - DeserializeRowBatchTimer: 10.258us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 3.19 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 33.903ms, non-child: 33.903ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 3 Hdfs split stats (:<# splits>/): 10:1/252.18 MB 2:1/85.17 MB 9:1/252.21 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:3 BytesRead(500.000ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 4.70 MB (4929038) - BytesReadDataNodeCache: 0 - BytesReadLocal: 4.70 MB (4929038) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 4.70 MB (4929038) - DecompressionTime: 1.301ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 3 (3) - NumRowGroups: 3 (3) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 11.85 MB (12423168) - PerReadThreadRawHdfsThroughput: 1.30 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 7.37M (7365818) - RowsReturned: 7.37M (7365818) - RowsReturnedRate: 217.26 M/sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 87 (87) - ScannerThreadsTotalWallClockTime: 928.261ms - MaterializeTupleTime(*): 904.469ms - ScannerThreadsSysTime: 6.997ms - ScannerThreadsUserTime: 343.947ms - ScannerThreadsVoluntaryContextSwitches: 6.86K (6857) - TotalRawHdfsReadTime(*): 3.521ms - TotalReadThroughput: 0.00 /sec Filter 1: - Rows processed: 49.15K (49149) - Rows rejected: 0 (0) - Rows total: 49.15K (49152) Instance 1f4d282fbb90c626:5e0e124353e007b8 (host=d2415.halxg.cloudera.com:22000):(Total: 554.507ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 0:1/252.17 MB 9:1/252.21 MB MemoryUsage(500.000ms): 60.20 KB, 11.23 MB ThreadUsage(500.000ms): 1, 3 - AverageThreadTokens: 2.00 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 11.27 MB (11818000) - PerHostPeakMemUsage: 14.27 MB (14963728) - PrepareTime: 187.702ms - RowsProduced: 1 (1) - TotalCpuTime: 1s645ms - TotalNetworkReceiveTime: 6.508us - TotalNetworkSendTime: 144.754us - TotalStorageWaitTime: 16.498ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 592.319ms, non-child: 592.319ms, % non-child: 100.00%) - CodegenTime: 175.320us - CompileTime: 63.688ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 345.897ms - PrepareTime: 181.032ms DataStreamSender (dst_id=8):(Total: 27.730us, non-child: 27.730us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 130.83 KB/sec - OverallThroughput: 563.47 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 8.812us - ThriftTransmitTime(*): 119.426us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 553.736ms, non-child: 186.611ms, % non-child: 33.70%) ExecOption: Codegen Enabled - BuildTime: 4.910ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 236.00 KB (241664) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 367.125ms, non-child: 107.345ms, % non-child: 29.24%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 2.848us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 3.046us - GetNewBlockTime: 185.780us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 6.31M (6306554) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 96.122ms - RowsReturned: 1.26M (1262116) - RowsReturnedRate: 3.44 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 940.000ns EXCHANGE_NODE (id=7):(Total: 9.302us, non-child: 9.302us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B, 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 1.320us - DeserializeRowBatchTimer: 5.526us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 107.50 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 259.783ms, non-child: 227.029ms, % non-child: 87.39%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.606us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 6.038us - GetNewBlockTime: 60.846us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 6.31M (6306554) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 199.817ms - RowsReturned: 6.31M (6306554) - RowsReturnedRate: 24.28 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 928.000ns EXCHANGE_NODE (id=6):(Total: 9.028us, non-child: 9.028us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B, 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.654us - DeserializeRowBatchTimer: 8.978us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 2.77 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 32.744ms, non-child: 32.744ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 2 Hdfs split stats (:<# splits>/): 0:1/252.17 MB 9:1/252.21 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:2 BytesRead(500.000ms): 0, 3.97 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 2.00 - BytesRead: 3.97 MB (4161887) - BytesReadDataNodeCache: 0 - BytesReadLocal: 3.97 MB (4161887) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 3.97 MB (4161887) - DecompressionTime: 1.165ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 2 (2) - NumRowGroups: 2 (2) - NumScannerThreadsStarted: 2 (2) - PeakMemoryUsage: 10.78 MB (11304960) - PerReadThreadRawHdfsThroughput: 1.19 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 6.31M (6306554) - RowsReturned: 6.31M (6306554) - RowsReturnedRate: 192.60 M/sec - ScanRangesComplete: 2 (2) - ScannerThreadsInvoluntaryContextSwitches: 63 (63) - ScannerThreadsTotalWallClockTime: 660.836ms - MaterializeTupleTime(*): 641.792ms - ScannerThreadsSysTime: 7.998ms - ScannerThreadsUserTime: 296.954ms - ScannerThreadsVoluntaryContextSwitches: 5.69K (5691) - TotalRawHdfsReadTime(*): 3.268ms - TotalReadThroughput: 3.97 MB/sec Filter 1: - Rows processed: 32.77K (32766) - Rows rejected: 0 (0) - Rows total: 32.77K (32768) Instance 1f4d282fbb90c626:5e0e124353e007ac (host=d2417.halxg.cloudera.com:22000):(Total: 539.101ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 5:1/252.17 MB 0:1/252.19 MB MemoryUsage(500.000ms): 60.20 KB, 11.11 MB ThreadUsage(500.000ms): 1, 3 - AverageThreadTokens: 2.00 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 11.28 MB (11826192) - PerHostPeakMemUsage: 14.28 MB (14971920) - PrepareTime: 186.774ms - RowsProduced: 1 (1) - TotalCpuTime: 1s600ms - TotalNetworkReceiveTime: 6.680us - TotalNetworkSendTime: 200.946us - TotalStorageWaitTime: 15.449ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 588.780ms, non-child: 588.780ms, % non-child: 100.00%) - CodegenTime: 175.126us - CompileTime: 61.964ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 344.952ms - PrepareTime: 180.126ms DataStreamSender (dst_id=8):(Total: 37.978us, non-child: 37.978us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 89.30 KB/sec - OverallThroughput: 411.42 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 19.976us - ThriftTransmitTime(*): 174.972us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 538.305ms, non-child: 186.298ms, % non-child: 34.61%) ExecOption: Codegen Enabled - BuildTime: 5.367ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 236.00 KB (241664) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 352.006ms, non-child: 100.448ms, % non-child: 28.54%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.014us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 3.728us - GetNewBlockTime: 242.274us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 6.31M (6307024) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 89.558ms - RowsReturned: 1.26M (1261628) - RowsReturnedRate: 3.58 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.246us EXCHANGE_NODE (id=7):(Total: 10.744us, non-child: 10.744us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B, 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 1.244us - DeserializeRowBatchTimer: 5.776us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 93.08 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 251.562ms, non-child: 218.864ms, % non-child: 87.00%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.566us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 6.324us - GetNewBlockTime: 59.144us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 6.31M (6307024) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 195.221ms - RowsReturned: 6.31M (6307024) - RowsReturnedRate: 25.07 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.046us EXCHANGE_NODE (id=6):(Total: 8.826us, non-child: 8.826us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B, 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.440us - DeserializeRowBatchTimer: 10.824us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 2.83 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 32.689ms, non-child: 32.689ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 2 Hdfs split stats (:<# splits>/): 5:1/252.17 MB 0:1/252.19 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:2 BytesRead(500.000ms): 0, 3.97 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 2.00 - BytesRead: 3.97 MB (4162185) - BytesReadDataNodeCache: 0 - BytesReadLocal: 3.97 MB (4162185) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 3.97 MB (4162185) - DecompressionTime: 1.209ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 2 (2) - NumRowGroups: 2 (2) - NumScannerThreadsStarted: 2 (2) - PeakMemoryUsage: 10.78 MB (11304960) - PerReadThreadRawHdfsThroughput: 1.16 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 6.31M (6307024) - RowsReturned: 6.31M (6307024) - RowsReturnedRate: 192.94 M/sec - ScanRangesComplete: 2 (2) - ScannerThreadsInvoluntaryContextSwitches: 60 (60) - ScannerThreadsTotalWallClockTime: 639.055ms - MaterializeTupleTime(*): 620.497ms - ScannerThreadsSysTime: 9.997ms - ScannerThreadsUserTime: 288.955ms - ScannerThreadsVoluntaryContextSwitches: 5.70K (5703) - TotalRawHdfsReadTime(*): 3.341ms - TotalReadThroughput: 3.97 MB/sec Filter 1: - Rows processed: 32.77K (32766) - Rows rejected: 0 (0) - Rows total: 32.77K (32768) Instance 1f4d282fbb90c626:5e0e124353e007a6 (host=d2404.halxg.cloudera.com:22000):(Total: 535.877ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 4:1/252.15 MB 0:1/252.22 MB MemoryUsage(500.000ms): 0, 373.02 KB ThreadUsage(500.000ms): 1, 3 - AverageThreadTokens: 2.00 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 11.28 MB (11826192) - PerHostPeakMemUsage: 14.28 MB (14971920) - PrepareTime: 187.296ms - RowsProduced: 1 (1) - TotalCpuTime: 1s588ms - TotalNetworkReceiveTime: 6.782us - TotalNetworkSendTime: 215.504us - TotalStorageWaitTime: 10.743ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 592.449ms, non-child: 592.449ms, % non-child: 100.00%) - CodegenTime: 178.954us - CompileTime: 64.118ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 345.954ms - PrepareTime: 180.658ms DataStreamSender (dst_id=8):(Total: 27.546us, non-child: 27.546us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 122.51 KB/sec - OverallThroughput: 567.23 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 8.948us - ThriftTransmitTime(*): 127.542us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 535.167ms, non-child: 186.279ms, % non-child: 34.81%) ExecOption: Codegen Enabled - BuildTime: 4.988ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 188.00 KB (192512) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 348.888ms, non-child: 101.671ms, % non-child: 29.14%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.094us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 3.236us - GetNewBlockTime: 235.834us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 6.31M (6306914) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 90.868ms - RowsReturned: 1.26M (1261537) - RowsReturnedRate: 3.62 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 998.000ns EXCHANGE_NODE (id=7):(Total: 9.096us, non-child: 9.096us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 992.000ns - DeserializeRowBatchTimer: 5.638us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 109.94 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 247.221ms, non-child: 222.559ms, % non-child: 90.02%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.624us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 6.252us - GetNewBlockTime: 61.560us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 6.31M (6306914) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 195.779ms - RowsReturned: 6.31M (6306914) - RowsReturnedRate: 25.51 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 928.000ns EXCHANGE_NODE (id=6):(Total: 9.228us, non-child: 9.228us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.446us - DeserializeRowBatchTimer: 9.700us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 2.71 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 24.652ms, non-child: 24.652ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 2 Hdfs split stats (:<# splits>/): 4:1/252.15 MB 0:1/252.22 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:2 BytesRead(500.000ms): 0 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 3.97 MB (4162121) - BytesReadDataNodeCache: 0 - BytesReadLocal: 3.97 MB (4162121) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 3.97 MB (4162121) - DecompressionTime: 1.190ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 2 (2) - NumRowGroups: 2 (2) - NumScannerThreadsStarted: 2 (2) - PeakMemoryUsage: 10.78 MB (11304960) - PerReadThreadRawHdfsThroughput: 2.27 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 6.31M (6306914) - RowsReturned: 6.31M (6306914) - RowsReturnedRate: 255.83 M/sec - ScanRangesComplete: 2 (2) - ScannerThreadsInvoluntaryContextSwitches: 63 (63) - ScannerThreadsTotalWallClockTime: 616.388ms - MaterializeTupleTime(*): 603.094ms - ScannerThreadsSysTime: 5.998ms - ScannerThreadsUserTime: 303.952ms - ScannerThreadsVoluntaryContextSwitches: 5.33K (5328) - TotalRawHdfsReadTime(*): 1.707ms - TotalReadThroughput: 0.00 /sec Filter 1: - Rows processed: 32.77K (32766) - Rows rejected: 0 (0) - Rows total: 32.77K (32768) Instance 1f4d282fbb90c626:5e0e124353e007aa (host=d2407.halxg.cloudera.com:22000):(Total: 535.026ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 2:1/252.17 MB 10:1/252.22 MB MemoryUsage(500.000ms): 60.20 KB, 11.08 MB ThreadUsage(500.000ms): 1, 3 - AverageThreadTokens: 2.00 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 11.27 MB (11818000) - PerHostPeakMemUsage: 14.27 MB (14963728) - PrepareTime: 187.201ms - RowsProduced: 1 (1) - TotalCpuTime: 1s578ms - TotalNetworkReceiveTime: 6.606us - TotalNetworkSendTime: 332.680us - TotalStorageWaitTime: 10.433ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 590.939ms, non-child: 590.939ms, % non-child: 100.00%) - CodegenTime: 179.688us - CompileTime: 63.300ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 345.339ms - PrepareTime: 180.660ms DataStreamSender (dst_id=8):(Total: 24.974us, non-child: 24.974us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 73.99 KB/sec - OverallThroughput: 625.65 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 7.292us - ThriftTransmitTime(*): 211.168us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 534.272ms, non-child: 186.109ms, % non-child: 34.83%) ExecOption: Codegen Enabled - BuildTime: 4.779ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 188.00 KB (192512) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 1.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 348.162ms, non-child: 102.133ms, % non-child: 29.34%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.928us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 3.380us - GetNewBlockTime: 190.836us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 6.31M (6305633) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 91.468ms - RowsReturned: 1.26M (1259299) - RowsReturnedRate: 3.62 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 1.182us EXCHANGE_NODE (id=7):(Total: 10.518us, non-child: 10.518us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B, 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 1.176us - DeserializeRowBatchTimer: 5.844us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 95.08 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 246.032ms, non-child: 218.161ms, % non-child: 88.67%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.320us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 5.692us - GetNewBlockTime: 58.474us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 6.31M (6305633) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 193.100ms - RowsReturned: 6.31M (6305633) - RowsReturnedRate: 25.63 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 940.000ns EXCHANGE_NODE (id=6):(Total: 8.460us, non-child: 8.460us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B, 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.692us - DeserializeRowBatchTimer: 10.352us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 2.96 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 27.862ms, non-child: 27.862ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 2 Hdfs split stats (:<# splits>/): 2:1/252.17 MB 10:1/252.22 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:2 BytesRead(500.000ms): 0, 3.97 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 2.00 - BytesRead: 3.97 MB (4161318) - BytesReadDataNodeCache: 0 - BytesReadLocal: 3.97 MB (4161318) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 3.97 MB (4161318) - DecompressionTime: 1.184ms - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 2 (2) - NumRowGroups: 2 (2) - NumScannerThreadsStarted: 2 (2) - PeakMemoryUsage: 10.78 MB (11304960) - PerReadThreadRawHdfsThroughput: 1.55 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 6.31M (6305633) - RowsReturned: 6.31M (6305633) - RowsReturnedRate: 226.31 M/sec - ScanRangesComplete: 2 (2) - ScannerThreadsInvoluntaryContextSwitches: 55 (55) - ScannerThreadsTotalWallClockTime: 611.408ms - MaterializeTupleTime(*): 591.918ms - ScannerThreadsSysTime: 1.999ms - ScannerThreadsUserTime: 284.955ms - ScannerThreadsVoluntaryContextSwitches: 5.68K (5677) - TotalRawHdfsReadTime(*): 2.498ms - TotalReadThroughput: 3.97 MB/sec Filter 1: - Rows processed: 32.77K (32766) - Rows rejected: 0 (0) - Rows total: 32.77K (32768) Instance 1f4d282fbb90c626:5e0e124353e007b4 (host=d2413.halxg.cloudera.com:22000):(Total: 432.751ms, non-child: 0.000ns, % non-child: 0.00%) Hdfs split stats (:<# splits>/): 6:1/50.32 MB 10:1/252.19 MB 4:1/41.18 MB MemoryUsage(500.000ms): 60.20 KB, 4.10 MB ThreadUsage(500.000ms): 1, 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 3.00 MB (3145728) - PeakMemoryUsage: 10.30 MB (10798552) - PerHostPeakMemUsage: 13.30 MB (13944280) - PrepareTime: 188.213ms - RowsProduced: 1 (1) - TotalCpuTime: 1s215ms - TotalNetworkReceiveTime: 6.246us - TotalNetworkSendTime: 265.340us - TotalStorageWaitTime: 15.727ms BlockMgr: - BlockWritesOutstanding: 0 (0) - BlocksCreated: 33 (33) - BlocksRecycled: 31 (31) - BufferedPins: 0 (0) - BytesWritten: 0 - MaxBlockSize: 8.00 MB (8388608) - MemoryLimit: 242.23 GB (260091396096) - PeakMemoryUsage: 1.02 KB (1040) - TotalBufferWaitTime: 0.000ns - TotalEncryptionTime: 0.000ns - TotalIntegrityCheckTime: 0.000ns - TotalReadBlockTime: 0.000ns CodeGen:(Total: 588.656ms, non-child: 588.656ms, % non-child: 100.00%) - CodegenTime: 184.844us - CompileTime: 62.644ms - LoadTime: 0.000ns - ModuleBitcodeSize: 1.98 MB (2080424) - OptimizationTime: 342.714ms - PrepareTime: 181.511ms DataStreamSender (dst_id=8):(Total: 41.580us, non-child: 41.580us, % non-child: 100.00%) - BytesSent: 16.00 B (16) - NetworkThroughput(*): 82.46 KB/sec - OverallThroughput: 375.78 KB/sec - PeakMemoryUsage: 16.00 KB (16384) - SerializeBatchTime: 9.402us - ThriftTransmitTime(*): 189.480us - UncompressedRowBatchSize: 16.00 B (16) AGGREGATION_NODE (id=5):(Total: 431.918ms, non-child: 188.858ms, % non-child: 43.73%) ExecOption: Codegen Enabled - BuildTime: 6.648ms - GetResultsTime: 0.000ns - HTResizeTime: 0.000ns - HashBuckets: 0 (0) - LargestPartitionPercent: 0 (0) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 0 (0) - PeakMemoryUsage: 252.00 KB (258048) - RowsRepartitioned: 0 (0) - RowsReturned: 1 (1) - RowsReturnedRate: 2.00 /sec - SpilledPartitions: 0 (0) HASH_JOIN_NODE (id=4):(Total: 243.060ms, non-child: 69.431ms, % non-child: 28.57%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 2.516us - BuildRows: 1 (1) - BuildRowsPartitioned: 1 (1) - BuildTime: 3.216us - GetNewBlockTime: 237.798us - HashBuckets: 1 (1) - HashCollisions: 0 (0) - LargestPartitionPercent: 100 (100) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.03 MB (2129936) - PinTime: 0.000ns - ProbeRows: 4.29M (4285794) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 60.854ms - RowsReturned: 856.56K (856560) - RowsReturnedRate: 3.52 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 960.000ns EXCHANGE_NODE (id=7):(Total: 8.832us, non-child: 8.832us, % non-child: 100.00%) BytesReceived(500.000ms): 32.00 B, 32.00 B - BytesReceived: 32.00 B (32) - ConvertRowBatchTime: 1.170us - DeserializeRowBatchTimer: 4.994us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 1 (1) - RowsReturnedRate: 113.22 K/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HASH_JOIN_NODE (id=3):(Total: 173.632ms, non-child: 156.724ms, % non-child: 90.26%) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Join Build-Side Prepared Asynchronously, Build-Side Runtime-Filter Produced - BuildPartitionTime: 3.430us - BuildRows: 25 (25) - BuildRowsPartitioned: 25 (25) - BuildTime: 5.872us - GetNewBlockTime: 59.496us - HashBuckets: 64 (64) - HashCollisions: 0 (0) - LargestPartitionPercent: 28 (28) - MaxPartitionLevel: 0 (0) - NumRepartitions: 0 (0) - PartitionsCreated: 16 (16) - PeakMemoryUsage: 2.02 MB (2121984) - PinTime: 0.000ns - ProbeRows: 4.29M (4285794) - ProbeRowsPartitioned: 0 (0) - ProbeTime: 133.305ms - RowsReturned: 4.29M (4285794) - RowsReturnedRate: 24.68 M/sec - SpilledPartitions: 0 (0) - UnpinTime: 906.000ns EXCHANGE_NODE (id=6):(Total: 8.628us, non-child: 8.628us, % non-child: 100.00%) BytesReceived(500.000ms): 289.00 B, 289.00 B - BytesReceived: 289.00 B (289) - ConvertRowBatchTime: 1.244us - DeserializeRowBatchTimer: 9.996us - FirstBatchArrivalWaitTime: 0.000ns - PeakMemoryUsage: 0 - RowsReturned: 25 (25) - RowsReturnedRate: 2.90 M/sec - SendersBlockedTimer: 0.000ns - SendersBlockedTotalTimer(*): 0.000ns HDFS_SCAN_NODE (id=0):(Total: 16.898ms, non-child: 16.898ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 3 Hdfs split stats (:<# splits>/): 6:1/50.32 MB 10:1/252.19 MB 4:1/41.18 MB Hdfs Read Thread Concurrency Bucket: 0:100% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:3 BytesRead(500.000ms): 0, 2.86 MB - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 2.86 MB (2996549) - BytesReadDataNodeCache: 0 - BytesReadLocal: 2.86 MB (2996549) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 2.86 MB (2996549) - DecompressionTime: 970.780us - MaxCompressedTextFileLength: 0 - NumColumns: 1 (1) - NumDisksAccessed: 3 (3) - NumRowGroups: 3 (3) - NumScannerThreadsStarted: 3 (3) - PeakMemoryUsage: 9.81 MB (10285064) - PerReadThreadRawHdfsThroughput: 1.32 GB/sec - RemoteScanRanges: 0 (0) - RowsRead: 4.29M (4285794) - RowsReturned: 4.29M (4285794) - RowsReturnedRate: 253.62 M/sec - ScanRangesComplete: 3 (3) - ScannerThreadsInvoluntaryContextSwitches: 34 (34) - ScannerThreadsTotalWallClockTime: 359.672ms - MaterializeTupleTime(*): 340.889ms - ScannerThreadsSysTime: 4.998ms - ScannerThreadsUserTime: 189.970ms - ScannerThreadsVoluntaryContextSwitches: 3.74K (3740) - TotalRawHdfsReadTime(*): 2.110ms - TotalReadThroughput: 2.86 MB/sec Filter 1: - Rows processed: 49.15K (49149) - Rows rejected: 0 (0) - Rows total: 49.15K (49152) Fragment F02: Instance 1f4d282fbb90c626:5e0e124353e007b9 (host=d2409.halxg.cloudera.com:22000):(Total: 8.044ms, non-child: 2.501ms, % non-child: 31.10%) Hdfs split stats (:<# splits>/): 10:1/910.00 B MemoryUsage(500.000ms): 88.00 KB ThreadUsage(500.000ms): 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 143.00 KB (146432) - PerHostPeakMemUsage: 144.20 KB (147664) - PrepareTime: 102.952us - RowsProduced: 1 (1) - TotalCpuTime: 14.157ms - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 232.823ms - TotalStorageWaitTime: 4.876ms DataStreamSender (dst_id=7):(Total: 132.180us, non-child: 132.180us, % non-child: 100.00%) - BytesSent: 640.00 B (640) - NetworkThroughput(*): 177.00 B/sec - OverallThroughput: 4.62 MB/sec - PeakMemoryUsage: 80.00 KB (81920) - SerializeBatchTime: 14.740us - ThriftTransmitTime(*): 3s615ms - UncompressedRowBatchSize: 940.00 B (940) HDFS_SCAN_NODE (id=2):(Total: 5.410ms, non-child: 5.410ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 1 Hdfs split stats (:<# splits>/): 10:1/910.00 B Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:2 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 1.05 KB (1078) - BytesReadDataNodeCache: 0 - BytesReadLocal: 1.05 KB (1078) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 1.05 KB (1078) - DecompressionTime: 2.102us - MaxCompressedTextFileLength: 0 - NumColumns: 2 (2) - NumDisksAccessed: 1 (1) - NumRowGroups: 1 (1) - NumScannerThreadsStarted: 1 (1) - PeakMemoryUsage: 55.00 KB (56320) - PerReadThreadRawHdfsThroughput: 52.39 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 5 (5) - RowsReturned: 1 (1) - RowsReturnedRate: 184.00 /sec - ScanRangesComplete: 1 (1) - ScannerThreadsInvoluntaryContextSwitches: 0 (0) - ScannerThreadsTotalWallClockTime: 5.159ms - MaterializeTupleTime(*): 11.692us - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 0.000ns - ScannerThreadsVoluntaryContextSwitches: 8 (8) - TotalRawHdfsReadTime(*): 19.624us - TotalReadThroughput: 0.00 /sec Fragment F01: Instance 1f4d282fbb90c626:5e0e124353e007ba (host=d2403.halxg.cloudera.com:22000):(Total: 8.311ms, non-child: 3.397ms, % non-child: 40.87%) Hdfs split stats (:<# splits>/): 7:1/2.19 KB MemoryUsage(500.000ms): 114.56 KB ThreadUsage(500.000ms): 1 - AverageThreadTokens: 1.00 - BloomFilterBytes: 0 - PeakMemoryUsage: 160.56 KB (164416) - PerHostPeakMemUsage: 160.56 KB (164416) - PrepareTime: 88.664us - RowsProduced: 25 (25) - TotalCpuTime: 17.907ms - TotalNetworkReceiveTime: 0.000ns - TotalNetworkSendTime: 222.741ms - TotalStorageWaitTime: 4.283ms DataStreamSender (dst_id=6):(Total: 99.626us, non-child: 99.626us, % non-child: 100.00%) - BytesSent: 5.64 KB (5780) - NetworkThroughput(*): 1.59 KB/sec - OverallThroughput: 55.33 MB/sec - PeakMemoryUsage: 106.56 KB (109120) - SerializeBatchTime: 18.880us - ThriftTransmitTime(*): 3s547ms - UncompressedRowBatchSize: 13.75 KB (14080) HDFS_SCAN_NODE (id=1):(Total: 4.814ms, non-child: 4.814ms, % non-child: 100.00%) ExecOption: Expr Evaluation Codegen Disabled, Codegen enabled: 0 out of 1 Hdfs split stats (:<# splits>/): 7:1/2.19 KB Hdfs Read Thread Concurrency Bucket: 0:0% 1:0% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0% 9:0% 10:0% 11:0% 12:0% 13:0% 14:0% 15:0% 16:0% 17:0% 18:0% 19:0% 20:0% 21:0% 22:0% 23:0% 24:0% 25:0% 26:0% 27:0% File Formats: PARQUET/SNAPPY:2 - AverageHdfsReadThreadConcurrency: 0.00 - AverageScannerThreadConcurrency: 0.00 - BytesRead: 2.44 KB (2497) - BytesReadDataNodeCache: 0 - BytesReadLocal: 2.44 KB (2497) - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 2.44 KB (2497) - DecompressionTime: 2.738us - MaxCompressedTextFileLength: 0 - NumColumns: 2 (2) - NumDisksAccessed: 1 (1) - NumRowGroups: 1 (1) - NumScannerThreadsStarted: 1 (1) - PeakMemoryUsage: 46.00 KB (47104) - PerReadThreadRawHdfsThroughput: 121.34 MB/sec - RemoteScanRanges: 0 (0) - RowsRead: 25 (25) - RowsReturned: 25 (25) - RowsReturnedRate: 5.19 K/sec - ScanRangesComplete: 1 (1) - ScannerThreadsInvoluntaryContextSwitches: 0 (0) - ScannerThreadsTotalWallClockTime: 4.543ms - MaterializeTupleTime(*): 9.536us - ScannerThreadsSysTime: 0.000ns - ScannerThreadsUserTime: 0.000ns - ScannerThreadsVoluntaryContextSwitches: 8 (8) - TotalRawHdfsReadTime(*): 19.626us - TotalReadThroughput: 0.00 /sec Filter 0: - Rows processed: 25 (25) - Rows rejected: 0 (0) - Rows total: 25 (25)