Store Table Properties

POST /api/v1.2/hive/schema/table

Modify metadata of tables in the given schema of the hive metastore.

Required Role

The following users can make this API call:

  • Users who belong to the system-admin group.

  • Users who belong to a group associated with a role that allows modifying Hive table metadata in Qubole. See Managing Groups and Managing Roles for more information.



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




Number representing the interval at which data is loaded.


Unit of the interval. Valid values are minutes, hours, days, weeks and months.


JSON Hash with Date/Time Format of partition columns. Date format should be a valid input to the strftime function. If there are no partition columns, then it should be an empty hash. For partition columns that are not date/time, the value should be an empty string.


Imagine a table daily_tick_data in the default hive schema that has the following partitions

  1. stock_exchange

  2. stock_symbol

  3. year

  4. date

$ cat payload.json
 "interval": 1,
 "interval_unit": "days",
 "columns": {
     "stock_exchange": "",
     "stock_symbol": "",
     "year": "%Y",
     "date": "%Y-%m-%d"
$ curl -i -X POST -H "Accept: application/json" \
     -H "Content-type: application/json" \
     --data @payload.json \


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