Skip to content

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?

Topics: Analytics
Tags: Amazon Athena
Language: English

asked 7 years ago2.7K views

No Answers

Newest
Most votes
Most comments

Relevant content

How to add a column with Korean characters in Iceberg via Athena?
hyunjin
asked a year ago
How can I rename a column on an iceberg table in Athena?
rePost-User-7671420
asked 3 years ago
How to query Athena Table that has a dash character in a column name?
rePost-User-3464203
asked a year ago
Athena Apache Iceberg S3 table ALTER TABLE ADD COLUMNS doesn't work if table has a map column
Abdul Rauf
asked 8 months ago
Why do I get zero records when I query my Athena table?
AWS OFFICIALUpdated 9 months ago
Why is the TIMESTAMP result empty when I query a table in Amazon Athena?
AWS OFFICIALUpdated 2 years ago
Why does my Athena query fail with the error "HIVE_INVALID_METADATA: Hive metadata for table is invalid: Table descriptor contains duplicate columns"?
AWS OFFICIALUpdated 2 years ago
How do I resolve timestamp exceptions when I query a table in Athena?
AWS OFFICIALUpdated 10 months ago
Querying Apache Iceberg Tables in Amazon Athena
EXPERT
Sandhya Khanderia
published a year ago
How to Analyze your AWS IoT Logs with Standard SQL queries
EXPERT
Charlyscott237
published 3 years ago