[jira] [Created] (ARROW-9746) [Rust][DataFusion] Add FORMAT to explain plan and an easy to visualize format

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

Andrew Lamb created ARROW-9746:
----------------------------------

             Summary: [Rust][DataFusion] Add FORMAT to explain plan and an easy to visualize format
                 Key: ARROW-9746
                 URL: https://issues.apache.org/jira/browse/ARROW-9746
             Project: Apache Arrow
          Issue Type: Improvement
            Reporter: Andrew Lamb


As suggested by [~jorgecarleitao] on https://github.com/apache/arrow/pull/7959#pullrequestreview-467291192 -- 

> #### Other formats?
> One thing I dislike about spark is that EXPLAIN is in a not-so-nice format to parse programmatically. One idea is to allow `explain` to return the result in json. This is e.g. useful to construct a visual graph representation of the plan. One idea would be to support another string parameter, `format`, and make it default to `string` (not necessarily in this PR).

The typical thing I have used in the past to great effect is graphviz: https://graphviz.org/ and `dot` -- so the idea is that we would get a command like:

{code}
EXPLAIN FORMAT GRAPHVIZ SELECT * FROM FOO
{code}

which would provide the plan in graphviz format (in addition to text)




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