INVALID_FUNCTION_ARGUMENT: Invalid format: "trnNo" ERROR

Anyone who encountered this error? INVALID_FUNCTION_ARGUMENT: Invalid format: "trnNo"

Topics

Analytics

Tags

Amazon Athena

Language

English

rePost-User-2384558

asked a year ago189 views

1 Answer

Newest
Most votes
Most comments

Are these answers helpful? Upvote the correct answer to help the community benefit from your knowledge.

Is "trnNo" a column in your table? If yes, then check its data type and the value you are using to filter it. Most likely this is due to data type cast error. More details about the actual query will help us guide further.

EXPERT

Gokul

answered a year ago

Relevant content

Athena error: INVALID_FUNCTION_ARGUMENT Invalid format: ""
jsteele
asked 2 years ago
Invalid format for date
AWS-User-2304919
asked 2 years ago
Date_Parse INVALID_FUNCTION_ARGUMENT: Invalid format
Div99
asked 5 years ago
INVALID_FUNCTION_ARGUMENT: Invalid format: ""
Accepted Answer
lisannegesch
asked 2 years ago
How do I troubleshoot invalid SAML response errors users might receive when they federate into Amazon Cognito?
AWS OFFICIALUpdated a year ago
Why do I get the "EMR_DefaultRole is invalid" or "EMR_EC2_DefaultRole is invalid" error when I create an Amazon EMR cluster?
AWS OFFICIALUpdated 2 years ago
Why do I get an "Invalid MAIL FROM" or "Invalid RCPT TO" error response from an Amazon SES SMTP endpoint?
AWS OFFICIALUpdated 2 months ago
How do I resolve template validation or template format errors in CloudFormation?
AWS OFFICIALUpdated 2 months ago
AWS Transfer Family announces structured JSON log format
EXPERT
AWS
published 10 months ago
Troubleshooting "The Access Key ID or Security Token is Invalid" Error after Upgrading DynamoDB Local to Version 2.0.0 / 1.23.0 or Greater
EXPERT
Leeroy Hannigan
published 10 months ago