Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Athena query returns values from wrong columns. How to troubleshoot?

0

I have a simple query in athena, select avg price, group by country. It is returning 4 rows, 1 for canada, 1 for usa, and then 2 rows with dates in the country column. This seems to be a bug. What can be done to understand what is going wrong? I am new to athena completely.

Athena is querying a db in glue that has indexed the metadata of a csv file in s3 with its crawler. I have downloaded the csv from s3, and it looks fine.

Topics
Analytics
Tags
AWS GlueAmazon Athena
Language
English

asked 4 years ago951 views

1 Answer
1
Accepted Answer

I removed all special characters in glue data brew then re processed the data and it worked fine in athena. it seems columns with forward slashes were messing up athena's query results

answered 4 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content