1 Answer
- Newest
- Most votes
- Most comments
0
【以下的回答经过翻译处理】 您可以在 Athena 文档中找到有关向表中添加列的更多信息
或者你可以使用 CTAS
例如,您有一张表
CREATE EXTERNAL TABLE sample_test( id string) LOCATION 's3://bucket/path' and you can create another table from sample_test with the query
CREATE TABLE new_test AS SELECT *, 'new' AS new_col FROM sample_test
您可以在 AS 之后使用任何可用的查询
Relevant content
- asked 10 months ago
- Accepted Answerasked 2 months ago
- asked a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated a month ago
- AWS OFFICIALUpdated 4 months ago