Drop Bloom Filter Index (Delta Lake on Databricks)

Important

This documentation has been retired and might not be updated. The product, service, or technology mentioned in this content is no longer supported. See DROP BLOOM FILTER INDEX (Delta Lake on Databricks).

DROP BLOOMFILTER INDEX
ON [TABLE] table_name
[FOR COLUMNS(columnName1, columnName2, ...)]

Drop a Bloom filter index.

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.