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

• 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.

Related articles

• CREATE BLOOMFILTER INDEX