[jira] [Created] (ARROW-9654) [Rust][DataFusion] Add an EXPLAIN command to the datafusion CLI

["Andrew Lamb (Jira)" <ji...@apache.org>]

Andrew Lamb created ARROW-9654:
----------------------------------

             Summary: [Rust][DataFusion] Add an EXPLAIN command to the datafusion CLI
                 Key: ARROW-9654
                 URL: https://issues.apache.org/jira/browse/ARROW-9654
             Project: Apache Arrow
          Issue Type: New Feature
            Reporter: Andrew Lamb


In order to understand what DataFusion's planner is doing, it would be helpful to have an "EXPLAIN PLAN" feature. All other database systems I have worked with have such a feature (e.g. see [MySql|https://dev.mysql.com/doc/refman/8.0/en/explain-output.html]). 

I have found EXPLAIN helpful for both users but also very much developers.

The feature would look something like
{code}
EXPLAIN <sql>
{code}

Which would then print a string with the logical plan. One way to implement this would simply be to use the debugging printout of the logical and physical plans




--
This message was sent by Atlassian Jira
(v8.3.4#803005)