[jira] [Comment Edited] (DRILL-5247) Text form of EXPLAIN statement does not have same information as profile

["Chunhui Shi (JIRA)" <ji...@apache.org>]

    [ 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)