[ 
https://issues.apache.org/jira/browse/DRILL-5735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16514568#comment-16514568
 ] 

ASF GitHub Bot commented on DRILL-5735:
---------------------------------------

parthchandra commented on a change in pull request #1279: DRILL-5735: Allow 
search/sort in the Options webUI
URL: https://github.com/apache/drill/pull/1279#discussion_r195887055
 
 

 ##########
 File path: 
exec/java-exec/src/main/java/org/apache/drill/exec/store/sys/SystemTable.java
 ##########
 @@ -31,6 +31,7 @@
  * </p>
  */
 public enum SystemTable {
+  @Deprecated
 
 Review comment:
   I see inconsistent behaviour for sys.options. If I override an option at the 
session level, two rows show up in the table, one for the default and one for 
the overridden (sys.options_val always shows only one). If, however, I override 
an option at the system level only one row shows up in the table, the 
overridden one. 
   Ideal would be to show both, but also coalesce the columns for the value (as 
in options_val).
   I think we should log a separate Jira for that.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


> UI options grouping and filtering & Metrics hints
> -------------------------------------------------
>
>                 Key: DRILL-5735
>                 URL: https://issues.apache.org/jira/browse/DRILL-5735
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Web Server
>    Affects Versions: 1.9.0, 1.10.0, 1.11.0
>            Reporter: Muhammad Gelbana
>            Assignee: Kunal Khatua
>            Priority: Major
>             Fix For: 1.14.0
>
>
> I'm thinking of some UI improvements that could make all the difference for 
> users trying to optimize low-performing queries.
> h2. Options
> h3. 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.
> h3. 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.
> h2. 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:
> # What does it represent in more details.
> # What option\scope-of-options to tune (increase ? decrease ?) to improve the 
> performance reported by this metric.
> # May be even provide a small dialog to quickly allow the modification of the 
> related option(s) to that metric



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to