You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Peter Vary (JIRA)" <ji...@apache.org> on 2018/02/21 10:48:00 UTC

[jira] [Comment Edited] (HIVE-17300) WebUI query plan graphs

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

Peter Vary edited comment on HIVE-17300 at 2/21/18 10:47 AM:
-------------------------------------------------------------

Hi [~szehon],

Will try to find some time to rebase the patch, but currently there are plenty of stuff on my plate - if by any chance you have more time, I will definitely review it.

As for the parameter for refreshing the stats - for every running query this keeps extra stuff in memory (not too much, but anyway). But IIRC we thought it more important, that some users might be confused if a JSON is printed for them on the WebUI :)

Thanks for taking a look at this! If you do not have time to pick this up, I will definitely try to revisit this some time in the future, and will ping you when it is rebased.

Peter

 


was (Author: pvary):
Hi [~szehon],

Will try to find some time to rebase the patch, but currently there are plenty of stuff on my plate - if by any chance you have more time, I will definitely can review it.

As for the parameter for refreshing the stats - for every running query this keeps extra stuff in memory. But IIRC we thought it more important, that some users might be confused if a JSON is printed for them on the WebUI :)

Thanks for taking a look at this! If you do not have time to pick this up, I will definitely try to revisit this some time in the future, and will ping you when it is rebased.

Peter

 

> WebUI query plan graphs
> -----------------------
>
>                 Key: HIVE-17300
>                 URL: https://issues.apache.org/jira/browse/HIVE-17300
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Web UI
>            Reporter: Karen Coppage
>            Assignee: Karen Coppage
>            Priority: Major
>         Attachments: HIVE-17300.3.patch, HIVE-17300.4.patch, HIVE-17300.5.patch, HIVE-17300.patch, complete_success.png, full_mapred_stats.png, graph_with_mapred_stats.png, last_stage_error.png, last_stage_running.png, non_mapred_task_selected.png
>
>
> Hi all,
> I’m working on a feature of the Hive WebUI Query Plan tab that would provide the option to display the query plan as a nice graph (scroll down for screenshots). If you click on one of the graph’s stages, the plan for that stage appears as text below. 
> Stages are color-coded if they have a status (Success, Error, Running), and the rest are grayed out. Coloring is based on status already available in the WebUI, under the Stages tab.
> There is an additional option to display stats for MapReduce tasks. This includes the job’s ID, tracking URL (where the logs are found), and mapper and reducer numbers/progress, among other info. 
> The library I’m using for the graph is called vis.js (http://visjs.org/). It has an Apache license, and the only necessary file to be included from this library is about 700 KB.
> I tried to keep server-side changes minimal, and graph generation is taken care of by the client. Plans with more than a given number of stages (default: 25) won't be displayed in order to preserve resources.
> I’d love to hear any and all input from the community about this feature: do you think it’s useful, and is there anything important I’m missing?
> Thanks,
> Karen Coppage
> Review request: https://reviews.apache.org/r/61663/
> Any input is welcome!



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