Getting error while querying on athena HIVE_INVALID_PARTITION_VALUE

0

Getting the below error while querying on Athena -

HIVE_INVALID_PARTITION_VALUE: Invalid partition value 'Unsaved-2023-03 22:00:00' for TIMESTAMP partition key: ingest_timestamp=Unsaved-2023-03 22%3A00%3A00 This query ran against the "due_eventdb" database unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: b923ebaa-8ea4-42f4-bbb4-b5f6b1d6041a

I have deleted the following directory "Unsaved-2023-03 22%3A00%3A00" from the S3 bucket still getting the same error.

asked a year ago107 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions