[AMBARI-19890] Hive2: Query Runtime Prediction: Compact Visual Explain Plan

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.5.0
• Fix Version/s: 2.5.0
• Component/s: ambari-views
• Assignee: Pallav Kulshreshtha
• Reporter: Pallav Kulshreshtha
• Due: 08/Feb/17
• Created: 07/Feb/17 11:57
• Updated: 08/Feb/17 11:07
• Resolved: 08/Feb/17 11:07

Description

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

Issue Links

• links to: Review board link