drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul Rogers (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5247) Text form of EXPLAIN statement does not have same information as profile
Date Thu, 09 Feb 2017 01:07:41 GMT
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)

Mime
View raw message