Delete an analytical store by using Tablestore SDK for Java - Tablestore

Use Tablestore SDK for Java to delete an analytical store that is no longer needed and optionally delete the associated SQL mapping table.

Prerequisites

Install Tablestore SDK for Java and initialize a time series model client. Analytical store operations require Tablestore SDK for Java 5.15.0 or later. We recommend that you use the latest version.

Feature description

Call the deleteTimeseriesAnalyticalStore method to delete an analytical store. You can use dropMappingTable to specify whether to also delete the associated SQL mapping table.

public DeleteTimeseriesAnalyticalStoreResponse deleteTimeseriesAnalyticalStore(DeleteTimeseriesAnalyticalStoreRequest request) throws TableStoreException, ClientException

Important

After an analytical store is deleted, the analytical store and its data cannot be recovered. The source time series table and its data are not affected.

The following sample code deletes example_analytical_store from example_timeseries_table and also deletes the associated SQL mapping table.

TimeseriesClient timeseriesClient = client.asTimeseriesClient();

DeleteTimeseriesAnalyticalStoreRequest request =
        new DeleteTimeseriesAnalyticalStoreRequest(
                "example_timeseries_table", "example_analytical_store");
request.setDropMappingTable(true);

timeseriesClient.deleteTimeseriesAnalyticalStore(request);

Parameters

DeleteTimeseriesAnalyticalStoreRequest contains the following parameters.

Name	Type	Description
timeseriesTableName (required)	`String`	The name of the time series table.
analyticalStoreName (required)	`String`	The name of the analytical store.
dropMappingTable (optional)	`boolean`	Specifies whether to also delete the SQL mapping table associated with the analytical store. Default value: `false`. A value of `true` deletes the mapping table, and a value of `false` retains it.