Models

JobStatus

Represents the status of a job.

{
  "jobState": String [NOT_SUBMITTED, STARTING, RUNNING, COMPLETED, CANCELED, FAILED, CANCELLATION_REQUESTED, ENQUEUED]
  "queryType": String [UI_RUN, UI_PREVIEW, UI_INTERNAL_PREVIEW, UI_INTERNAL_RUN, UI_EXPORT, ODBC, JDBC, REST, ACCELERATOR_CREATE, ACCELERATOR_DROP, UNKNOWN, PREPARE_INTERNAL, ACCELERATOR_EXPLAIN, UI_INITIAL_PREVIEW]
  "startedAt": String (RFC3339 date),
  "endedAt": String (RFC3339 date),
  "rowCount": Number [optional],
  "acceleration": JobAccelerationStatus [optional],
  "errorMessage": String [optional]
}

Fields

Name Type Description
jobState String The state of the job, will be either NOT_SUBMITTED, STARTING, RUNNING, COMPLETED, CANCELED, FAILED, CANCELLATION_REQUESTED, or ENQUEUED
queryType String The type corresponding to what mechanism was used to submit this query, will be either UI_RUN, UI_PREVIEW, UI_INTERNAL_PREVIEW, UI_INTERNAL_RUN, UI_EXPORT, ODBC, JDBC, REST, ACCELERATOR_CREATE, ACCELERATOR_DROP, UNKNOWN, PREPARE_INTERNAL, ACCELERATOR_EXPLAIN, or UI_INITIAL_PREVIEW.
startedAt String RFC3339 date (example: 2017-10-27T21:08:22.858Z) representing the datetime the query was started.
endedAt String RFC3339 date (example: 2017-10-27T21:08:22.858Z) representing the datetime the query ended.
rowCount Number If the query is in COMPLETED state then the number of returned rows will be present.
acceleration JobAccelerationStatus Present if the query may have been accelerated.
errorMessage String If the query is in FAILED state will show the error that was recorded causing to the failure.

JobAccelerationStatus

When a query is run, reflections may be used to accelerate it. JobAccelerationStatus provides a list of relationships containing information about reflections that were detected as potentially applicable.

{
  "relationships": [JobAccelerationRelationship]
}

JobAccelerationRelationship

Describes the relationship a reflection had regarding the job.

{
  "reflectionId": String,
  "datasetId": String,
  "relationship": String [CONSIDERED, MATCHED, CHOSEN]
}

A reflection is CONSIDERED if the reflection is defined on a dataset that is used in the query but was determined to not cover the query (for example the reflection did not have a field that is used by the query).

A reflection is MATCHED if a reflection could have been used to accelerate the query but Dremio determined that it would not provide any benefits or another reflection was determined to be a better choice.

A CHOSEN reflection was used to accelerate the query. Note that multiple reflections can be used to accelerate queries.

JobResults

Represents the results of a successfully completed job.

{
  "rowCount": Number,
  "schema": [FieldSchema],
  "rows": [Json]
}

Fields

Name Type Description
rowCount Number The total number of rows for the job.
schema [FieldSchema] An array of FieldSchema definitions. Represents the schema of the data returned by the job.
rows [Json] The JSON representation of the requested rows.

FieldSchema

Represents the schema of a field. See here for full definition.