Drop a Kudu table using Impala
You can drop internal tables in Impala using the DROP TABLE syntax. If you want to drop an external table, you first have to change it to internal.
CREATE TABLE, the standard
DROP TABLEsyntax drops the underlying Kudu table and all its data.
DROP TABLE my_first_table;
If the table was created as an external table, using
CREATE EXTERNAL TABLE, the mapping between
Impala and Kudu is dropped, but the Kudu table is left intact, with all its data. To change
an external table to internal, and the other way around, see Altering table