Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5735

UI options grouping and filtering & Metrics hints

    Details

    • Type: Improvement
    • Status: Reviewable
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.9.0, 1.10.0, 1.11.0
    • Fix Version/s: 1.14.0
    • Component/s: Web Server
    • Labels:
      None

      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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                kkhatua Kunal Khatua
                Reporter:
                mgelbana Muhammad Gelbana
                Reviewer:
                John Omernik
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: