Status Update
No update yet.
Comments
ga...@google.com
Hello,
Thank you for contacting Google Cloud Platform Support.
The issue/error you are experiencing is due to the time travel feature
There is already an open feature request
I will proceed to mark this thread as duplicate of
sa...@snaplogic.com
I think the time travel feature should prohibit the creation of previously deleted columns. But in my scenario, I am trying to add another column (with a different name).
But anyway, I get the same error.
Description
Drop column functionality breaks the table. After I drop a column from the table, I can't add/drop any other columns.
BigQuery throws an error:
"message": "Column `test1` was recently deleted in the table `salim_test_table`. Deleted column name is reserved for up to the time travel duration, use a different column name instead.",
I get that error when I am trying to add/drop any other columns.
What you expected to happen:
I expect to add/drop columns successfully.
Steps to reproduce:
Execute following queries. You'll get an error after executing last query.
create table tony.salim_test_table
(
test1 numeric,
test2 string,
test3 BOOLEAN,
test4 DATE,
test5 DATE,
test6 string,
test7 string
);
alter table tony.salim_test_table add column test8 numeric;
alter table tony.salim_test_table drop column test1;
alter table tony.salim_test_table add column test9 numeric;