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

["Paul Rogers (JIRA)" <ji...@apache.org>]

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)