DROP BLOOM FILTER INDEX

Applies to: check marked yes Databricks SQL Databricks Runtime

Drops a Bloom filter index.

Syntax

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

Parameters

table_name

Identifies an existing Delta table. The name must not include a temporal specification or options 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.