Amazon Athena ALTER TABLE ADD PARTITION query giving missing column error

Question

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?

Answer 1

Try removing Double quotes and execute.

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