CODEWITHSUNDEEP
amazon-web-servicesamazon-athena
kamal11
kamal11

Reputation: 384

Amazon Athena ALTER TABLE ADD PARTITION query giving missing column error

ALTER TABLE "herdsysa"."temperature" ADD IF NOT EXISTS PARTITION (dt='2020-02-03')

I am trying to run this query on athena workbench but it says missing column at if (service: amazonathena; status code: 400; error code: invalidrequestexception; request id: 935dfae3-a4af-4438-be16-10d7884c9292)

anybody know how to make this work?

Upvotes: 3

Views: 3921

Answers (1)

Arun Palanisamy
Arun Palanisamy

Reputation: 5459

Try removing Double quotes and execute.

 ALTER TABLE herdsysa.temperature ADD IF NOT EXISTS PARTITION (dt='2020-02-03')

Upvotes: 3

Related Questions