You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Sahil Takiar (JIRA)" <ji...@apache.org> on 2018/03/22 00:12:00 UTC

[jira] [Commented] (HIVE-18525) Add explain plan to Hive on Spark Web UI

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

Sahil Takiar commented on HIVE-18525:
-------------------------------------

[~xuefuz], [~aihuaxu], [~belugabehr] any thoughts on this feature? I've attached multiple screenshots to show what the Web UI looks like.

Some things to note:
* Not sure whether to make this feature configurable, and not sure whether to turn it on or off
* This change is mainly geared to users who use the Spark Web UI to visualize / debug their queries
* Spark SQL has a similar-ish feature, so ideally the Web UI should be able to handle the extra per-query info
* The patch is still a WIP, I need to profile how long it takes for the explain plan to get generated

> Add explain plan to Hive on Spark Web UI
> ----------------------------------------
>
>                 Key: HIVE-18525
>                 URL: https://issues.apache.org/jira/browse/HIVE-18525
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Spark
>            Reporter: Sahil Takiar
>            Assignee: Sahil Takiar
>            Priority: Major
>         Attachments: HIVE-18525.1.patch, HIVE-18525.2.patch, Job-Page-Collapsed.png, Job-Page-Expanded.png, Map-Explain-Plan.png, Reduce-Explain-Plan.png
>
>
> More of an investigation JIRA. The Spark UI has a "long description" of each stage in the Spark DAG. Typically one stage in the Spark DAG corresponds to either a {{MapWork}} or {{ReduceWork}} object. It would be useful if the long description contained the explain plan of the corresponding work object.
> I'm not sure how much additional overhead this would introduce. If not the full explain plan, then maybe a modified one that just lists out all the operator tree along with each operator name.



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