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

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.