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.

질문됨 일 년 전552회 조회
1개 답변
1
수락된 답변

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

답변함 일 년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠