You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Tim Armstrong (JIRA)" <ji...@apache.org> on 2018/12/11 20:37:00 UTC
[jira] [Updated] (IMPALA-4212) Explain plan should show the
expression evaluated in all exec node
[ https://issues.apache.org/jira/browse/IMPALA-4212?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tim Armstrong updated IMPALA-4212:
----------------------------------
Description:
*Problem Statement*
The explain plan does not show the expression evaluated at HDFS Table Sinks and UNIONs, as well as the final result expressions evaluated at the coordinator. These expression can be very complex. If these complex expression are hidden inside a view (e.g. insert into dst select * from view), it's very hard to tell from the query profile or the plan that the slow HDFS table sink is due complex expressions.
*Proposed Solution*
Explain plan should show the expression evaluated at exec nodes and data sinks as well as the final result exprs. Then it would be quite obvious that a slow sink or union is due to these expressions.
was:
*Problem Statement*
The explain plan does not show the expression evaluated at HDFS Table Sinks and UNIONs, as well as the final result expressions evaluated at the coordinator. These expression can be very complex. If these complex expression are hidden inside a view (e.g. insert into dst select * from view), it's very hard to tell from the query profile or the plan that the slow HDFS table sink is due complex expressions.
*Proposed Solution*
1. Explain plan should show the expression evaluated at exec nodes and data sinks as well as the final result exprs. Then it would be quite obvious that a slow sink or union is due to these expressions.
2. (Optional) In the query profile, report the time spent in evaluating the expressions.
> Explain plan should show the expression evaluated in all exec node
> ------------------------------------------------------------------
>
> Key: IMPALA-4212
> URL: https://issues.apache.org/jira/browse/IMPALA-4212
> Project: IMPALA
> Issue Type: Improvement
> Components: Frontend
> Affects Versions: Impala 2.7.0
> Reporter: Alan Choi
> Assignee: Henry Robinson
> Priority: Major
> Labels: supportability
>
> *Problem Statement*
> The explain plan does not show the expression evaluated at HDFS Table Sinks and UNIONs, as well as the final result expressions evaluated at the coordinator. These expression can be very complex. If these complex expression are hidden inside a view (e.g. insert into dst select * from view), it's very hard to tell from the query profile or the plan that the slow HDFS table sink is due complex expressions.
> *Proposed Solution*
> Explain plan should show the expression evaluated at exec nodes and data sinks as well as the final result exprs. Then it would be quite obvious that a slow sink or union is due to these expressions.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org