Summary
This article discusses the fact that the verbose profile is not included in the downloaded data even when Support Key planner.verbose_profile is enabled.
Reported Issue
Should you investigate a Dremio issue, you can enable Support Key planner.verbose_profile for example, in order to provide more details on planning steps.
Instead of enabling it for the full cluster, you can run in a session via the ui by running an alter session command before your run the query you want to investigate.
The profile generated for investigation will have verbose enabled, but if you opt to download the data within the same ui framework, it will not have verbose enabled.
Relevant Versions
All versions of Dremio post Dremio 23.
Troubleshooting Steps
Run the following ALTER SESSION in a later Dremio release where multi statement is possible:
alter session set planner.verbose_profile=true;
select * from sys.options;
Now, if you choose to download the data within the SQL Runner, you will find that Dremio re-runs the query, with no ALTER SESSION being applied.
Cause
When downloading data within the SQL Runner, Dremio re-runs the query without applying the ALTER SESSION command that was previously executed.
Steps to Resolve
N/A
Tips & Tricks
Best Practices
Recommendations
FAQ
Additional Resources
This is being reported in Jira DX-67228