You have to add the query you're trying to run and your table structure from Athena, otherwise it would be so hard to help you.

Usually Athena works with JSON based on the way you configured the crawler to read the data and store it from your S3 files, maybe you stored the data as normal string and you're trying to access one of the attributes or your parsed structure is not what you're actually expecting and for this you have to check the table structure