Skip to main content

ALTER TABLE OPTION

Introduced: v1.2.25

Modifies the options of a table created with the default Fuse engine. For the available options you can modify, see Options.

Syntax

ALTER TABLE [database.]table_name SET OPTIONS (options)

Examples

create table t(a int, b int);

alter table t set options(bloom_index_columns='a');

set hide_options_in_show_create_table=0;

show create table t;
+-------+-------------------------------------------------------------------------+
| Table | Create Table |
+-------+-------------------------------------------------------------------------+
| t | CREATE TABLE `t` (
`a` INT,
`b` INT
) ENGINE=FUSE BLOOM_INDEX_COLUMNS='a' COMPRESSION='zstd' STORAGE_FORMAT='parquet' |
+-------+-------------------------------------------------------------------------+

-- disable all the bloom filter index.
alter table t set options(bloom_index_columns='');

show create table t;
+-------+-------------------------------------------------------------------------+
| Table | Create Table |
+-------+-------------------------------------------------------------------------+
| t | CREATE TABLE `t` (
`a` INT,
`b` INT
) ENGINE=FUSE BLOOM_INDEX_COLUMNS='' COMPRESSION='zstd' STORAGE_FORMAT='parquet' |
+-------+-------------------------------------------------------------------------+
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today