[IMPALA-1396] Query cancelled from Impala shell displayed as in-flight in Web UI.

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 2.0
• Fix Version/s: Impala 2.1
• Assignee: Alex Leblang
• Reporter: Alexander Behm
• Created: 17/Oct/14 06:12
• Updated: 19/Nov/14 18:00
• Resolved: 19/Nov/14 18:00

Description

Reproduction:

1. Run this query from the Impala shell.

use functional;
select sum(t1.int_col * t1.id) OVER (
ORDER BY t1.int_col * t1.id ASC, t3.year + t3.tinyint_col ASC ROWS
BETWEEN 66 PRECEDING AND 21 FOLLOWING) AS int_col_1
FROM alltypes t1
INNER JOIN alltypes t2 ON t2.month = t1.smallint_col
INNER JOIN alltypes t3 ON t3.bigint_col = t2.bigint_col
WHERE
t2.id <= t3.smallint_col + t2.tinyint_col
order by 1
limit 5;

2. Cancel the query with Ctrl+C

3. Go to Impala Web UI and observe that the query is in the EXCEPTION state, but still in the in-flight list.

Instead, the query should be moved to the completed queries list.

From observing the metrics, it appears that the query is at least not consuming resources anymore.