• MapReduce Service

mrs
  1. Help Center
  2. MapReduce Service
  3. User Guide
  4. Using MRS
  5. Using CarbonData
  6. Deleting a CarbonData Table

Deleting a CarbonData Table

Scenario

Unused CarbonData tables can be deleted. After a CarbonData table is deleted, its metadata and loaded data are deleted together.

Procedure

  1. Run the following command to delete a CarbonData table.

    DROP TABLE [IF EXISTS] [db_name.]table_name;

    db_name is optional. If db_name is not specified, the table named table_name in the current database is deleted.

    For example, run the following command to delete the productSalesTable table in the productdb database:

    DROP TABLE productdb.productSalesTable;

  2. Run the following command to check whether the table is deleted.

    SHOW TABLES;