title: Athena query to find the size of directory in s3 bucket
body: <p>I have a requirement to find the size of each directories in S3 bucket. I know that it is easily achievable through the get size option in the AWS S3 console but I have lot of directories to check and checking size of each directory manually seems to be tedious. I'm looking for some effective way to get the size through Athena</p>
  <p><strong>I can export the S3 contents to the Athena table but is there any way to calculate the size of the contents through query ?</strong></p>