Updated on 2022-09-22 GMT+08:00

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 confirm that the table is deleted:

    SHOW TABLES;