Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

INVALID_TABLE_PROPERTY in Athena

0

Why this error in table query of Athena INVALID_TABLE_PROPERTY: Must provide a range to build a projected temporal partition column! (property: projection.datehour.range) This query ran against the "default" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: ead7a5df-def6-402c-b28e-f2ea10db31a6

Topics
Analytics
Tags
Amazon Athena
Language
English
asked 2 years ago378 views
1 Answer
1

It's likely that there's something wrong with the partition projection in your table definition. If you can do a SHOW CREATE TABLE `my_table_name`; and paste the output here, it might be easy to spot. Make sure to redact the real name of your S3 bucket, table, and anything else that might be sensitive before posting the output here.

EXPERT
answered 2 years ago

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.

Relevant content