datafuselabs / databend

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

Feature: Alter table unset options #16436

Open dantengsky opened 1 week ago

dantengsky commented 1 week 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 1 week 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.