Thank you again I also see jobs getting cancelled. can you give me any reason? Query ID: 3348f74b129b0dae:1666447600000000 User: pslc_mnr_bu Database: default Coordinator: p1i-hdp-srv11.lnt.com Query Type: QUERY Query State: EXCEPTION Start Time: Nov 14, 2019 10:12:22 AM End Time: Nov 14, 2019 10:13:02 AM Duration: 39.6s Rows Produced: 0 Admission Result: Admitted immediately Admission Wait Time: 0ms Aggregate Peak Memory Usage: 260.5 MiB Bytes Streamed: 46.9 MiB Client Fetch Wait Time: 0ms Client Fetch Wait Time Percentage: 0 Connected User: psvc_mpr_bi Estimated per Node Peak Memory: 2.3 GiB File Formats: PARQUET/SNAPPY HDFS Average Scan Range: 356.3 KiB HDFS Bytes Read: 2.0 GiB HDFS Bytes Read From Cache: 0 B HDFS Bytes Read From Cache Percentage: 0 HDFS Local Bytes Read: 1.0 GiB HDFS Local Bytes Read Percentage: 50 HDFS Remote Bytes Read: 1.0 GiB HDFS Remote Bytes Read Percentage: 50 HDFS Scanner Average Read Throughput: 412.7 MiB/s HDFS Short Circuit Bytes Read: 1.0 GiB HDFS Short Circuit Bytes Read Percentage: 50 Impala Version: impalad version 3.0.0-cdh6.0.1 RELEASE (build 9a74a5053de5f7b8dd983802e6d75e58d31472db) Memory Accrual: 479,253,548 byte seconds Memory Spilled: 0 B Node with Peak Memory Usage: p1i-hdp-srv03.lnt.com:22000 Number of Backends: 13 Number of Query Fragments Instances: 485 Out of Memory: false Per Node Peak Memory Usage: 220.5 MiB Planning Wait Time: 4.55s Planning Wait Time Percentage: 11 Query Status: Cancelled Session ID: 3041e4d70d3697bc:efc9a3fe12cfa1a2 Session Type: HIVESERVER2 Statistics Corrupt: false Statistics Missing: false Threads: CPU Time: 3.6m Threads: CPU Time Percentage: 9 Threads: Network Receive Wait Time: 13.5m Threads: Network Receive Wait Time Percentage: 33 Threads: Network Send Wait Time: 41.99s Threads: Network Send Wait Time Percentage: 2 Threads: Storage Wait Time: 23.5m Threads: Storage Wait Time Percentage: 57 Threads: Total Time: 41.3m Thanks
... View more
