It looks like a syntax error. You have the query wrapped in single quotes in your python code and also have the
'1' wrapped in single quotes. You will need to either escape the single quotes on the
'1' or remove the single quotes.
That was it! I think the output was a little misleading, but you were right. I had to escape the single quotes of the '1' in the boto3 athena query, which was not necessary in athena query editor.
FYI, removing the quotes did work, and resulted in another syntax error. Thanks you!
Can i execute an Athena saved query from lambda?Accepted AnswerMODERATORasked 3 years ago
Athena Query timeoutasked 4 months ago
Amazon Athena query history reportAccepted Answerasked 2 years ago
Athena permission error running a query
Can I use the ID of my saved query to start query execution in Athena SDK?asked 4 months ago
How can I find the Query ID for an Athena Saved Query on AWS console?asked 8 months ago
Unable to run Athena query with AmazonAthenaPreviewFunctionality workgroupAccepted Answerasked 2 years ago
When querying athena using aws sdk, is it necessary to save results in s3?Accepted Answerasked 3 months ago
INVALID_INPUT in Athena Query
I cannot use current_date + interval in Athena boto3 query in LambdaAccepted Answerasked 7 months ago