Problem with data showing null value when executing Query twice in athena

0

I fetched data from S3 from athena and ran a Query that looked at 10 rows.

The first run shows the table, the second table gets null values.

If you delete the result folder executed in athena from within the bucket, it will be executed again.

But I want to check the table without deleting the folder.

Thanks for your help.

질문됨 2년 전367회 조회
1개 답변
1
수락된 답변

Based on what is happening, it seems as though the query results location is writing into the same location as the Athena table and that seems to be causing the issue. I suggest the following steps to set up another location for the Athena query results.

  1. Click on Settings tab in the Athena console
  2. Click the manage button
  3. Choose the bucket (Ideally we create a separate bucket for Athena). you can choose a folder result such as bucket-name/athena_results/team_name/user_name. If you end up using the same bucket as the data location, ensure the folder location and the athena results location are different.
profile pictureAWS
답변함 2년 전

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

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

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

관련 콘텐츠