spectrum ALTER EXTERNAL TABLE to add column

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

主题

分析

标签

Amazon Redshift

语言

English

ylp2

已提问 4 年前1692 查看次数

1 回答

最新
投票最多
评论最多

这些答案有用吗？为正确答案投票，以帮助社区从您的知识中受益。

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 年前

专家

Giovanni Lauria

已审核 1 个月前

spectrum ALTER EXTERNAL TABLE to add column

相关内容