Renaming column name in Athena

0 votes
Normal DDL commands does not affect the table (They cannot be executed). I am trying to change a column name in an AWS Athena table old_name to new_name. Is It possible to change a column name without deleting and re-creating the table from scratch?

Can someone help?
Jan 16 in AWS by Anjali
• 2,910 points
112 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

You can use :-

ALTER TABLE %%table-name%% CHANGE %%old-column-name%% %%new-column-name%%<string>;

You can find more about supported and unsupported DDLs here.

Hope this helps

answered Jan 16 by julie

Related Questions In AWS

+3 votes
5 answers

Renaming files in S3

You can either use AWS CLI or ...READ MORE

answered Oct 16, 2018 in AWS by petter dj
376 views
0 votes
1 answer

How to skip headers when reading a CSV file in S3 and creating a table in AWS Athena?

This is a known deficiency. The best ...READ MORE

answered Sep 4, 2018 in AWS by Archana
• 3,770 points
491 views
0 votes
1 answer

Pivot rows into columns in AWS Athena?

You can use the following method :- It ...READ MORE

answered Oct 29, 2018 in AWS by Priyaj
• 56,120 points
436 views
0 votes
1 answer

How to convert String to Date in Amazon Athena?

You can use date_parse. All you need ...READ MORE

answered Jan 16 in AWS by chandan
454 views
0 votes
1 answer
+1 vote
2 answers
0 votes
1 answer

How to Use hypen as key name in dynamo db mapper

It seems you cannot have a column ...READ MORE

answered Aug 22, 2018 in AWS by Priyaj
• 56,120 points
62 views
0 votes
1 answer

Is it possible to create view in Athena?

AWS Athena does not support creating any ...READ MORE

answered Jan 16 in AWS by Zullu
34 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.