View Automatic Statistics Commands

GET api/v1.2/admin_commands

Use this API to view automatic statistics commands that are running or queued for a Hive table.

Required Role

Users who belong to the system-admin group can make this API call.

See Managing Groups and Managing Roles for more information.

Parameters

Note

Parameters marked in bold below are mandatory. Others are optional and have default values.

Parameter Description
per_page It denotes the number of the statistics command that you can retrieve per page. Its default value is 10 and its maximum value is 100.
start_date The date from which you want the command history (inclusive). Its default value is 7 days before the end date. This parameter also supports timestamp in the UTC timezone (YYYY-MM-DDTHH:MM:SSZ) format. It cannot be earlier than 60 days from the end_date.
end_date The date until which you want the command history (inclusive). Its default value is today. This parameter also supports timestamp in the UTC timezone (YYYY-MM-DDTHH:MM:SSZ) format.

Request API Syntax

Here is the API syntax to view the list of automatic statistics commands using the CuRL utility.

curl -i -X GET -H "X-AUTH-TOKEN:$AUTH_TOKEN" -H "Content-Type:application/json" -H "Accepts:application/json" \
-d '{"start_date":"<start date>", "end_date":"<end date>", "per_page":"<count>"}'  \
"https://api.qubole.com/api/v1.2/admin_commands"

Here is the API syntax to view a specific automatic statistics command using the CuRL utility.

curl -i -X GET -H "X-AUTH-TOKEN:$AUTH_TOKEN" -H "Content-Type:application/json" -H "Accepts:application/json" \
"https://api.qubole.com/api/v1.2/admin_commands/<command-id>"

Sample API Request

Here is a sample request to view the list of automatic statistics commands.

curl -i -X GET -H "X-AUTH-TOKEN:$AUTH_TOKEN" -H "Content-Type:application/json" -H "Accepts:application/json" \
-d '{"start_date":"2020-02-27T01:00:00Z", "end_date":"2020-02-15T01:00:00Z", "per_page":"20"}'  \
"https://api.qubole.com/api/v1.2/admin_commands"

Here is a sample request to view a specific auto statistics command with 15 as its ID.

curl -i -X GET -H "X-AUTH-TOKEN:$AUTH_TOKEN" -H "Content-Type:application/json" -H "Accepts:application/json" \
"https://api.qubole.com/api/v1.2/admin_commands/15"