DROP BLOOM FILTER INDEX
Applies to: Databricks SQL Databricks Runtime
Drops a Bloom filter index.
Syntax
DROP BLOOMFILTER INDEX
ON [TABLE] table_name
[FOR COLUMNS(columnName1 [, ...] ) ]
Parameters
-
Identifies an existing Delta table. The name must not include a temporal specification.
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.