View Table Partitions and Location

GET /api/v1.2/hive/<schema_name>/<table>/partitions

Use this API to get the Hive table partitions and locations.

Required Role

The following users can make this API call:

  • Users who belong to the system-user or system-admin group.

  • Users who belong to a group associated with a role that allows viewing a Hive table definition. See Managing Groups and Managing Roles for more information.

Example

curl -X GET -H "Accept: application/json" -H "Content-type: application/json" -H "X-AUTH-TOKEN: 02a9528b98ad4b0c8abe
50fd4535960d7777s37b18514fffa41017f5dac16e2b" "https://api.qubole.com/api/v1.2/hive/default/cars/partitions"

Note

The above syntax uses https://api.qubole.com as the endpoint. Qubole provides other endpoints to access QDS that are described in Supported Qubole Endpoints on Different Cloud Providers.

Sample Response

[
     {
        "PART_NAME":"year=2013/month=1",
        "LOCATION":"s3n://dev.canopydata.com/sqoop/qa/account_id/4646/warehouse/cars/year=2013/month=1"
     }
]