DROP BLOOM FILTER INDEX

Applies to: Databricks SQL Databricks Runtime

重要

Bloom filter indexes are deprecated. Databricks recommends dropping all existing Bloom filter indexes. See Bloom filter indexes (deprecated) for details and recommended alternatives. This deprecation applies only to Delta Lake Bloom filter indexes, not to Bloom filters in Parquet files. See Parquet Bloom filters.

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

• Bloom filter indexes (deprecated)