Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-01-2021 02:07 PM
Is the table you are working with in the Delta format? The table commands (i.e. Alter) do not work for all storage formats.
For example if I run the following commands then I can alter a table. Note - there is no data in the table but the table exists and I can alter the table.
create table if not exists add_col_test (
col_one integer,
col_two integer
)
USING DELTA
;
describe add_col_test;
alter table add_col_test ADD columns (col_three boolean);
describe add_col_test;