If you do the following as per the docs does it still fail?
SELECT * FROM "my_database"."my_table" WHERE year = ? and month= ? and day= ?
Parameterized queries are supported only in Athena engine version 2.
Are you running the latest engine version in the specified workspace?
INVALID_INPUT in Athena Queryasked 8 months ago
Does Athena support query caching?asked 4 years ago
Athena query "Access denied when writing to location: s3://***"asked 10 days ago
Odd Athena Query Performance Issueasked 5 months ago
Athena permission error running a queryasked 7 months ago
Athena Parameterized Query does not ask for parameter valuesasked 16 days ago
How can I find the Query ID for an Athena Saved Query on AWS console?asked 8 months ago
When querying athena using aws sdk, is it necessary to save results in s3?Accepted Answerasked 3 months ago
I cannot use current_date + interval in Athena boto3 query in LambdaAccepted Answerasked 8 months ago
Unable to run Athena query with AmazonAthenaPreviewFunctionality workgroupAccepted Answerasked 2 years ago