68 lines
2.6 KiB
Markdown
68 lines
2.6 KiB
Markdown
|
|
Use the [`influxdb3 delete last_cache` command](/influxdb3/version/reference/cli/influxdb3/delete/last_cache/)
|
|
to delete a Last Value Cache (LVC). Provide the following:
|
|
|
|
- **Database** (`-d`, `--database`): _({{< req >}})_ The name of the database
|
|
that the LVC you want to delete is associated with. You can also use the
|
|
`INFLUXDB3_DATABASE_NAME` environment variable to specify the database.
|
|
- **Token** (`--token`): _({{< req >}})_ Your {{< product-name >}}
|
|
{{% show-in "enterprise" %}}admin {{% /show-in %}}authentication token.
|
|
You can also use the `INFLUXDB3_AUTH_TOKEN` environment variable to specify
|
|
the database.
|
|
- **Table** (`-t`, `--table`): _({{< req >}})_ The name of the table that the
|
|
LVC you want to delete is associated with.
|
|
- **Cache name**: The name of the LVC to delete.
|
|
|
|
{{% code-placeholders "(DATABASE|TABLE|LVC)_NAME|AUTH_TOKEN" %}}
|
|
```bash
|
|
influxdb3 delete last_cache \
|
|
--database DATABASE_NAME \
|
|
--token AUTH_TOKEN \
|
|
--table TABLE_NAME \
|
|
LVC_NAME
|
|
```
|
|
{{% /code-placeholders %}}
|
|
|
|
## Use the HTTP API
|
|
|
|
To use the HTTP API to delete a Last Value Cache, send a `DELETE` request to the `/api/v3/configure/last_cache` endpoint with query parameters.
|
|
|
|
{{% api-endpoint method="DELETE" endpoint="/api/v3/configure/last_cache" api-ref="/influxdb3/core/api/v3/#operation/DeleteConfigureLastCache" %}}
|
|
|
|
{{% code-placeholders "(DATABASE|TABLE|LVC)_NAME|AUTH_TOKEN" %}}
|
|
```bash
|
|
curl -X DELETE "https://localhost:8181/api/v3/configure/last_cache?db=DATABASE_NAME&table=TABLE_NAME&name=LVC_NAME" \
|
|
--header "Authorization: Bearer AUTH_TOKEN"
|
|
```
|
|
{{% /code-placeholders %}}
|
|
|
|
## Example
|
|
|
|
```bash
|
|
curl -X DELETE "https://localhost:8181/api/v3/configure/last_cache?db=example-db&table=home&name=homeLastCache" \
|
|
--header "Authorization: Bearer 00xoXX0xXXx0000XxxxXx0Xx0xx0"
|
|
```
|
|
|
|
**Response codes:**
|
|
|
|
- `200` : Success. The last cache has been deleted.
|
|
- `400` : Bad request.
|
|
- `401` : Unauthorized.
|
|
- `404` : Cache not found.
|
|
|
|
Replace the following:
|
|
|
|
- {{% code-placeholder-key %}}`DATABASE_NAME`{{% /code-placeholder-key %}}:
|
|
the name of the database that the LVC you want to delete is associated with
|
|
- {{% code-placeholder-key %}}`AUTH_TOKEN`{{% /code-placeholder-key %}}:
|
|
your {{< product-name >}} {{% show-in "enterprise" %}}admin {{% /show-in %}}
|
|
authentication token
|
|
- {{% code-placeholder-key %}}`TABLE_NAME`{{% /code-placeholder-key %}}:
|
|
the name of the table that the LVC you want to delete is associated with
|
|
- {{% code-placeholder-key %}}`LVC`{{% /code-placeholder-key %}}:
|
|
the name of the LVC to delete
|
|
|
|
> [!Caution]
|
|
> This is a destructive action that cannot be undone. Once deleted, any queries
|
|
> against the deleted LVC will return an error.
|