@Zane, The issues I can see from this profile as below: 1. The query got closed due to client inactivity: Query f64da6a899944136:22dcac6800000000 expired due to client inactivity (timeout is 10m) Not because of OOM 2. you do not have table stats, which can cause impala to use bad query plan: WARNING: The following tables are missing relevant table and/or column statistics. external_data.physician_compare This is evident that in the SUMMARY section, the estimated rows are -1: Operator #Hosts Avg Time Max Time #Rows Est. #Rows Peak Mem Est. Peak Mem Detail -------------------------------------------------------------------------------------------------------------------------- 01:EXCHANGE 1 189.890ms 189.890ms 1.02K -1 0 0 UNPARTITIONED 00:SCAN HDFS 5 98.859ms 104.753ms 22.53K -1 78.33 MB 176.00 MB external_data.physician_compare 3. Query finished in about 1 second, as result was ready after 1.45 seconds: First row fetched: 1.45s 4. I can see the query is most likely from hue: Session Type: HIVESERVER2 So my conclusion is that user stayed in Hue Hive editor idle until query is closed from server side. There is no issue from the query itself whatsoever. Cheers
... View more
