[DRILL-5735] UI options grouping and filtering & Metrics hints

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.9.0, 1.10.0, 1.11.0
• Fix Version/s: 1.15.0
• Component/s: Web Server
• Labels: doc-complete ready-to-commit
• Assignee: Kunal Khatua
• Reporter: Mohamed Mohsen
• Reviewer: Arina Ielchiieva
• Created: 21/Aug/17 10:14
• Updated: 25/Feb/19 16:15
• Resolved: 30/Aug/18 21:46

Description

I'm thinking of some UI improvements that could make all the difference for users trying to optimize low-performing queries.

Options

Grouping

We can organize the options to be grouped by their scope of effect, this will help users easily locate the options they may need to tune.

Filtering

Since the options are a lot, we can add a filtering mechanism (i.e. string search or group\scope filtering) so the user can filter out the options he's not interested in. To provide more benefit than the grouping idea mentioned above, filtering may include keywords also and not just the option name, since the user may not be aware of the name of the option he's looking for.

Metrics

I'm referring here to the metrics page and the query execution plan page that displays the overview section and major\minor fragments metrics. We can show hints for each metric such as:

1. What does it represent in more details.
2. What option\scope-of-options to tune (increase ? decrease ?) to improve the performance reported by this metric.
3. May be even provide a small dialog to quickly allow the modification of the related option(s) to that metric

Issue Links

• causes: DRILL-7056 Drill fails with NPE when starting in distributed mode and 31010 port is used
• is related to: DRILL-4699 Add Description Column in sys.options
• is related to: DRILL-6668 In Web Console, highlight options that are different from default values
• is related to: DRILL-6684 Swap sys.options and sys.options_val tables
• links to: GitHub Pull Request #1279