View a Hive Table Definition

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

Use this API to get the Hive table definition. This API also fetches AVRO table schema.

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 -i -X GET -H "Accept: application/json" -H "Content-type: application/json" -H "X-AUTH-TOKEN: $AUTH_TOKEN" \
https://api.qubole.com/api/v1.2/hive/default/miniwikistats

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

[
    {
        "name": "projcode",
        "type": "string",
        "comment": null
    },
    {
        "name": "pagename",
        "type": "string",
        "comment": null
    },
    {
        "name": "pageviews",
        "type": "int",
        "comment": null
    },
    {
        "name": "bytes",
        "type": "int",
        "comment": null
    },
    {
        "name": "dt",
        "type": "string",
        "comment": null
    }
]