- Newest
- Most votes
- Most comments
Hello,
According to below documentation
https://docs.aws.amazon.com/athena/latest/ug/data-types.html
The timestamp compatible format in Athena is YYYY-MM-DD HH:MM:SS.SSS for example, timestamp '2008-09-15 03:04:05.324'.
So, I would recommend you to run "SHOW PARTITIONS <table_name> and check if the partitions are in the correct format. If you find any partitions not in the right format, please drop the particular partition and reload the partition in the correct format. Use the following query to drop partition:
ALTER TABLE <table_name> DROP PARTITION (xxx_timestamp = " ")
Or you can change the datatype of the this column to string from Glue console and try running the query again.
Tables-> click table to update -> Actions -> Edit Schema -> Select field -> Edit -> Data type:String
Viewing and Editing Table Details - https://docs.aws.amazon.com/glue/latest/dg/console-tables.html
Relevant content
- asked 2 years ago
- asked 3 months ago
- Accepted Answerasked 9 months ago
AWS OFFICIALUpdated 3 years ago- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 4 months ago
I would suggest you take the chance of the migration to change that, even if you can fix it, using a timestamp as a partition sounds problematic, first because it has too much granularity and also because it's going to reduce the compatibility with client tools and cause you difficulties. You can do the same thing with a string.