spectrum ALTER EXTERNAL TABLE to add column

0

Is it possible to use ALTER EXTERNAL TABLE to add columns? or the whole table needs to be dropped & re-created with all partitions ?

Thanks

ylp2
已提问 4 年前1842 查看次数
1 回答
0

Hi yip2,

The Redshift doc clearly explains that you can alter an external table to add a column, but there are limitation to what other clauses and column properties can be included. See the doc. page here: https://docs.aws.amazon.com/redshift/latest/dg/r_ALTER_TABLE.html

I hope this answers your question.

Regards,
-Kurt

klarson
已回答 4 年前
profile picture
专家
已审核 3 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则