DROP BLOOM FILTER INDEX
Applies to: Databricks SQL Databricks Runtime
Drops a Bloom filter index.
DROP BLOOMFILTER INDEX ON [TABLE] table_name [FOR COLUMNS(columnName1 [, ...] ) ]
The command fails if either the table name or one of the columns does not exist. All Bloom filter related metadata is removed from the specified columns.
When a table does not have any Bloom filters, the underlying index files are cleaned when the table is vacuumed.
Submit and view feedback for