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;