Previewing SQL Job Query Results

Function

This API is used to view the job execution result after a job is executed using SQL query statements. Currently, you can only query execution results of jobs of the QUERY type.

This API can be used to view only the first 1000 result records and does not support pagination query. To view all query results, you need to export the query results first. For details, see Exporting Query Results.

URI

• URI format

  GET /v1.0/{project_id}/jobs/{job_id}/preview

• Parameter description

  Table 1 URI parameters

  Parameter	Mandatory	Type	Description
  project_id	Yes	String	Project ID, which is used for resource isolation. For details about how to obtain its value, see Obtaining a Project ID.
  job_id	Yes	String	Job ID

  Table 2 query parameter description

  Parameter	Mandatory	Type	Description
  page-size	No	Long	Number of result rows. The value ranges from 1 to 1000. The default rate limit is 1000.
  queue-name	No	String	Name of the execution queue for obtaining job results. If this parameter is not specified, the default system queue is used.

  

  The following is an example of the URL containing the query parameter:

  GET /v1.0/{project_id}/jobs/{job_id}/preview?page-size={size}&queue-name={queue_name}

Request

None

Response

Example Request

None

Example Response

{
  "is_success": true,
  "message": "",
  "job_id": "ead0b276-8ed4-4eb5-b520-58f1511e7033",
  "job_type": "QUERY",
  "row_count": 1,
  "input_size": 74,
  "schema": [
    {
      "c1": "int"
    },
    {
      "c2": "string"
    }
  ],
  "rows": [
    [
      23,
      "sda"
    ]
  ]
}

Status Codes

Table 4 describes the status code.

Error Codes

If an error occurs when this API is invoked, the system does not return the result similar to the preceding example, but returns the error code and error information. For details, see Error Code.