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.