The DDB table was exported from DynamoDB to S3 and I would like to run some Athena queries against the table. Table’s items have two keys (PK and pk) which are the same when they are in lowercase.
Currently tables has two items only:

The DDB table was exported from DynamoDB to S3 and I would like to run some Athena queries against the table. Table’s items have two keys (PK and pk) which as the same when they are in lowercase.
Currently tables has two items only:

I have below SQL query that runs as to aggregate data, with intermediary steps. However I run into “Query exhausted resources at this scale factor error” however I change it.

Every thing was working fine then i was notice May 24 result was fine but after that date data is missing then delete the old data and June-6-6 data was empty up querying but seeing that data exist in logs even i can download the logs and data in files but not on athena

I have below records

I’m querying the data from a table in Athena and there is one field, repayment_status_updated_at, which is formatted like what I have above (+55869-09-22 10:12:07.000). Is there a way to format this field into a usable date/time format?

I have an int stored in my s3 file and the table has int as a type. However, randomly athena seems to be adding a .0 to the end of the int for some files and not others and returning the following error:

i will using a athena for the data extraction from s3