Amazon Athena lets you parse JSON-encoded values, extract data from JSON, search for values, and find length and size of JSON arrays.
You get this error if you used an incorrect SerDe during table definition. For example, the table might be using a JSON SerDe, and the source data includes Parquet objects. 
To resolve this error, check the source data and confirm that the correct SerDe is used. For more information, see Supported SerDes and data formats 
Hi, Thanks for response. I changed the ROW FORMAT serde to 'org.openx.data.jsonserde.JsonSerDe'. Now I am getting the information I need. Really appreciate your help.
No problem. Happy to help. :)
Hi There In addition to the above answer, are you able to see TLSDetails in Athena? Take a look at this blog post which mentions that TLSDetails isn't yet supported in Athena.
Amazon Athena: You can query AWS CloudTrail logs in Amazon Athena, and we will be adding support for querying the TLS values in your CloudTrail logs in the coming months. Look for updates and announcements about this in future AWS Security Blog posts.
One recommendation is to use AWS CloudTrail Lake: You can follow the steps, and use the sample TLS query, in the blog post Using AWS CloudTrail Lake to identify older TLS connections. There is also a built-in sample CloudTrail TLS query available in the AWS CloudTrail Lake console.
Athena Query Error on LIBSVM file in S3asked 2 months ago
Can I use the ID of my saved query to start query execution in Athena SDK?asked 4 months ago
Query JSON files from S3 with AthenaAccepted Answerasked 13 days ago
Using Cloud Trail Console to view all events in multi-account CloudTrail ( created via Organizations )Accepted Answerasked 5 months ago
Import Custom Logs from S3 to CloudWatchAccepted Answerasked 25 days ago
Query DynamoDB Backup to S3 with AthenaAccepted Answerasked a month ago
Sagemake couldn't access S3 vis athena queryasked 6 months ago
Cross-Account Connect Athena (account X) to Glue + S3 (account Y)asked 3 months ago
Avoid metadata from Athena with Boto 3asked 6 months ago
Can i execute an Athena saved query from lambda?Accepted AnswerMODERATORasked 3 years ago