DROP BLOOM FILTER INDEX

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Drops a Bloom filter index.

Syntax

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

Parameters

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.