By using AWS re:Post, you agree to the Terms of Use

Can we add column to an existing table in AWS Athena using SQL query?

0

I have a table in AWS Athena which contains 2 records. Is there a SQL query using which a new column can be inserted in to the table?

asked 3 years ago400 views
1 Answer
0
Accepted Answer

You can find more information about adding columns to table in Athena documentation

Or you can use CTAS

For example, you have a table with

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
You can use any available query after AS

answered 3 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions