You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ambari.apache.org by "Pallav Kulshreshtha (JIRA)" <ji...@apache.org> on 2017/02/07 11:57:41 UTC

[jira] [Created] (AMBARI-19890) Hive2: Query Runtime Prediction: Compact Visual Explain Plan

Pallav Kulshreshtha created AMBARI-19890:
--------------------------------------------

             Summary: Hive2: Query Runtime Prediction: Compact Visual Explain Plan
                 Key: AMBARI-19890
                 URL: https://issues.apache.org/jira/browse/AMBARI-19890
             Project: Ambari
          Issue Type: Bug
          Components: ambari-views
    Affects Versions: 2.5.0
            Reporter: Pallav Kulshreshtha
            Assignee: Pallav Kulshreshtha
            Priority: Critical
             Fix For: 2.5.0



The explain plan is the key tool DBAs use to optimize queries. Just like full screen editing is needed for complex queries, it is essential that the explain plan be compact enough to represent complex queries. The current visual explain plan only allows a few operators to be displayed at once on the screen.
As a DBA I should be able to see a moderately complex query (~ 15 operators) on a single screen.
As a DBA the explain plan should focus on the key information, namely statistics and costs.
As a DBA I should be able to drill down into an operator for additional information, if needed.
The explain plan should update to reflect changes to tuning parameters.
It should be possible to view the "explain analyze" information in the explain plan



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)