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?
Try removing Double quotes and execute.
ALTER TABLE herdsysa.temperature ADD IF NOT EXISTS PARTITION (dt='2020-02-03')