Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add FORMAT to explain plan and an easy to visualize format #96

Closed
alamb opened this issue Apr 26, 2021 · 2 comments
Closed

Add FORMAT to explain plan and an easy to visualize format #96

alamb opened this issue Apr 26, 2021 · 2 comments
Labels
datafusion Changes in the datafusion crate

Comments

@alamb
Copy link
Contributor

alamb commented Apr 26, 2021

Note: migrated from original JIRA: https://issues.apache.org/jira/browse/ARROW-9746

As suggested by [~jorgecarleitao] on apache/arrow#7959 (review) --

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)

@alamb alamb added the datafusion Changes in the datafusion crate label Apr 26, 2021
@alamb
Copy link
Contributor Author

alamb commented Apr 26, 2021

Comment from Andy Grove(andygrove) @ 2020-08-21T22:52:56.140+0000:

I am also a fan of dot and graphviz. Would be great to see this.

Comment from Andrew Lamb(alamb) @ 2021-04-26T12:33:13.812+0000:

Migrated to github: https://github.com/apache/arrow-rs/issues/94

@alamb
Copy link
Contributor Author

alamb commented Oct 1, 2022

Dupe of by #3606 -- @Dandandan is working to put graphviz plans 🎉

@alamb alamb closed this as completed Oct 1, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
datafusion Changes in the datafusion crate
Projects
None yet
Development

No branches or pull requests

1 participant