Query (id=64c001dc6dcd712:2562d42c35a26399) Summary Session ID: 1b4ed2c1bf1418c6:b9c71903465502b4 Session Type: HIVESERVER2 HiveServer2 Protocol Version: V6 Start Time: 2017-10-09 17:03:13.938513000 End Time: 2017-10-09 17:06:43.096820000 Query Type: QUERY Query State: EXCEPTION Query Status: Session closed Impala Version: impalad version 2.6.0-cdh5.8.3 RELEASE (build d016f04ff7d9c22d13fb91a283fff7c1b9e82ed1) User: hive@COE.CLOUDERA.COM Connected User: hive@COE.CLOUDERA.COM Delegated User: Network Address: 10.17.102.128:46724 Default Db: default Sql Statement: SELECT `A`.`a1`, AVG(ALL LENGTH(RTRIM(`A`.`a2`))) as `expr_0` FROM `default`.`test_parquet` `A`, `default`.`test_parquet` `B`, `default`.`test_parquet` WHERE ((`test_parquet`.`a1` = `A`.`a1`) AND (`A`.`a1` = `B`.`a1`)) GROUP BY `A`.`a1` Coordinator: host-10-17-101-152.coe.cloudera.com:22000 Query Options (non default): MEM_LIMIT=900000000,SYNC_DDL=1 Plan: ---------------- Estimated Per-Host Requirements: Memory=4.28GB VCores=3 WARNING: The following tables are missing relevant table and/or column statistics. default.test_parquet 10:EXCHANGE [UNPARTITIONED] | hosts=2 per-host-mem=unavailable | tuple-ids=4 row-size=23B cardinality=unavailable | 09:AGGREGATE [FINALIZE] | output: avg:merge(length(rtrim(A.a2))) | group by: A.a1 | hosts=2 per-host-mem=128.00MB | tuple-ids=4 row-size=23B cardinality=unavailable | 08:EXCHANGE [HASH(A.a1)] | hosts=2 per-host-mem=0B | tuple-ids=3 row-size=23B cardinality=unavailable | 05:AGGREGATE [STREAMING] | output: avg(length(rtrim(A.a2))) | group by: A.a1 | hosts=2 per-host-mem=128.00MB | tuple-ids=3 row-size=23B cardinality=unavailable | 04:HASH JOIN [INNER JOIN, BROADCAST] | hash predicates: A.a1 = test_parquet.a1 | runtime filters: RF000 <- test_parquet.a1 | hosts=2 per-host-mem=2.00GB | tuple-ids=0,1,2 row-size=60B cardinality=unavailable | |--07:EXCHANGE [BROADCAST] | | hosts=2 per-host-mem=0B | | tuple-ids=2 row-size=15B cardinality=unavailable | | | 02:SCAN HDFS [default.test_parquet, RANDOM] | partitions=1/1 files=1221 size=7.95GB | table stats: unavailable | column stats: unavailable | hosts=2 per-host-mem=16.00MB | tuple-ids=2 row-size=15B cardinality=unavailable | 03:HASH JOIN [INNER JOIN, BROADCAST] | hash predicates: A.a1 = B.a1 | runtime filters: RF001 <- B.a1 | hosts=2 per-host-mem=2.00GB | tuple-ids=0,1 row-size=45B cardinality=unavailable | |--06:EXCHANGE [BROADCAST] | | hosts=2 per-host-mem=0B | | tuple-ids=1 row-size=15B cardinality=unavailable | | | 01:SCAN HDFS [default.test_parquet b, RANDOM] | partitions=1/1 files=1221 size=7.95GB | runtime filters: RF000 -> b.a1 | table stats: unavailable | column stats: unavailable | hosts=2 per-host-mem=16.00MB | tuple-ids=1 row-size=15B cardinality=unavailable | 00:SCAN HDFS [default.test_parquet a, RANDOM] partitions=1/1 files=1221 size=7.95GB runtime filters: RF000 -> A.a1, RF001 -> A.a1 table stats: unavailable column stats: unavailable hosts=2 per-host-mem=32.00MB tuple-ids=0 row-size=30B cardinality=unavailable ---------------- Estimated Per-Host Mem: 4596957184 Estimated Per-Host VCores: 3 Tables Missing Stats: default.test_parquet Request Pool: root.default Admission result: Admitted (queued) Admission queue details: waited 201262 ms, reason: number of running queries 1 is over limit 1 ExecSummary: Operator #Hosts Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail ---------------------------------------------------------------------------------------------------------------------- 10:EXCHANGE 1 3.000ms 3.000ms 0 -1 0 -1.00 B UNPARTITIONED 09:AGGREGATE 0 0.000ns 0.000ns 0 -1 0 128.00 MB FINALIZE 08:EXCHANGE 0 0.000ns 0.000ns 0 -1 0 0 HASH(A.a1) 05:AGGREGATE 2 87.999ms 175.999ms 0 -1 1.27 MB 128.00 MB STREAMING 04:HASH JOIN 2 68.999ms 137.999ms 0 -1 138.08 MB 2.00 GB INNER JOIN, BROADCAST |--07:EXCHANGE 2 7.999ms 15.999ms 495.04K -1 0 0 BROADCAST | 02:SCAN HDFS 2 1s504ms 3s009ms 427.39K -1 5.52 MB 16.00 MB default.test_parquet 03:HASH JOIN 2 0.000ns 0.000ns 0 -1 10.08 MB 2.00 GB INNER JOIN, BROADCAST |--06:EXCHANGE 2 999.999us 1.999ms 131.20K -1 0 0 BROADCAST | 01:SCAN HDFS 0 0.000ns 0.000ns 0 -1 0 16.00 MB default.test_parquet b 00:SCAN HDFS 2 999.999us 1.999ms 0 -1 0 32.00 MB default.test_parquet a Planner Timeline Analysis finished: 8811742 Equivalence classes computed: 9173203 Single node plan created: 15071905 Runtime filters computed: 15658665 Distributed plan created: 18322825 Lineage info computed: 19414666 Planning finished: 23426107 Query Timeline Start execution: 0 Planning finished: 32999974 Submit for admission: 36999971 Completed admission: 201299838567 Ready to start 8 remote fragments: 201299838567 All 8 remote fragments started: 209146832163 Cancelled: 209149832164 Rows available: 209155832158 Unregister query: 209158832155 ImpalaServer - ClientFetchWaitTimer: 0 - InactiveTotalTime: 0 - RowMaterializationTimer: 0 - TotalTime: 0 Execution Profile 64c001dc6dcd712:2562d42c35a26399 Number of filters: 2 Filter routing table: ID Src. Node Tgt. Node(s) Targets Target type Partition filter Pending (Expected) First arrived Completed --------------------------------------------------------------------------------------------------------------------- 1 3 0 2 LOCAL false 0 (2) N/A N/A 0 4 0, 1 2, 2 LOCAL, REMOTE false, false 1 (2) N/A N/A Fragment start latencies: Count: 8, 25th %-ile: 8ms, 50th %-ile: 684ms, 75th %-ile: 685ms, 90th %-ile: 686ms, 95th %-ile: 7s844ms, 99.9th %-ile: 7s844ms Per Node Peak Memory Usage: host-10-17-101-153.coe.cloudera.com:22000(0) host-10-17-101-152.coe.cloudera.com:22000(206.52 MB) Final filter table: ID Src. Node Tgt. Node(s) Targets Target type Partition filter Pending (Expected) First arrived Completed --------------------------------------------------------------------------------------------------------------------- 1 3 0 2 LOCAL false 0 (2) N/A N/A 0 4 0, 1 2, 2 LOCAL, REMOTE false, false 1 (2) N/A N/A - FiltersReceived: 0 - FinalizationTimer: 0 - InactiveTotalTime: 0 - TotalTime: 7855993591 Coordinator Fragment F04 - AverageThreadTokens: 1.0 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 8192 - PerHostPeakMemUsage: 0 - PrepareTime: 0 - RowsProduced: 0 - TotalCpuTime: 0 - TotalNetworkReceiveTime: 3000001 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 0 - TotalTime: 3000001 BlockMgr - BlockWritesOutstanding: 0 - BlocksCreated: 166 - BlocksRecycled: 0 - BufferedPins: 0 - BytesWritten: 0 - InactiveTotalTime: 0 - MaxBlockSize: 8388608 - MemoryLimit: 720000000 - PeakMemoryUsage: 185073664 - TotalBufferWaitTime: 0 - TotalEncryptionTime: 0 - TotalIntegrityCheckTime: 0 - TotalReadBlockTime: 0 - TotalTime: 0 EXCHANGE_NODE (id=10) - BytesReceived: 0 - ConvertRowBatchTime: 0 - DeserializeRowBatchTimer: 0 - FirstBatchArrivalWaitTime: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SendersBlockedTimer: 0 - SendersBlockedTotalTimer(*): 0 - TotalTime: 3000001 Averaged Fragment F03 split sizes: min: 0, max: 0, avg: 0, stddev: 0 completion times: min:7s169ms max:7s846ms mean: 7s508ms stddev:338.499ms execution rates: min:0.00 /sec max:0.00 /sec mean:0.00 /sec stddev:0.00 /sec num instances: 2 Averaged Fragment F00 split sizes: min: 3.97 GB, max: 3.98 GB, avg: 3.98 GB, stddev: 2.33 MB completion times: min:7s169ms max:7s852ms mean: 7s511ms stddev:341.499ms execution rates: min:518.80 MB/sec max:567.58 MB/sec mean:543.19 MB/sec stddev:24.39 MB/sec num instances: 2 - AverageThreadTokens: 1.9166666666666667 - BloomFilterBytes: 2097152 - InactiveTotalTime: 0 - PeakMemoryUsage: 157147904 - PerHostPeakMemUsage: 175396888 - PrepareTime: 190999845 - RowsProduced: 0 - TotalCpuTime: 0 - TotalNetworkReceiveTime: 10331991585 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 0 - TotalTime: 96499921 CodeGen - CodegenTime: 999999 - CompileTime: 227999813 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2254648 - NumFunctions: 126 - NumInstructions: 6007 - OptimizationTime: 439999642 - PrepareTime: 179999854 - TotalTime: 847999309 DataStreamSender (dst_id=8) - BytesSent: 0 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 6544 - RowsReturned: 0 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=5) - GetNewBlockTime: 0 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - PartitionsCreated: 16 - PeakMemoryUsage: 1332352 - PinTime: 0 - ReductionFactorEstimate: 0.0 - ReductionFactorThresholdToExpand: 0.0 - RowsPassedThrough: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - StreamingTime: 0 - TotalTime: 190999845 - UnpinTime: 0 HASH_JOIN_NODE (id=4) - BuildPartitionTime: 42999967 - BuildRows: 494592 - BuildRowsPartitioned: 0 - BuildTime: 0 - GetNewBlockTime: 0 - HashBuckets: 0 - HashCollisions: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - LocalTime: 137999889 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 16 - PeakMemoryUsage: 144790576 - PinTime: 0 - ProbeRows: 0 - ProbeRowsPartitioned: 0 - ProbeTime: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 14999988 - UnpinTime: 0 EXCHANGE_NODE (id=7) - BytesReceived: 10562622 - ConvertRowBatchTime: 7999994 - DeserializeRowBatchTimer: 23999980 - FirstBatchArrivalWaitTime: 2150998247 - InactiveTotalTime: 0 - PeakMemoryUsage: 0 - RowsReturned: 495040 - RowsReturnedRate: 95993 - SendersBlockedTimer: 0 - SendersBlockedTotalTimer(*): 0 - TotalTime: 5156995793 HASH_JOIN_NODE (id=3) - BuildPartitionTime: 25999964 - BuildRows: 131072 - BuildRowsPartitioned: 0 - BuildTime: 0 - GetNewBlockTime: 1000001 - HashBuckets: 0 - HashCollisions: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - LocalTime: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 16 - PeakMemoryUsage: 10564640 - PinTime: 0 - ProbeRows: 0 - ProbeRowsPartitioned: 0 - ProbeTime: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 7999993 - UnpinTime: 0 EXCHANGE_NODE (id=6) - BytesReceived: 2797717 - ConvertRowBatchTime: 1999998 - DeserializeRowBatchTimer: 3999997 - FirstBatchArrivalWaitTime: 4175996573 - InactiveTotalTime: 0 - PeakMemoryUsage: 0 - RowsReturned: 131200 - RowsReturnedRate: 25298 - SendersBlockedTimer: 0 - SendersBlockedTotalTimer(*): 0 - TotalTime: 5185995783 HDFS_SCAN_NODE (id=0) - BytesRead: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 0 - RowsRead: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 0 - MaterializeTupleTime(*): 0 - ScannerThreadsSysTime: 0 - ScannerThreadsUserTime: 0 - ScannerThreadsVoluntaryContextSwitches: 0 - TotalReadThroughput: 0 - TotalTime: 1999998 Filter 0 (1.00 MB) - InactiveTotalTime: 0 - Rows processed: 0 - Rows rejected: 0 - Rows total: 0 - TotalTime: 0 Filter 1 (1.00 MB) - InactiveTotalTime: 0 - Rows processed: 0 - Rows rejected: 0 - Rows total: 0 - TotalTime: 0 Averaged Fragment F02 split sizes: min: 3.97 GB, max: 3.98 GB, avg: 3.98 GB, stddev: 2.33 MB completion times: min:7s169ms max:7s845ms mean: 7s507ms stddev:337.999ms execution rates: min:519.27 MB/sec max:567.58 MB/sec mean:543.42 MB/sec stddev:24.15 MB/sec num instances: 2 - AverageThreadTokens: 2.5714285714285716 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 5806856 - PerHostPeakMemUsage: 216556328 - PrepareTime: 1999998 - RowsProduced: 427392 - TotalCpuTime: 0 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 2528997932 - TotalStorageWaitTime: 66999942 - TotalTime: 2804997712 DataStreamSender (dst_id=7) - BytesSent: 18232276 - InactiveTotalTime: 0 - NetworkThroughput(*): 701241951 - OverallThroughput: 243097204 - PeakMemoryUsage: 10912 - RowsReturned: 426368 - SerializeBatchTime: 48999962 - TotalTime: 74999941 - TransmitDataRPCTime: 25999979 - UncompressedRowBatchSize: 34099168 HDFS_SCAN_NODE (id=2) - AverageHdfsReadThreadConcurrency: 0.0 - AverageScannerThreadConcurrency: 1.5714285714285714 - BytesRead: 8235608 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 0 - NumRowGroups: 15 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 5787752 - PerReadThreadRawHdfsThroughput: 2745204496 - RemoteScanRanges: 0 - RowsRead: 457120 - RowsReturned: 427392 - RowsReturnedRate: 141990 - ScanRangesComplete: 13 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 0 - MaterializeTupleTime(*): 2662997824 - ScannerThreadsSysTime: 0 - ScannerThreadsUserTime: 0 - ScannerThreadsVoluntaryContextSwitches: 0 - TotalRawHdfsReadTime(*): 2999998 - TotalReadThroughput: 1176515 - TotalTime: 3009997547 Averaged Fragment F01 split sizes: min: 3.97 GB, max: 3.98 GB, avg: 3.98 GB, stddev: 2.33 MB completion times: min:8.999ms max:7s169ms mean: 3s589ms stddev:3s580ms execution rates: min:567.58 MB/sec max:442.08 GB/sec mean:221.32 GB/sec stddev:220.76 GB/sec num instances: 2 Fragment F03 Instance 64c001dc6dcd712:2562d42c35a2639b (host=host-10-17-101-153.coe.cloudera.com:22000) Instance 64c001dc6dcd712:2562d42c35a2639c (host=host-10-17-101-152.coe.cloudera.com:22000) Fragment F00 Instance 64c001dc6dcd712:2562d42c35a2639e (host=host-10-17-101-152.coe.cloudera.com:22000) Hdfs split stats (:<# splits>/): 0:611/3.98 GB - AverageThreadTokens: 1.9166666666666667 - BloomFilterBytes: 2097152 - InactiveTotalTime: 0 - PeakMemoryUsage: 157147904 - PerHostPeakMemUsage: 175396888 - PrepareTime: 190999845 - RowsProduced: 0 - TotalCpuTime: 0 - TotalNetworkReceiveTime: 10331991585 - TotalNetworkSendTime: 0 - TotalStorageWaitTime: 0 - TotalTime: 192999843 CodeGen - CodegenTime: 999999 - CompileTime: 227999813 - InactiveTotalTime: 0 - LoadTime: 0 - ModuleBitcodeSize: 2254648 - NumFunctions: 126 - NumInstructions: 6007 - OptimizationTime: 439999642 - PrepareTime: 179999854 - TotalTime: 847999309 DataStreamSender (dst_id=8) - BytesSent: 0 - InactiveTotalTime: 0 - NetworkThroughput(*): 0 - OverallThroughput: 0 - PeakMemoryUsage: 6544 - RowsReturned: 0 - SerializeBatchTime: 0 - TotalTime: 0 - TransmitDataRPCTime: 0 - UncompressedRowBatchSize: 0 AGGREGATION_NODE (id=5) ExecOption: Streaming Preaggregation, Codegen Enabled - GetNewBlockTime: 0 - GetResultsTime: 0 - HTResizeTime: 0 - HashBuckets: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - PartitionsCreated: 16 - PeakMemoryUsage: 1332352 - PinTime: 0 - ReductionFactorEstimate: 0.0 - ReductionFactorThresholdToExpand: 0.0 - RowsPassedThrough: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - StreamingTime: 0 - TotalTime: 190999845 - UnpinTime: 0 HASH_JOIN_NODE (id=4) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Hash Table Construction Codegen Enabled, Join Build-Side Prepared Asynchronously - BuildPartitionTime: 42999967 - BuildRows: 494592 - BuildRowsPartitioned: 0 - BuildTime: 0 - GetNewBlockTime: 0 - HashBuckets: 0 - HashCollisions: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - LocalTime: 137999889 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 16 - PeakMemoryUsage: 144790576 - PinTime: 0 - ProbeRows: 0 - ProbeRowsPartitioned: 0 - ProbeTime: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 14999988 - UnpinTime: 0 EXCHANGE_NODE (id=7) - BytesReceived: 10562622 - ConvertRowBatchTime: 7999994 - DeserializeRowBatchTimer: 23999980 - FirstBatchArrivalWaitTime: 2150998247 - InactiveTotalTime: 5140995805 - PeakMemoryUsage: 0 - RowsReturned: 495040 - RowsReturnedRate: 95993 - SendersBlockedTimer: 0 - SendersBlockedTotalTimer(*): 0 - TotalTime: 5156995793 HASH_JOIN_NODE (id=3) ExecOption: Build Side Codegen Enabled, Probe Side Codegen Enabled, Hash Table Construction Codegen Enabled - BuildPartitionTime: 25999964 - BuildRows: 131072 - BuildRowsPartitioned: 0 - BuildTime: 0 - GetNewBlockTime: 1000001 - HashBuckets: 0 - HashCollisions: 0 - InactiveTotalTime: 0 - LargestPartitionPercent: 0 - LocalTime: 0 - MaxPartitionLevel: 0 - NumRepartitions: 0 - PartitionsCreated: 16 - PeakMemoryUsage: 10564640 - PinTime: 0 - ProbeRows: 0 - ProbeRowsPartitioned: 0 - ProbeTime: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - SpilledPartitions: 0 - TotalTime: 7999993 - UnpinTime: 0 EXCHANGE_NODE (id=6) - BytesReceived: 2797717 - ConvertRowBatchTime: 1999998 - DeserializeRowBatchTimer: 3999997 - FirstBatchArrivalWaitTime: 4175996573 - InactiveTotalTime: 5183995785 - PeakMemoryUsage: 0 - RowsReturned: 131200 - RowsReturnedRate: 25298 - SendersBlockedTimer: 0 - SendersBlockedTotalTimer(*): 0 - TotalTime: 5185995783 HDFS_SCAN_NODE (id=0) ExecOption: Expr Evaluation Codegen Disabled Hdfs split stats (:<# splits>/): 0:611/3.98 GB - BytesRead: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 0 - RowsRead: 0 - RowsReturned: 0 - RowsReturnedRate: 0 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 0 - MaterializeTupleTime(*): 0 - ScannerThreadsSysTime: 0 - ScannerThreadsUserTime: 0 - ScannerThreadsVoluntaryContextSwitches: 0 - TotalReadThroughput: 0 - TotalTime: 1999998 Filter 0 (1.00 MB) - InactiveTotalTime: 0 - Rows processed: 0 - Rows rejected: 0 - Rows total: 0 - TotalTime: 0 Filter 1 (1.00 MB) - InactiveTotalTime: 0 - Rows processed: 0 - Rows rejected: 0 - Rows total: 0 - TotalTime: 0 Instance 64c001dc6dcd712:2562d42c35a2639d (host=host-10-17-101-153.coe.cloudera.com:22000) Fragment F02 Instance 64c001dc6dcd712:2562d42c35a263a0 (host=host-10-17-101-152.coe.cloudera.com:22000) Hdfs split stats (:<# splits>/): 0:611/3.98 GB - AverageThreadTokens: 2.5714285714285716 - BloomFilterBytes: 0 - InactiveTotalTime: 0 - PeakMemoryUsage: 5806856 - PerHostPeakMemUsage: 216556328 - PrepareTime: 1999998 - RowsProduced: 427392 - TotalCpuTime: 0 - TotalNetworkReceiveTime: 0 - TotalNetworkSendTime: 2528997932 - TotalStorageWaitTime: 66999942 - TotalTime: 5609995424 DataStreamSender (dst_id=7) - BytesSent: 18232276 - InactiveTotalTime: 0 - NetworkThroughput(*): 701241951 - OverallThroughput: 243097204 - PeakMemoryUsage: 10912 - RowsReturned: 426368 - SerializeBatchTime: 48999962 - TotalTime: 74999941 - TransmitDataRPCTime: 25999979 - UncompressedRowBatchSize: 34099168 HDFS_SCAN_NODE (id=2) ExecOption: Expr Evaluation Codegen Disabled Hdfs split stats (:<# splits>/): 0:611/3.98 GB - AverageHdfsReadThreadConcurrency: 0.0 - AverageScannerThreadConcurrency: 1.5714285714285714 - BytesRead: 8235608 - BytesReadDataNodeCache: 0 - BytesReadLocal: 0 - BytesReadRemoteUnexpected: 0 - BytesReadShortCircuit: 0 - DecompressionTime: 0 - InactiveTotalTime: 0 - MaxCompressedTextFileLength: 0 - NumColumns: 1 - NumDisksAccessed: 0 - NumRowGroups: 15 - NumScannerThreadsStarted: 2 - PeakMemoryUsage: 5787752 - PerReadThreadRawHdfsThroughput: 2745204496 - RemoteScanRanges: 0 - RowsRead: 457120 - RowsReturned: 427392 - RowsReturnedRate: 141990 - ScanRangesComplete: 13 - ScannerThreadsInvoluntaryContextSwitches: 0 - ScannerThreadsTotalWallClockTime: 0 - MaterializeTupleTime(*): 2662997824 - ScannerThreadsSysTime: 0 - ScannerThreadsUserTime: 0 - ScannerThreadsVoluntaryContextSwitches: 0 - TotalRawHdfsReadTime(*): 2999998 - TotalReadThroughput: 1176515 - TotalTime: 3009997547 Instance 64c001dc6dcd712:2562d42c35a2639f (host=host-10-17-101-153.coe.cloudera.com:22000) Fragment F01 Instance 64c001dc6dcd712:2562d42c35a263a1 (host=host-10-17-101-153.coe.cloudera.com:22000) Instance 64c001dc6dcd712:2562d42c35a263a2 (host=host-10-17-101-152.coe.cloudera.com:22000)