Skip to content

Conversation

Tishj
Copy link
Contributor

@Tishj Tishj commented Sep 13, 2024

This PR fixes #13926

For Jupyter we use the HTMLTreeRenderer (equivalent to EXPLAIN(FORMAT HTML) when rel.explain() is used.

The HTML format is not implemented for EXPLAIN ANALYZE which causes an error to be thrown.
Now we no longer use the HTML format when analyze is provided to rel.explain()

@Mytherin Mytherin merged commit 8ffd8ad into duckdb:main Sep 13, 2024
15 checks passed
@Mytherin
Copy link
Collaborator

Thanks!

@abramk
Copy link
Contributor

abramk commented Sep 16, 2024

I attempted to add html and graphviz to explain analyze in #13942. I can do with some help in resolving the CI errors.

github-actions bot pushed a commit to duckdb/duckdb-r that referenced this pull request Sep 25, 2024
Only bind to SQL value functions if there is no alias with this name present we can bind to instead (duckdb/duckdb#13925)
[Python][Jupyter] Don't use `ExplainFormat::HTML` for `explain('analyze')` (duckdb/duckdb#13928)
[CI] Invert operations on OSX.yml, deploying nightly artifacts before test (duckdb/duckdb#13927)
fix REGEX not supported anymore for valid queries (only statement error) duckdb/duckdb#2889 (duckdb/duckdb#13633)
[Python] Improve `install_extension` to support `repository`/`repository_url` and `version` (duckdb/duckdb#13876)
Remove buffer_manager_allocate.patch and bump spatial (duckdb/duckdb#13895)
github-actions bot added a commit to duckdb/duckdb-r that referenced this pull request Sep 25, 2024
Only bind to SQL value functions if there is no alias with this name present we can bind to instead (duckdb/duckdb#13925)
[Python][Jupyter] Don't use `ExplainFormat::HTML` for `explain('analyze')` (duckdb/duckdb#13928)
[CI] Invert operations on OSX.yml, deploying nightly artifacts before test (duckdb/duckdb#13927)
fix REGEX not supported anymore for valid queries (only statement error) duckdb/duckdb#2889 (duckdb/duckdb#13633)
[Python] Improve `install_extension` to support `repository`/`repository_url` and `version` (duckdb/duckdb#13876)
Remove buffer_manager_allocate.patch and bump spatial (duckdb/duckdb#13895)

Co-authored-by: krlmlr <krlmlr@users.noreply.github.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Explain Analyze Error
3 participants