Hi all, a quick question, it there a way to add a new column with a default value? in this case is boolean column and i want to set all previous records to false

df.select("*", lit(False).alias("colname"))

appends a new column of Booleans

i was expecting a way to do an alter table, not overwriting the whole table

alter table changes metadata, adding a new column of values isn't metadata

some kind of metadata to fill the column with a default value but i see that is not the case