[DRILL-1326] Running Queries is not cleaned in query GUI

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.4.0
• Fix Version/s: 0.7.0
• Component/s: Query Planning & Optimization

Environment

MapR 3.1.1
Drill 0.4.0
CentOS 6.4

• Assignee: Unassigned
• Reporter: Hao Zhu
• Created: 22/Aug/14 22:53
• Updated: 17/Nov/14 01:03
• Resolved: 17/Nov/14 01:03

Description

Some queries are not cleaned from "Running Queries" section in http://<IP>:8047/profiles page.
(See attached picture.)

I can simply reproduce this by running below query :

select a.*
 from cp.`employee.json` a, cp.`employee.json` b
 where a.position_id=b.position_id;

When it is printing the output, type "ctrl-C" to stop it.
After that, the "Running Queries" add it and never clean it.
This happens to some long-running queries for which I "kill -9".

The asks/suggestions:
1. Could we have a system view or table to show currently running queries?
2. How to clean the "Running Queries"?