Create table index country_idx (TUPLE)
POST {{base_rest_url}}{{rest_schema}}/{{rkeyspace}}/tables/{{rtable}}/indexes
{{baseurl}}/v2/schemas/keyspaces/userskeyspace/tables
{
name
: users
,
columnDefinitions
:
[
{
name
: firstname
,
typeDefinition
: text
},
{
name
: lastname
,
typeDefinition
: text
},
{
name
: favorite color
,
typeDefinition
: text
}
],
primaryKey
:
{
partitionKey
: [firstname
],
clusteringKey
: [lastname
]
},
tableOptions
:
{
defaultTimeToLive
: 0,
clusteringExpression
:
[{ column
: lastname
, order
: ASC
}]
}
}
Request Params
Key | Datatype | Required | Description |
---|---|---|---|
pretty | string | format results |
Request Body
{"column"=>"current_country", "name"=>"country_idx", "ifNotExists"=>true}
HEADERS
Key | Datatype | Required | Description |
---|---|---|---|
X-Cassandra-Token | string | (Required) The token returned from the authorization endpoint. Use this token in each request to the database. | |
Content-Type | string |
RESPONSES
status: Created
{"name":"users"}