databendlabs / databend

𝗗𝗮𝘁𝗮, 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 & 𝗔𝗜. Modern alternative to Snowflake. Cost-effective and simple for massive-scale analytics. https://databend.com
https://docs.databend.com
Other
7.71k stars 732 forks source link

Feature: Alter table unset options #16436

Open dantengsky opened 2 weeks ago

dantengsky commented 2 weeks ago

Summary

e.g.

ALTER TABLE t UNSET OPTIONS (data_retention_period_in_hours);

which removes the option from table t, if applicable (not all the table options are allowed to be removed)

dosubot[bot] commented 2 weeks ago

To implement the feature to alter a table and unset options, such as removing the data_retention_period_in_hours option from a table, you can use the following SQL statement:

ALTER TABLE t UNSET OPTIONS(data_retention_period_in_hours);

This statement will remove the data_retention_period_in_hours option from the table t [1].

To continue talking to Dosu, mention @dosu.