Paul Rogers created DRILL-5247:
----------------------------------
Summary: 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)
