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.
Related articles
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for