petern48 opened a new issue, #17480: URL: https://github.com/apache/datafusion/issues/17480
### Describe the bug On the `datafusion-cli`, `tree` was made the default explain format in [this PR](https://github.com/apache/datafusion/pull/15427). Now, when we use `EXPLAIN VERBOSE`, we simply get the regular output of `explain format tree`, which isn't verbose. Since only `indent` is supported for `explain verbose`, I think it would be nice to just override the explain format to `indent` when verbose is specified. ### To Reproduce cd `datafusion-cli` `cargo run` ```sql > explain verbose select max(1 + 3); +---------------+-------------------------------+ | plan_type | plan | +---------------+-------------------------------+ | physical_plan | ┌───────────────────────────┐ | | | │ AggregateExec │ | | | │ -------------------- │ | | | │ aggr: │ | | | │ max(Int64(1) + Int64(3)) │ | | | │ │ | | | │ mode: Single │ | | | └─────────────┬─────────────┘ | | | ┌─────────────┴─────────────┐ | | | │ PlaceholderRowExec │ | | | └───────────────────────────┘ | | | | +---------------+-------------------------------+ ``` To workaround this, the user has to manually set the format option to `indent` to get the desired verbose explain output ```sql set datafusion.explain.format = 'indent'; > explain verbose select max(1 + 3); ``` ### Expected behavior _No response_ ### Additional context _No response_ -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org For additional commands, e-mail: github-h...@datafusion.apache.org
