ambari-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pallav Kulshreshtha (JIRA)" <j...@apache.org>
Subject [jira] [Created] (AMBARI-19890) Hive2: Query Runtime Prediction: Compact Visual Explain Plan
Date Tue, 07 Feb 2017 11:57:41 GMT
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)

Mime
View raw message