[
https://issues.apache.org/jira/browse/DRILL-5247?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15858883#comment-15858883
]
Chunhui Shi edited comment on DRILL-5247 at 2/9/17 2:19 AM:
------------------------------------------------------------
"explain plan including all attributes for " will get the cost details
returned. Is that not enough? if you need cost information about abandoned
plans, usually I will go to calcite logs.
was (Author: cshi):
"explain plan including all attributes for " will get the cost details
returned. Is that not enough, if you need cost information about abandoned
plans, usually I will go to calcite logs.
> Text form of EXPLAIN statement does not have same information as profile
> ------------------------------------------------------------------------
>
> Key: DRILL-5247
> URL: https://issues.apache.org/jira/browse/DRILL-5247
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.9.0
> Reporter: Paul Rogers
> Priority: Minor
>
> Create as simple query. Run it and view the "physical plan" in the Web UI or
> the profile JSON. That plan contains a rich set of information about operator
> costs and so on.
> Now, with the same query, execute an EXPLAIN statement. The resulting plan
> looks like the one in the profile, but lacks the cost detail. (See below.)
> Since the cost detail comes from the planner, and is essential to
> understanding why a plan was chosen, the information should appear in the
> EXPLAIN output. (After all, the output is supposed to EXPLAIN the plan...)
> Example of EXPLAIN output:
> {code}
> 00-00 Screen
> 00-01 Project(id_i=[$0], name_s20=[$1])
> 00-02 SelectionVectorRemover
> 00-03 Filter(condition=[=($0, 10)])
> 00-04 Scan(groupscan=[MockGroupScanPOP [url=null,
> readEntries=[MockScanEntry [records=10000, columns=[MockColumn
> [minorType=INT, name=id_i, mode=REQUIRED], MockColumn [minorType=VARCHAR,
> name=name_s20, mode=REQUIRED]]]]]])
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
