This topic provides detailed job information.
Job detailed information includes:
A new systems table,
sys.job_results, has been added that allows you to query the job results using the sys.job_result.<job id> path. This allows you to use jobs to query the sub-schema instead of re-running the original query. However, query results using this method will not show job details. Job details will only display from the Dremio UI, as shown in the image below.
This table can be queried if the job is complete and the end user has access to the data. For example:
select * from sys.job_results."226c41ee-fced-8f23-b030-99b5c5fa8900"
returns the results of the job,
226c41ee-fced-8f23-b030-99b5c5fa8900. You must include quotation marks (") before and after the job number.
Generate Query Support Bundlebutton appears only on YARN-based Dremio deployments.