[DRILL-5068] Create a system table for completed profiles - sys.profiles

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.8.0
• Fix Version/s: 1.13.0
• Component/s: Storage - Information Schema

Environment

Fedora 25
OpenJDK 8
Firefox 50.0

• Flags: Patch
• Assignee: Kunal Khatua
• Reporter: Account Not Used
• Reviewer: Sorabh Hamirwasia
• Created: 24/Nov/16 13:13
• Updated: 17/Oct/18 01:02
• Resolved: 09/Jan/18 02:11

Description

Hi,

Currently the profile page on UI is still not detailed enough for some complicated uses (eg. show all failed queries during these three days), we can only access latest 100 query profiles on this page.

We may sometimes need a specific system table for querying completed profiles.

Issue Links

• is related to: DRILL-3989 Create a sys.queries table
• is related to: DRILL-5270 Improve loading of profiles listing in the WebUI
• links to: GitHub Pull Request #668
• links to: GitHub Pull Request #668
• links to: GitHub Pull Request #1077